August 13, 2008 at 2:26 pm
I am getting this error inconsistently when trying to connect to a Remote SQLExpress server.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server)
But if I specify the I can get connected every time.
My SQLBrowser service is running and active. I am connecting across a high latency VPN connection.
I want to continue to use dynamic ports if possible.
Is there a way to verify that I am receiving a response back from the sqlBrowser?
If yes is there a way to see what port it is sending back to connect on?
December 11, 2009 at 3:46 am
Hi,
Dont know if you resolved this, but I've had a similar issue, I resolved mine by ensuring the port that the browser is listening on it open. This seemed to resolve all my connection issues.
Hope this helps!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply