Shulou(Shulou.com)05/31 Report--

This article shows you SQL2008 can not connect to.\ SQLEXPRESS and user sa login failure example analysis, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

There is a problem:

Title: connect to the server

-

Unable to connect to.\ SQLEXPRESS.

-

Additional information:

Login failed for user 'sa'. (Microsoft SQL Server, error: 18456)

Solution:

1. Open it; log in to the database as Windows

02. Login name; double-click sa (Open Properties)

03, general; set password to determine

04. Status login: enable; confirm

05. Right-click the server name; attribute

06, security; check SQL Server and Windows authentication mode to determine

Right-click the server name; restart; close the database connection, exit the program; use sa to log in to the database to solve the problem

The above is a sample analysis of SQL2008's inability to connect to.\ SQLEXPRESS and the login failure of the user sa. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.