Error Msg 18456

Question

Hi

I am new with Sql 2008 R2 the program well installed and now when i go to SQl Server Mangement studio I get erro which is login.

Server type Database Engine

Server Name my machine name

Authentication Windows Authentication

user name is off here

anyone can help me pls?

 

Answer 1

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Hi Dilshad,

If you are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode.
 
If you are trying to connect using SQL Server Authentication, verify that SQL Server login exists and that you have spelled it properly.
 
If you are trying to connect using Windows Authentication, verify that you are properly logged into the correct domain.

For more information, please refer to http://msdn.microsoft.com/en-us/library/cc645917.aspx
 http://blogs.msdn.com/b/sql_protocols/archive/2007/06/30/login-failed-for-user-xx-msg-18456-level-14-state-1.aspx .

 

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.