Results 1 to 2 of 2
  1. #1

    Default SQL Server 2k5 Remote connection error


    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.

  2. #2

    Default Re: SQL Server 2k5 Remote connection error

    10.0.0.254 bro tanaw nako ani local ip mani siya...

    so kong imong gi access ang remote dbserver nimo gikan sa inyong asp web server..
    dapat imong gamiton nga IP is katong global IP. nga ma access gikan sa internet.
    wa pud ko kabaw onsaon na pag setup. hehe ang nahibaw-a nako is kananglan ka og STATIC-IP gikan sa inyong internet provider.

  3.    Advertisement

Similar Threads

 
  1. Connecting MSSQL SERVER 2000 Remotely with PB9
    By radieux_scablem in forum Programming
    Replies: 2
    Last Post: 03-18-2008, 06:31 PM
  2. Connecting MSSQL SERVER 2000 Remotely with PB9
    By radieux_scablem in forum Software & Games (Old)
    Replies: 1
    Last Post: 03-18-2008, 03:05 PM
  3. SQL Server 2k5 Remote connection error Part 2
    By hybrid_X in forum Programming
    Replies: 0
    Last Post: 06-02-2007, 05:09 PM
  4. How to connect to SQL SERVER in Visual Basic.NET?
    By kibotizer in forum Programming
    Replies: 0
    Last Post: 03-16-2007, 11:55 PM
  5. HOW TO CONNECT SQL SERVER USING SQL AUTHENTICATION
    By edshark in forum Software & Games (Old)
    Replies: 13
    Last Post: 09-02-2005, 04:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top