All geek questions in one place

Could not find SQL Server name when connecting

Cannot find SQL Server name when connecting SQL Server Management Studio:

(Error -40 Failed to open a connection to SQL Server)

I tried to find the server name in the Services of the Configuration Tool, but I found in the Services section. 'No Items'

I tried using the command line:

SQLCMD -L

but it will display:

Servers :
+4
source share
2 answers

Ok, I have an easy solution for your question. Follow these steps:

SQL Server SQL Server: MSSQLSERVER VIA - - TCP/IP - VIA -

, :)

+2

sql, SQLEXPRESS2 ,

enter image description here

cliconfig.exe system32 ( ) TCP/IP

enter image description here

alias add IP- sql , ok

enter image description here

:

, .

Windows SQL Server:

+2

Source: https://habr.com/ru/post/1666176/

More articles:


All Articles