If we will try to connect default installed SQL Server with IP address we will receive below
error.
One of my technical member assisted me how can we resolve this.
Step 1: First open the SQL Configuration Manager.
Step 2: In SQL Server Configuration Manager window click on Protocols for SQLEXPRESS
and then TCP/IP.
Step 3: Now IP1 section type IP and TCP port and in IP All type TCP Port.
Now click on Ok.
Step 4: Restart SQL Server services.Now we can login using IP address.
That’s It.
Enjoy Reading.
No comments:
Post a Comment