I have two sites, each with a MS SQL database on a different host. I wanted to share some data between the sites and so one site is connecting to both databases. This was working yesterday, but now I'm getting the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I can connect to both instances from home using SSMS and query the data from each. Is there something blocking communication between them? Am I doing something that isn't allowed?
we do not block outgoing SQL connection to databases outside of our network. The error you are seeing indicate a network related issue. Are you having problem with 1) Application hosted here connecting to a remote database OR 2) Application hosted elsewhere trying to connect to our database server remotely?
