Question Locked

Problem connecting to a remote SQL Server 2005 from SQL EXPRESS

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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
Address : Ip Address\instance name
SQL server authentication
User id :
Password :

Hope the problem description is clear.

Thanks
Srini

I spent hours together in figuring out what the problem is, but no success.

5 replies

by Former member

The best way is to start from fresh.
Get the info of the server and the User name password etc, and try the new link to see if there is anything missing. You could be missing something like one digit or word, something so silly that makes the connection error.
Go through everything step by step, make sure that what you have is correct.

Please post back if you have any more problems or questions.

by sri130785

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
Address : Ip Address\instance name
SQL server authentication
User id :
Password :

by johnpranas

does your IIS run? and it make you can run a localhost in your web browser?

so if that happens, you must turn off the default browser in IIS.

by nebyas

The error might come because of two reasons. one, try the server accepting remote access from other users; if not; right click my computer of server, goto remote tab and select "allow users to connect".
Second, goto Surface Area Configuration of sql server and then check remote connectivity, in Surface Area configuration for Services and Connections. select "remote connectivity > through TCP/IP and named pipes".
Try this and reply.

This discussion is closed to new replies.