Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Sql server does not exist or Access Denied

    Hi,

    Need help with this error" Sql Server does not exist or Access Denied"

    Have been getting it intermittently from suddenly from the last 2 days on my production site. The web server and the database server are on different domains.

    We have now moved the webserver to the same doemain as the database server and it works fine.

    If anyone can throw light on what could be the problem it'll be great

    Thanks,

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The obvious answer is that the web server can't see the sql server. The "why" of that gets more complex.

    First and foremost, do you have this month's security releases applied to both of your machines?

    -PatP

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    Hi Pat,

    Thanks for the reply. The situation has changed slightly now which leads me to think it is not longer a domain issue. The web server is a cluster of 2 boxes in one domain. Out of the two it is only one of them that is having problems connecting to the Sql Server and that is the primary node of the cluster. The other one works fine...


    Any thouhgts, comments, suggestions are greatly appreciated.

    Thanks,

  4. #4
    Join Date
    Mar 2004
    Posts
    114

    Question

    What is your web server ? Apache ?

    Is your cluster Active / Active ?

  5. #5
    Join Date
    Apr 2004
    Posts
    3
    The server i use is IIS and the cluster setting is active /active

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As long as you are the primary administrative person for the cluster, I would run Windows Update on the primary node, then on any other nodes in the cluster as a first step. After you do this, monitor performance for a while to see if it changes (I think that it should).

    -PatP

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Review information from this KBA [http://support.microsoft.com/?kbid=328306] for the potential cause of sql server not available errors.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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