Re: the connection to the server has been broken



Make sure you are using the same authentication, login when
connecting with Query Analyzer as you used to register SQL
Server in Enterprise Manager.
If that doesn't work, you may also want to check the
following troubleshooting article:
Potential causes of the "SQL Server does not exist or
access denied" error message
http://support.microsoft.com/? id=328306

-Sue

On Fri, 29 Jul 2005 11:09:27 -0400, "Carlos"
<ch_sanin@xxxxxxxxx> wrote:

>Hi all,
>
> When I accessed query analyzer I got the following error:
>
> [ODBC SQL Server Driver][TCP/IP Sockets] SQL server does not exist or
>access denied
>
>I had been able to access this feature with no problems until now.
>This occurs at my local instance so I do not know why it is happening. I
>can open Enterprise Manager without problems.
>
>Thanks,
>
> Carlos
>
>

.



Relevant Pages

  • Re: isnumeric-error in result, attn Microsoft
    ... > I close Enterprise Manager and Query Analyzer, ... > Changes to the server since it last worked correctly ... > ODBC configuration changes to ensure Regional settings and OEM/ANSI ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot connect with Enterprise Manager
    ... > I can connect to a server with Query Analyzer but not with ... > Enterprise manager (from a lot of clients so problem is ...
    (microsoft.public.sqlserver.server)
  • Re: sql 7 and sql 2000 enterprise manager
    ... You cannot register a SQL 2000 server in SQL 7.0 enterprise manager. ... Eg. Login to query analyzer and execute sp_helpdb to get all database ...
    (microsoft.public.sqlserver.programming)
  • Cannot connect with Enterprise Manager
    ... I can connect to a server with Query Analyzer but not with ... Enterprise manager (from a lot of clients so problem is ...
    (microsoft.public.sqlserver.server)
  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)

Loading