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

Time:2020-9-28

 

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 https://blog.csdn.net/gfjjggg/article/details/83721445

To modify TCP / IP properties: https://www.cnblogs.com/sunxi/p/3408074.html

 

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. https://blog.csdn.net/sunqing0316/article/details/46623823

  

 

 

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 […]