How to connect and set up an MSSQL Server (SSMS)

In the previous course, we also looked at the latest version of MSSQL installation 2022, as well as the installation of the SSMS (MSSQL Connection Tool).
In this course, we will find out how to access using SSMS after installing the database.
We have taken step-by-step screenshots for anyone to follow, so please access the database.

Connect the MSSQL Server Database

For the installation process of the SSMS (MSSQL Connection Tool), please refer to the installation process of 2022, the latest version of MSSQL.

Access to a Windows account

1. Start on your computer - Browse to SQL Server Management Studio and click on it.

2. Do you see the screen where you can connect to the Connect to Server?

2-1. Server Type: Choose Database Engine.

2-2. Server name: The name displayed on the screen may vary from computer to computer.

2-3. Authentication: Please select Window Authentication.

2-4. Click Connect.

3. It is when you connect. Isn’t it too easy?

Access the MSSQL server with an SA account

• When you install MSSQL Server, the SA account is created by default, but you must change the settings after accessing the Windows account.
• It is more complicated than accessing it with a Windows account, but do not worry because if you look at the capture screen, you can easily follow it.

4. When you log in with a Windows account, click object Explorer - Security - LOGIN - SA - Right mouse

4-1. Login Properties Window - General - Please enter your password.

4-2. Login Properties Window - Status - Click - Select Enabled on the Login Radio button and confirm with the OK button.

4-3. On the screen you first connected to, select Mouse Server, right-click, and click Properties.

4-4. Pop-up - SQL Server and Window Authentication mode and click OK.

5. Restart SQL Server.

5-1. Close the SQL Server you connected to, and in Windows, click SQL Server Configuration Manager.

*5-2. In the window, select SQL Server and right-click. Click -> Restart to restart SQL Server.

5-3. Accessing the MSSQL Server with the SA account.

How to deal with errors

• Error case: Microsoft OLE DB Provider for SQL Server error user ‘80004005’ failed to log in because the account ‘SA’ is currently locked. Your system administrator may unlock it.
• Answer: ALTER LOGIN SA WITH PASSWORD = ‘Enter required password’ UNLOCK GO command and uncheck ‘Force password policy in object Explorer - Security - LOGIN - SA property’ and ‘Force password expiration’
• Error case: User ‘SA’ failed to log in (Microsoft SQL Server, Error: 18456).
• Answer: On the gap screen number 4, select the Login Properties window - Status - Click - Login Radio button, click the OK button, reboot, and access.

Finish connecting to the MSSQL Server

• Today, we learned how to access the database after installing it.
• It would be convenient if you could access the Windows account at first and set up the SA account to access it as well.
• You have an SA account, but You cannot log in., so you must reboot the database after setting it up to access it.