I’m trying to connect to a remote SQL Server (2005) located in US, from SQLEXPRESS on my pc in UK. However i keep getting the following error.
————————————–
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)
————————————-
Actually i bought web server space from a US company to host my web application. To create the database and data restore i need to connect to their SQL Server, but it keeps showing up the error message whenever i try. And i learned from the US company that there are no firewalls from their end and everything is configured perfect so that remote clients can connect to thier server. They also say that many people who are hosting web applications on their servers could connect to thier SQL server from different parts of the world with out any problems. Why i can’t coonnect. Do i need to do any settings on my PC.. Please help
i’m trying in the following way Hope the problem description is clear. Thanks I spent hours together in figuring out what the problem is, but no success.
Address : Ip Address\instance name
SQL server authentication
User id :
Password :
Srini