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?
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)