Server Registration fails - figure this out !

From: ErwinB (eba_at_iqs.be)
Date: 08/28/05 

Date: Sun, 28 Aug 2005 15:49:52 +0200

Hi,
Try to figure this out, because I was not able to do a d*mn thing !

In EnterPrise Manager on the workstation, I try to add a server
registration. I tried both ways :
- using Windows authentication, then the error states "Login failed for
user Domain\User"
- using SQL authentication (with 'sa'), then the error states "Login
failed for user 'sa'. Reason : not associated with a trusted SQL server
connection"

What I did and what I checked so far :
- connections are made with TCP/IP (I used the Server Network and the
Client Network utilities to check)
- security on SQL Server is set to mixed authentication modes
- of course, the account of the user is added to the login list

Some details :
Server side
- on Windows SBS 2003 box
- is actually MSDE
- user interface provided by DbaMgr2K, a FREE tool that acts like
EnterPrise Manager

Client side
- Windows XP Pro, SP2
- has a full SQL Server 2000 installation with EnterPrise Manager

The interesting fact is that a few months ago, it worked quite well
(although only with SQL Server authentication). It's only after some
updates (Windows XP SP2 ? update on server ?) that it became impossible
to have the server registrated.

If you find the solution to this unpleasant problem for me, and you'll
ever visit Belgium, I'll buy you a 4-pack of the Best Belgian Beer (it's
called "Duvel").

Thanks !

ErwinB

PS. Now that I'm at it, I read that the default port 1433 should be
changed. Is there a range of ports available and suitable to this
purpose ? Thanks again

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)