How to login to SQL Server?

Question

Microsoft Access

How to log into Microsoft SQL Server Management Studio?
The screenshot shows the window that appears immediately after starting Microsoft SQL Server:

spoiler

The server name is probably spelled incorrectly, because when trying to connect, the following error occurs:

spoiler

You just need to log in there in order to then open the database from Access and work with SQL queries in it.

Answer 1

Click the cross (Cancel) and go to SSMS.
Then the documentation: Connecting to the server (DBMS kernel) .
Then connect the Access file: Linked Servers .

Server name is incorrect

Server name, down arrow, "Continue browsing"

Answer 2

SQLEXPRESS does not bind to a port by default. In addition, the firewall may prohibit the connection.
Here is the first instruction from Google
https://www.ibm.com/support/knowledgecenter/SSETBF...

Answer 3

1. as already noted - teach sqlexpress to respond by tcpi / ip
2. go to the computer where sqlexpress is installed and make sure that mixed authorization is enabled and there is a username and password for sql authorization ... details if required - after step 1 is completed