Friday, February 7, 2014

Microsoft SQL Server, Error: 18456

Cannot connect to User_Name-PC
Login failed for User_Name-PC (Microsoft SQL Server, Error: 18456) 













This is one annoying error message you get when trying to connect to an instance of SQL Server BUT, not to worry, COS, problem's solved.
All you have to do is "turn user account control off". Follow the below steps to turn off user account control

Goto Start ~> Control Panel ~> User Account ~> Turn user account control on or off ~> Then, uncheck the 'Use User Account control (UAC) to help protect your computer' check box ~> Click OK, you would get the below message asking for sytem restart, click restart now. thats all. job's DONE.

No comments: