Ideas and Coffee at 3.47 AM

thank you..

Yeah, and why can't i find this damn thing anywhere on the net!?

Download here: (SP3 Yay!)

www.microsoft.com/.../details.aspx

I installed service pack 3 for SQL 2005 and still getting the same error message.

Please help what can be possible reasons for this?

You have to one thing;

go to Management studio/enterprise manager=>rightclick on it go to Properties =>

go to security => Server authentication=> select SQL Server  and windows authentication mode.

That it.

cheers

I installed VS 2008 n' MSSQLserver2008 and gettin d error as login failed for user 'sa'

so pls help me sort out d prblm.

thnx a lot.

There's no bug in SQL Server 2005. You just need to run it as administrator..

Right Click on short cut and select "run as administrator" It will work nicely

please try to solve this problem and sent me the solution

It worked for me when I ran as Administrator.

Thanks for the suggestion.

This is pitiful. Here's the solution for SQL Server 2005, running from Windows 7:

Start

All Programs

Microsoft SQL Server 2005

Configuration Tools

SQL Server Surface Area Configuration (come on!)

Once this app is running, click on "Add New Administrator"

On to the top right-hand side it'll say "user to provision". Enter your domain \ account info there. Next, just drag what you want from "available privileges" to "privileges that will be granted to [user]"

<sarcasm>

This is so intuitive I can't believe you people haven't figured this out already!

</sarcasm>.

This worked for me. If you think about it, this is MS solution to the pervasive "sa" accounts with no password. Anyhow, good luck.

Thanks to Faizan Ali, just followed his advise submitted on May 04, 2010 3:49 PM

# re: login failed for user (Microsoft SQL Server error: 18456)

There's no bug in SQL Server 2005. You just need to run it as administrator..

Right Click on short cut and select "run as administrator" It will work nicely

FURTHER: after running as admin and login in successfully, you will create have to create a new user, on SECURITY> LOGIN> , right-click login and add new user ie the user you just login. Then you wont have to run-as-admin all the time.

Kwaambwa

Just try to restart your server to refresh your connection.

Thanks every one, it just worked right click run as administrator

It just worked with Run as Administrator. Thanks a lot.

I use visual studio 2010 and sql server 2008. I can't define a new user. when I try

(Security->logins), error:18456 occured.

Does any one know what should I do?

I use visual studio 2010 and sql server 2008. I can't define a new user. when I try

(Security->logins), error:18456 occured.

Does any one know what should I do?

thanks aloooooooooooooooottttttttttt

thanks...worked with run as admin

It looks simple but very very useful answer and the exact answer and i thank u a lot... i really gone mad because of this error

erver Authentication. The 'sa' login details are correct but still getting the following error message:

Quote:

Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)

In order to resolve the issue, please refer to the following steps:

1. Login to the MSSQL Server Management Studio with Windows Authentication.

2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

3. Under the Server Properties, select a page of "Security".

4. Select the Server authentication as "SQL Server and Windows Authentication mode" and click Ok.

5. Restart the SQL Services and then try to login with 'sa' details.

please give me the step by step answer for this one ,,,,

i have right-clicked it and used "run as admin...", but i still get 18456 error... please suggest...

ALTER LOGIN sa ENABLE ;

   GO

   ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;

   GO