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 |
|
leen3o
Starting Member
2 Posts |
 Posted - 2007-01-24 : 04:11:47
|
| Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me .. This is the errorMicrosoft OLE DB Provider for SQL Server[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access deniedI know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..1. I have changed the connection string to include the port number 1433 (Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)2. I can ping the IP address of the external SQL Server with no problems3. On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall4. I have even tried turning the Firewall off completely while I tried to connect - But still nothing.If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???Thanks |
|
|
leen3o
Starting Member
2 Posts |
Posted - 2007-01-24 : 05:18:52
|
| Hi... I have now sorted this... I just needed to add the below to my connection string...Network Library=DBMSSOCN; |
 |
|
|
|
|
|
Can't connect to external SQL Server (Please Help)