Hi.Its really become a nightmare solving remote SQL Server connection. I thought it was going to be easy. Anyway im using win xp sp2 and sql 2k5 express as testing environment. I followed trouble shooting

tips:

http://blogs.msdn.com/sql_protocols/...eShooting.aspx

and secured all requirements to met one by one.
I created a test script (ASP) running on the same box where the SQL Server was installed and its running perfectly (eg http://127.0.0.1/sql.asp OR http://localip/sql.asp) either using one of the following

connection string

cn.Open "Driver={SQL Server};" & _
"Server=live-static -ip;" & _
"Address=local-ip,1433;" & _
"Network=DBMSSOCN;" & _
"Database=xxx;" & _
"Uid=xx;" & _
"Pwd=xxx;"


OR

cn.Open "Provider=sqloledb;Network Library=DBMSSOCN;" & _
"Data Source=local-ip,1433;" & _
"Initial Catalog=testdb;" & _
"User ID=xx;Password=xx;"


now i upload the page to our domain host and try to access but its sending an error:

################ ERROR MESSAGE

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

/sql.asp, line 6



i dont know where im getting wrong at this point