DotNet Mirror
  DNM facebook   DNM Google+   DNM Twitter   

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

By Ashok Nalam on 17 Jan 2014 | Category: SQL Server | Tagged: error 
  Discuss Add Comment   |  
Add rating Rate this resource   

Introduction:

If you are getting error as "Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)" while connecting to SQL Server with SQL Server Authentication mode .


To resolve the issue, do the following steps.
Open SQL Server Management Studio > Login with Window Authentication mode > Right click on object Explorer Server Name > Select Properties


From Server Properties > Security Tab > Server authentication > Select SQL Server and Windows Authentication Mode CheckBox. 

 
Clock on OK button > It says "Some of your configuration changes will not take effect until SQL Server is restarted." > from services.msc restart SQL Server Service.

Hope it resolves the issue otherwise check your username under Security/Logins.
  Discuss Add Comment    
Add rating Rate this resource   
About the Contributor
Member Since : 10 Dec 2012
Member Points (Level) : 8666  (Professional)
Location : INDIA
Home Page : http://dotnetmirror.com
About : I am admin of this site.
Rate this resource
 
Add your Comment
Name Email WebSite
Captcha Refresh


Comments (0)
No comments found, click here to add comment.