02
SQL Server Remote connection problem solved
Description :
SQL Server Remote connection problem solved
There was some network upgradation last week, and after it got solved, our development team members encountered SQL Server Remote Connection Problem.
After struggling a lot on internet I found a solution and resolved it.
I posted it here so that you may not waste your time in searching for the solutions.
We were not able to access SQL Server from another machine.
To overcome this problem, we need the server setting to be Local and Remote both, so the following proves to be a better solution:
1. Open SQL Server Surface Area Configuration tool from the start menu.
2. Click on link for “Surface Area Configuration for Services and Connections”
3. Select SQL Server instance
4. Select Database Engine \ Remote Connections
5. Change setting to “Local and Remote connections”, option “Using both TCP/IP and Named Pipes”
Hope this helps!
If yes ?? Please don’t forget to write your comment below, I love it !!
Enjoy!!!!!!!!!
There are no comments.