I am having trouble connecting to a database (on a web-based server). I downloaded and installed SQL Server 2008 R2 (w/tools). (I am running Windows XP) I checked SQL Server Services: The SQL Server Browser is running; sql server (sqlexpress) is running;sql server agent (sqlexpress) is stopped. I enabled TCP/IP, enabled Named Pipes, and restarted both the browser and sql server (sqlexpress). I double and triple checked the server name / username / password. Now I am getting this message: TITLE: Connect to Server ------------------------------ Cannot connect to aish.vivadnn.com. ------------------------------ ADDITIONAL INFORMATION: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) For help, click: http://go.microsoft.com/fwlink?Prod...rver&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476 What am I missing? Thanks in advance,
Web based server? Is this not in your domain, are you trying to connect to a remote (internet) based server?
It seems that the people on the server side closed all the ports. So, until that gets resolved, there is little to explore. Thanks,
In that case find out what port the SQL server is listening, I see that its a remote (ISV) hosting server.
Yes, thank you. It turns out that on the server side they only allow in specific IP Addresses. I had sent them my IP, but when the router goes down, since I don't have a static IP, I get assigned a new one. Once I sent them the new IP Address, the issue was resolved (after much anguish). Thank you!!
