Unable to connect sql server

  • This is the error message our client are getting from application when they try to connect to database.....

    SQL Code: -1 Error Code: 10004 DB Error Message: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.1

    Any ideas??

    Thanks in Advance.

    --

    RPS

  • Can you ping the server by name and IP?

    Can you create an ODBC connection to it at all?

    Has the client ever been able to connect to the SQL Server or is this a new installation of something?

    If the client was able to connect previously, what has changed?



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • It seems that client does not have permissions to connect to the server.

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

  • Or the server is down. This can be a network or permissions error.

  • Also could be a resource problem. First thing I'd check is if you yourself can connect. If you can, then it's time to walk the road of network and security.

    Marvin Dillard
    Senior Consultant
    Claraview Inc

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

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