0

I have enabled Named Pipes and TCP/IP for this instance and restarted the service. I have also made sure the the port on the server is open on the firewall. I have also made sure that I have the correct credentials, I can access the server fine if I remote into the box, I just cannot access it over the network.

This SQL2008 R2 instance is installed on a server that has been running SQL 2008 for a while now. Has anyone else had this problem where the 2008R2 instance is still not available over the network?

  • Edit:

OS is Server 2008 R2 Standard. SQL 2008 R2 is a named Instance and the default SQL2008 instance is a default instance. Port is use is 1433(Default SQL port)

Improve this question

1 Answer 1

Reset to default
0

Have you tried disabling windows firewall to verify this is not stopping communication with required port(s)?

I have found this is normally the issue for my remote connectivity issues when I have ensured all other settings have been done and the service restarted.

The other thing to try is to ensure the SQL Browser service is running.

You may want to give a bit more information about OS being used, whether your install is the default or named instance and just what services/ports are open to further allow diagnosis.

Improve this answer
3
  • disabling the firewall entirely may get me into some trouble, will speak to the IT manager to confirm. SQL Browser service is also running. Commented May 9, 2011 at 10:00
  • A 1 minute test is all that's needed just to identify it is/is not the issue. Also, you are aware that if you don't specify a port that the ports will be dynamic with named instances? So default is 1433 and named maybe 1434.... Commented May 9, 2011 at 10:18
  • Port has been specified as 1433 in the Surface config manager and dynamic ports has been disabled. Thanks Commented May 9, 2011 at 11:06

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.