V
V
Victoria Kabishova2020-10-22 14:46:13
SQL Server
Victoria Kabishova, 2020-10-22 14:46:13

How to connect localhost to Microsoft SQL Server Management Studio 2019?

I can't figure out why I can't connect to the local server.

spoiler
5f91702aa89e7329853579.png
5f9170eabfab6881175048.png

Answer the question

In order to leave comments, you need to log in

3 answer(s)
K
Konstantin Tsvetkov, 2020-10-22
@Parsifal31017

As configured during installation, and connect.
Try just the computer name.

V
Vladimir Korotenko, 2020-10-22
@firedragon

try
.\sqlexpress
Where dot is the name of the local host followed by a slash is the name of the instance.
In addition, you can start the "SQL Server Browser" service and the studio itself will pick up the necessary instances.
True, there are more complicated cases.

S
Sergey Grebnev, 2020-10-23
@nekun

Look in the configurator to see if the browser is enabled and if access is allowed in the firewall to port 1433

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question