Connecting to SQL 2000 remotely SQLOLEDB
Posted on 2007-10-12
This is driving me MAD.
I have a server that I am trying to connect to, Win2003, SQL2000, IIS V6.
Now, I am able to connect to the SQL database Locally. However not remotely. Getting the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/includes/conn.asp, line 22
I have TCP/IP protocol enabled, no firewall enabled, default security MSDE/MSSQL permitted.
My connection string looks like this: see below; I am using the IP address on this remote connection, thats the only difference between this and the local connection that works, I have tried the local connection using the same IP and it works as well. I think that this may not be my connection string but some other server setting that is not permitting remote connections?
<% Option Explicit %>
db_server="**.***.***.**" 'database server name
db_userid="****" 'Database User ID
db_password="********" 'Database Password
db_name="*******" 'Database Name
conString="Provider=SQLOLEDB.1;Password=" & db_password & ";Persist Security Info=True;User ID=" & db_userid & ";Initial Catalog= " & db_name & ";Data Source=" & db_server