Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sri130785
Starting Member
2 Posts |
 Posted - 2009-06-05 : 07:29:17
|
| I'm trying to connect to a remote SQL Server (2005) located in US, from SQLEXPRESS on my pc in India. 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..i'm trying in the following wayServer Name: Ip Address\instance nameSQL server authenticationUser id :Password : ORServer Name: Ip Address\instance name,PortSQL server authenticationUser id :Password : i was Configured Every Setting in the "SQL Server Surface Area Configuration" and " SQL Server Configuration Manager" Please help me |
|
|
|
|
|
Problem connecting to a remote SQL Server 2005