locked
Someone please help with this error message RRS feed

  • Question

  •  

    I have SQL running on my server. My server has no problem acessing it and one of my clients has no problem. My other client is giving me the following error when I try to access it:

     

    Couldn't access the database server

    The engine must be installed and running

    ADO retuned error:11-[DBMSSOCN] General network error

    Check your network documentation.

     

    Please help! :-)

    Tuesday, November 6, 2007 11:49 PM

All replies

  • The first thing to check is to make sure that the other client doesn't have a firewall enabled.  Then check to make sure that they have configured their connection string correctly.  Then make sure that the server is visible to them in the sense that they can either: resolve the machine name if that is how the server is specified or resolve the IP address if that is how the server is specified.  For general connectivity issues and how to resolve them see: http://blogs.msdn.com/sql_protocols/

     

    I hope that helps,

     

    John

     

     

    Tuesday, November 6, 2007 11:53 PM
  •  

    I am still having no luck. The command prompt is telling me that the service is not configured on this system.

     

    Apryl

    Saturday, December 1, 2007 11:27 PM
  • Did you enable remote connections on your server (See the screencast on my site for more information) ? If you did that and restartes the services, make sure you can connect locally. If this is possible, please come back with your port configuration you are using. Maybe the SQL Server Browser services was not started or is not able to start to make the non-default ports discoverable.


    Jens K. Suessmeyer

    ---
    http://www.sqlserver2005.de
    ---

    Monday, December 3, 2007 9:02 AM
  • Yes, All my other client computers can connect except for this one. It has access to the server. HELP

     

    Apryl

    Tuesday, December 4, 2007 12:24 AM
  • Well, first try to ping the name of the server from the client. If this is not possible use the IP Address. if the ping is successfully, there is a port block which is causing the client not being able to establish a connection to the server. In addition, there could be some additonal rules in the primary network components like switches / routers which prevent the client from connecting like IPSec rules.

    Jens K. Suessmeyer

    ---
    http://www.sqlserver2005.de

    ---

    Tuesday, December 4, 2007 9:25 AM