Forum Discussion

Sebas2905's avatar
Sebas2905
Frequent Visitor
8 years ago

Can't connect to SQL Server via servername\instance

Hi, I'm trying to connect to a SQL server via get data SQL server: servername\instance   However when I use: servername\instance I get the following Error:   Message=A network-related or instance...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sebas2905,

Are you able to ping the target Server using server name?  Does the ping using the server name return back the same IP address as the ping to the FQDN?

In addition, are you able to use "Servername\instancename" in SSMS? Also check if there is a SQL Alias in the machine's SQL Client configuration for the remote server name.

Regards,
Lydia