Re: Cannot register SQL Server 2000SP3 from client computer

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 16:55:21 GMT

Graham,
If you have a firewall on either computer, please disable it for tests
and see what happens.

Also let us know what authentication mode you have set up - either
Windows Authentication mode, Mixed mode, or SQL Server mode. If yiou
selected Windows Authentication then you may not be able to log in
under the SA account.

Lou Arnold
--------------------

On 21 Jul 2004 18:34:05 -0700, grahamhil@yahoo.com (G-ram) wrote:

>I have a sql server residing on a win2k3 box. It is a new installation
>and there is no data in the server at all besides default data. I have
>my workstation that I have installed client tools on. I am attempting
>to log into the sql server via the enterprise manager. I decided to
>use the sql account sa to login. I figured if any account would get in
>it would be that one. However I am mistaken because it seems that no
>matter what I try I cannot get it to work. I get the following errror:
>
>SQL Server does not exist or access denied.ConnectionOpne(Connect())
>
>Any help would be greatly appreciated....
>
>Graham Hill
>grahamhil@yahoo.com

Relevant Pages

  • Re: How to access SQL Server from a non-privileged domain account
    ... If I log on to my PC (that is, the PC hosting SQL Server) ... PC as a non-privileged domain user, ... allow my non-privileged account access to it (short of using SQL Server ... Windows Authentication mode, but you wanted your non-privileged domain ...
    (microsoft.public.sqlserver.setup)
  • RE: Authentication in MSDE 2000
    ... "How to remove windows Authentication mode in MSDE ... SQL Server supports two authentication modes, one is Windows Authentication ... server roles assigned to a login, you can refer to these articles: ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Server Authentication
    ... I'm using Windows authentication in most cases. ... When a user connects through a Microsoft Windows user account, ... This is the default authentication mode, ...
    (microsoft.public.sqlserver.clients)
  • Re: Authentication
    ... If you install SQL Server in Windows Authentication Mode, then change to Mixed Authentication Mode, the sa account is disabled. ...
    (microsoft.public.sqlserver.connect)
  • Re: security
    ... using Windows Authentication. ... SQL Server has two authentication mode: ... Server however he need to be assigned more sql server permissions to ...
    (microsoft.public.sqlserver.setup)