Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Connecting via Radio Link

    Could somebody tell me as to what configuration changes has to be made in the SQL Server 2000, if I want to connect to a table in the database using Internet options, i.e., I have the SQL Server running on a machine which uses a real IP address, and I want to connect to it (SQL Server)using DSN from another location. In the 2nd location, I use internet using dialup/DSL/Cable Broadband.

    The following error is shown, when I try to connect to the SQL Server using SQL Server authentication using login ID and password:

    Connection failed:
    SQL State:'01000'
    SQL Server Error: 10060
    [Microsoft][OBDC SQL Server Driver][TCP/IP Sockets]ConnectionOpen[Connect()]
    Connection failed:
    SQL State:'08001'
    SQL Server Error: 17
    [Microsoft][OBDC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

    Thanxs in advance to anyone who can help me solve the problem.
    Last edited by debasishkundu; 10-25-03 at 02:39.

  2. #2
    Join Date
    Oct 2003
    Pune, India
    You can use the Client Network Utility.

    Go To Client Network Utility. Go to Alias Tab.
    Click on ADD. Provide a Alias Name, and the Server IP address or the URL as Server Name under the Connection Parameters Section. (Netowrk Libraries can be Named Pipes)

    Thats it. When you go to Enterprise Manager, you can register that server by its Alias name.
    Thanks & Regards,
    Dipayan Sarkar
    (CoVisible Solutions - A Knowledge Management Software company)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts