Post reply

VPN, ODBC and SQL Server

  • July 10, 2003 at 9:15 am

    #76031

    We are trying out a VPN for the first time. Here is the situation:

    1. An Access front-end to a SQL Server 7 database using linked tables. The machine ODBC DSN uses Windows authentication. The application lives in a network directory. When the application is run on-site from a computer in the domain everything works perfectly.

    2. When the application is run off-site through a VPN SQL Server returns the following ODBC errors:

    Connection failed:

    SQL State: '0100'

    SQL Server Error 53

    [ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect)

    Connection Failed:

    SQL State: '08001'

    SQL Server Error: 17

    [ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

    3. The user seems to logged into the domain OK through the VPN. She can retrieve email etc.....

    I can't find much about either of the above errors on the KB. Any ideas?

    Thank you!

    JM

  • July 10, 2003 at 9:54 am

    #464917

    Might be a double hop issue. What happens if a user connects directly to the SQL Server using a client such as Query Analyzer?

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • July 10, 2003 at 10:02 am

    #464919

    Thanks Brian, we will try that!

    JM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply