Error Msg 18456
-
Sunday, January 29, 2012 12:52 AM
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?
All Replies
-
Sunday, January 29, 2012 6:56 AMhttp://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/ -
Monday, January 30, 2012 6:55 AMModerator
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.- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Monday, February 06, 2012 3:59 PM

