Re: Server Registration fails - figure this out !

• Previous message: Andrew J. Kelly: "Re: Users and Truncate Table"
• In reply to: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Next in thread: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Reply: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 29 Aug 2005 23:48:57 +0200

Hi Sue

Thanks for your input, you must have a blessful influence on my server,
because all of a sudden, I was granted permission to connect ! Okay, not
by a Windows account, but by SQL Server authentication. Oh well, as long
as I have the server registered in my Enterprise Manager, it's ok to me. !
So thanks again !

ErwinB

PS I'm sorry to hear you're not interested in the finest Belgian beer.
I'll drink them instead to your good health !

Sue Hoegemeier wrote:
> Not interested in the 4 pack but keep in mind that just
> looking at the registry setting doesn't mean it is actually
> running in that mode. If it was changed since startup, the
> service needs to be restarted.
> Try connecting with another client tool on another PC -
> Query Analyzer or osql - with sa or login as the domain user
> and use windows authentication to connect.
>
> -Sue
>
> On Mon, 29 Aug 2005 04:09:44 +0200, ErwinB <eba@iqs.be>
> wrote:
>
>
>>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
>>>
>>>
>

• Previous message: Andrew J. Kelly: "Re: Users and Truncate Table"
• In reply to: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Next in thread: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Reply: Sue Hoegemeier: "Re: Server Registration fails - figure this out !"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]