locked
SQL server does not exist or deny network access RRS feed

  • Question

  • Hi, the problem is that Unable to connect: SQL server does not exist or deny network access.
    Why do meget this error ????/Sa can be successfully used in Enterprise Manager, create a new SQL Server registration,But still can not use Windows Authentication mode to connect to SQL Server.
    thanks
    Saturday, December 12, 2009 5:22 AM

Answers

  • Hi,

    Based on your description,   you failed to connect SQL Server 2000 instance under the Windows Authentication mode. Generally, the error message “SQL Server does not exist or access denied” indicates the SQL Server service is not running or the name resolution process in Domain Name System (DNS) doesn’t work correctly. To troubleshoot your connectivity problem, please carry out the steps in the following KB article:
    http://support.microsoft.com/default.aspx/kb/827422

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Wednesday, December 16, 2009 2:56 AM

All replies

  • Hello,

    With that less information it's difficult to find the reason + solution.

    To connect to a MS Sql Server with a Windows Authentification you have to add the domain account to security=>users and grant access.
    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Saturday, December 12, 2009 7:11 AM
  • Hi,

    Based on your description,   you failed to connect SQL Server 2000 instance under the Windows Authentication mode. Generally, the error message “SQL Server does not exist or access denied” indicates the SQL Server service is not running or the name resolution process in Domain Name System (DNS) doesn’t work correctly. To troubleshoot your connectivity problem, please carry out the steps in the following KB article:
    http://support.microsoft.com/default.aspx/kb/827422

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Wednesday, December 16, 2009 2:56 AM