MSSQL Login Failed

I tried to login to my SQL Server with a new user I created and got following error:
Login failed for user ‘root’. The user is not associated with a trusted SQL Server connection.

You need to activate MS Sql Authentication and Windows Authentication Mode:
1. Open MS SQL Server Manegement Studio
2. Right click on the server
3. Properties
4. Security
5. Change from Windows Authentication Mode to SQL Server and Windows Authentication mode

No Comments »

admin on May 11th 2008 in IT, MSSQL

MUST_CHANGE is ON

I tried to remove the check_policy and check_expiration from a user and got following error in MS SQL Server:

I forgot to remove the must change password flag when I created the user. A simple SQL query to change the users password solved the problem:

ALTER LOGIN %USERNAME% WITH PASSWORD='%PASSWORD%'

									

No Comments »

admin on May 11th 2008 in IT, MSSQL

Version MS SQL Server

Here a simple MS Query to get the version of MS SQL Server:
select @@version

No Comments »

admin on May 6th 2008 in IT, MSSQL




Check out new movies online website. Download and buy movies now.
1