Re: SQL Server Error - Through Enterprise

From: Rick Sawtell (quickening_at_msn.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 10:56:44 -0600

"Neil" <Neil@discussions.microsoft.com> wrote in message
news:61381799-889C-4C43-BE9D-598231C42FFC@microsoft.com...
> When I open SQL Server Enterprise manager (me as a domain admin - not a
> domain local admin account) I get the following error.
>
> The SQL Server \\Servername\UserID is not known to be running. Are you
> sure
> you wish to connect?
>
> I click on YES and get the following message
>
> A connection could not be established to Servername\UserID
>
> Reason: SQL Server does not exist or access denied.
> ConnectionOpen (Connect())....
>
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right clicking on the Servername\UserID node) and try
> again.
>
> Well, SQL Server is running. I checked out the above message in Google and
> got something but I just want to confirm
>
> http://support.microsoft.com/default.aspx?kbid=328306
>
> This one above is one and there are several. But, I want to know anyone
> else
> who has had this similar issue. Pls let me know,
>
> thanks
>

Can anyone get in?

Can you get in through Query Analyzer using that account?

Is the Domain Admins security group in SQL Server allowed access?
Is the computer you are running from a member server in the domain?

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • New data source connection failure
    ... I'm able to create a new data source in the ODBC panel on the SQL ... server which points to a db on the same SQL server but not creating ... I tried using local admin account, sa account which both belong to the ...
    (microsoft.public.sqlserver.security)
  • SQL Server Error - Through Enterprise
    ... When I open SQL Server Enterprise manager (me as a domain admin - not a ... domain local admin account) I get the following error. ... A connection could not be established to Servername\UserID ...
    (microsoft.public.sqlserver.server)
  • Re: databases attach as Read-Only
    ... What messages are there in the SQL Server error log? ... Is the disk full? ... SQL Server using a local admin account? ... Do both the MIMMagazynDemo database ...
    (microsoft.public.sqlserver.setup)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)