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 tried evaluating my procedures from this post
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-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 the problem comes when i access the test script page on the other PC. its returning an error:
CONNECTION HAS TIMED OUT
The server at 10.0.0.254 is taking too long to respond.
...
i dont know where im getting wrong at this point. Thinking that it has a correct output if i access the test page in the same box.