There are a series of problems from the successful installation of SQL server to the use of SA SQL server to verify the login



Log in using Windows authentication

  • An error occurred

Unable to connect to the local server

  • solve the problem:

SQL Server Configuration Manager: Service remote procedure call failed

To modify TCP / IP properties:


Log in as SA

  • After logging in successfully with windows authentication, modify the properties of SA, set the password and start.







Set login mode

  • Problems encountered


  • solve the problem

Set the login mode to windows authentication and SQL server login mode.




Still failed to log in

Right click restart still failed to login


Open the SQL Server Configuration Manager and restart the SQL Server service



At this point, I have successfully logged in. It’s very difficult…


Recommended Today

Four best practices for writing high quality JavaScript modules

With the es2015 module, you can divide your application code into reusable, encapsulated, and single task focused modules. That’s good, but how to construct modules? How many functions and classes should a module have? This article describes four best practices on how to better organize JavaScript modules. 1. Give priority to named export When I […]