We are able to connect to MSSQL Server Management Studio with Windows
Authentication but unable to connect with SQL Server 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.
Hope this will help you....
作者:Angelo Lee
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利.