How Tin Laissez Passer On The Sack One Connect To Sql Server Amongst An Ip Address Using Microsoft Operations Studio?
Take for example, SQL Server 2017 Developer's edition. It is the latest unloose version. When you lot install it you lot tin grade the axe solely access using 'localhost' equally shown.
Enter localhost
SQLServrConfig0
Click Connect in addition to you lot are connected equally shown.
The mistake message indicated that it was due to Named Pipe provider error.
Let us enable Named Pipes protocol inwards SQL Server Configuration Manager equally shown.
SQLServrConfig2
Make a Federal Reserve annotation that when you lot modify (enable/disable), you lot necessitate to halt in addition to showtime the server. You tin grade the axe create this inwards SQL Server Configuration Manager.
Now endeavour to connect using IPAddress equally before.
SQLServrConfig4
Click Connect in addition to you lot are connected equally shown.
SQLServrConfig3
That is all at that spot is to it.
Enter localhost
SQLServrConfig0
Click Connect in addition to you lot are connected equally shown.
SQLServrConfig00
Now instead of localhost, essay the IPAddress equally shown.
SQLServrConfig4
Trying to Connect you lot expire the next message.
The argue for this is that the Protocols for MSSQLSERVER (the instance nosotros are considering) has solely Shared Memory enabled equally inwards the SQL Server Configuration Manager.
SQLServrConfig1
The mistake message indicated that it was due to Named Pipe provider error.
Let us enable Named Pipes protocol inwards SQL Server Configuration Manager equally shown.
SQLServrConfig2
Make a Federal Reserve annotation that when you lot modify (enable/disable), you lot necessitate to halt in addition to showtime the server. You tin grade the axe create this inwards SQL Server Configuration Manager.
Now endeavour to connect using IPAddress equally before.
SQLServrConfig4
Click Connect in addition to you lot are connected equally shown.
SQLServrConfig3
That is all at that spot is to it.
Komentar
Posting Komentar