Wednesday, January 24, 2018

Connecting to SQL Server 2017 using Microsoft SQL Operations Studio with an IP Address

Take for example, SQL Server 2017 Developer's edition. It is the latest release version. When you install it you can only access using 'localhost' as shown.

Enter localhost
SQLServrConfig0

Click Connect and you are connected as shown.


SQLServrConfig00

Now instead of localhost, try the IPAddress as shown.


SQLServrConfig4

Trying to Connect you get the following message.


The reason for this is that the Protocols for MSSQLSERVER (the instance we are considering) has only Shared Memory enabled as in the SQL Server Configuration Manager.

SQLServrConfig1

The error message indicated that it was due to Named Pipe provider error.

Let us enable Named Pipes protocol in SQL Server Configuration Manager as shown.

SQLServrConfig2

Make a note that when you change (enable/disable), you need to stop and start the server. You can do this in SQL Server Configuration Manager.

Now attempt to connect using IPAddress as before.

SQLServrConfig4

Click Connect and you are connected as shown.


SQLServrConfig3

That is all there is to it. 

No comments:

Post a Comment

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...