crystal failed to open SQL 2005 database connection on VPN

  • I am using VPN connection to create a crystal report.

    But when i try ro create a 'SQL 2005 database conection' using a connection information i get the below error :

    The error message is:

    Failed to open the connection.

    Details: ADO Error Code 0x80004005

    Source Microsoft OLE DB Provider for SQL Server

    Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access is denied.

    SQL State: 08001

    Native Error: 17 [Database Vendor Code: 17 ]

    1. while at job, i use

    OLE DB ADO Provider ----> Microsoft OLE DB DB Provider for SQL server --->

    then I enter the following :

    Server - DevelopmentSQL2005XYZ\ANode111

    UserId - xxxxxxx

    Password - xxxxxxx

    Database - Orders ( this is a dropdown, it shows the name of database when i connect from my job but from home doesnot show anything)

    Able to successfuly connect to SQL2005

    2. If I do the above step from home but i get the error.

    I have checked the following:

    1.Both TCP and name pipes are enabled for remote connections in SQL 2005

    2. SQL Browser service is running.

    Any suggestions or link for solution this problem, is really appreciated.

    NOTE: I use laptop at job and at home

  • Do you have a network guy you can check with?

  • There are several factors that can cause problems for Crystal Reports, or for any kind of database connection. First and foremost is your internet speed. Use of anything less than 10 megabits can be problematic, as the keepalive packets for the VPN connection often can't arrive in time. Generally, getting a connection that's slower than 10 meg means that your internet traffic is lumped in with every other slower connection at some network aggregation point within your ISP, and that can lead to delays that a VPN connection with keepalives just doesn't handle well. If your VPN connection doesn't use keepalives, that just hides the problem, as database connections often have fairly short timeout values.

    That said, there are bound to be plenty of folks working on 5 meg connections that aren't having any problems at all. However, they are likely to be those whose neighborhoods have yet to get particularly busy with internet traffic.

    Some suggestions:

    1.) Increase your timeout values for your database connection significantly.

    2.) Get the fastest internet connection you can afford - just be aware that DSL connections are not generally good candidates for VPN connectivity, and could easily be the source of your grief, as they are NOT an "always on" connection.

    3.) Absolute minimum of 5 mb/sec for speed, but 10mb/sec is considerably better.

    4.) Be sure the VPN client is a decent one, and that it's the latest version from the company that makes it. Older VPN clients are all too often full of bugs/problems.

    FYI, I worked from home for 3 to 4 years, and had remote access for more than 10 years. Early on, with a max available speed of 5 meg, I had fairly regular VPN disconnects, and a newer/better VPN client showed up at roughly the same time I was able to get to 10 meg, and the problems largely disappeared.

    Hope that helps,

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • Thanks OldHand,

    I will check everything mentioned in your reply and let you know the result.

    I appreciate your help.

  • Actually, this error

    Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access is denied.

    is pointing to the fact that your firewall is not configured properly. It is not a "Crystal" issue, it looks more as firewall configuration issue. Ask your network guys to check if default port for SQL server is opened on firewall.

  • Thanks for pointing that out. I wouldn't have recognized that as part of the problem. I'm not the OP, but it sure is good to learn this kind of thing. Thanks again!

    Steve

    (aka smunson)

    :):):)

    Glen Sidelnikov (9/25/2008)


    Actually, this error

    Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access is denied.

    is pointing to the fact that your firewall is not configured properly. It is not a "Crystal" issue, it looks more as firewall configuration issue. Ask your network guys to check if default port for SQL server is opened on firewall.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 6 posts - 1 through 5 (of 5 total)

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