My Happy Moments

I came across this error when I tried to Install MS SQL 2005 on Vista.I have installed SQL plenty of times and never had problems before on my XP.

My Problem :

The SQL 2005 did install correctly on my 64bit Vista but I was not able to log on to the server and it gave the following error

Login failed for user ‘PC-Name\UserName’. (.Net SqlClient Data Provider)

Error Number: 18456 – Severity: 14 – State: 1

Solved :

Instead of running SQL Server Management studio as current user I run it as an Administrator.

Then in the Object Browser Select the server > Security > Logins > New Login

Following window will be displayed

Click Search and the following window will be displayed

In the text box enter your username and press check name and press ok.

And you are done.

Now you will not have to run your SQL Server Management studio as an Administrator.

Thank you

Popularity: 36% [?]