CODEWITHSUNDEEP
sql-serverssms
Priyanka
Priyanka

Reputation: 41

Could not find SQL Server name while connecting

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

(Error-40 Couldn't open the connection to SQL Server)

I tried to find server name in services of Configuration tool, but I found 'No Items' under Services.

I tried by using command prompt : 

SQLCMD -L

but it will display: 

Servers :

Upvotes: 4

Views: 992

Answers (2)

Amr Ashraf
Amr Ashraf

Reputation: 315

Open the sql server configuration manager then click on protocols for SQLEXPRESS2 make sure that named pipes is enabled

enter image description here

Then you need to create alias for client side search for cliconfig.exe in system32 (open it) then create TCP/IP alias

enter image description here

Then go to alias tab and click add and write alias for server and write ip address for sql server and uncheck the dynamically determine port then click ok

enter image description here

source link: here

I hope this help..

windows services SQL Server Instances : Image Link

Upvotes: 2

Karar Mahdi
Karar Mahdi

Reputation: 21

Well I have an easy solution for your question. Follow the steps:

Go to SQL Server Configuration manager SQL Server Network Configuration: Protocol for MSSQLSERVER In the right pane split page you will have to disable VIA as follows Shared Memory - Enable Named Pipes - Enable TCP/IP - Enable VIA - Disable

do this and tell me whats up :)

Upvotes: 2

Related Questions