CODEWITHSUNDEEP
sql-server
user7159290
user7159290

Reputation:

Server name on SQL Server 2016

I installed Microsoft SQL Server 2016 Management Studio on my PC, and when I try to connect to a server, it shows this error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

I don't know what should be the server name. How can I connect to a server?

Upvotes: 2

Views: 4274

Answers (2)

Dinesh vishe
Dinesh vishe

Reputation: 3598

enable protocals test TCP/ip Connectivity refer following link https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

Upvotes: 0

BasicIsaac
BasicIsaac

Reputation: 187

Run the command SQLCMD -L in a command prompt and you will see your available server names. If you need additional resources check out this answer: https://dba.stackexchange.com/questions/44171/find-all-version-of-sql-server-on-a-network

Upvotes: 2

Related Questions