Re: Server Registration fails - figure this out !

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

  • Next message: Aramid: "Re: PUBLIC db role" 
    Date: Mon, 29 Aug 2005 04:09:44 +0200

    Hi Sue !

    Thanks for replying.
    But I have to say : nice try, but no cigar !
    1. In the Windows registry, the mode is set to mixed
    2. the windows account has a login, has a default database available and
    isn't denied trouhg any other group membership

    Guess you'll have to do better to get the 4-pack "Duvel" :-)

    ErwinB

    Sue Hoegemeier wrote:
    > The error message:
    > "Login failed for user 'sa'. Reason : not associated with a
    > trusted SQL server connection"
    > indicates you aren't using mixed authentication. Maybe
    > someone reset it to use mixed but didn't restart the service
    > after making the change.
    > Make sure the windows account being used has a login, has
    > their default database available and isn't denied through
    > any other group membership.
    >
    > -Sue
    >
    > On Sun, 28 Aug 2005 15:49:52 +0200, ErwinB <eba@iqs.be>
    > wrote:
    >
    >
    >>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
    >
    >

  • Next message: Aramid: "Re: PUBLIC db role"

    Relevant Pages

    • Re: How to Maintain an IIS Server?
      ... > server running on a Windows 2000 server. ... before a firewall and antivirus have been installed]. ... open ports; however, this will not identify which program is using the port. ...
      (microsoft.public.inetserver.iis.security)
    • LPD/LPR printing or alternative
      ... Configuring LPD for Microsoft Windows XP or Windows 2003 Server ... LPR port. ... protocol address of the HP Jetdirect print server. ...
      (comp.os.os2.misc)
    • RE: xp pro sharing printer
      ... How to troubleshoot network printing problems in Windows XP ... SMB-connected print server ... Incompatible print driver ... and then redirect the port to the network server. ...
      (microsoft.public.windowsxp.security_admin)
    • Re: How to Maintain an IIS Server?
      ... >> server running on a Windows 2000 server. ... > before a firewall and antivirus have been installed]. ... > program or executable using that port. ...
      (microsoft.public.inetserver.iis.security)
    • RE: Printing from Win9x clients stops
      ... since this issue only occurs on all Windows 9x ... Open Server Management Console, ... Verify basic network connectivity. ... >> Create a local printer and in the Ports section, ...
      (microsoft.public.windows.server.sbs)