Re: Server Registration fails - figure this out !
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/29/05
- Next message: Steinarr G.: "Enterprice manager."
- Previous message: Russell Stevens: "Re: Internet password attacks"
- In reply to: ErwinB: "Re: Server Registration fails - figure this out !"
- Next in thread: ErwinB: "Re: Server Registration fails - figure this out !"
- Reply: ErwinB: "Re: Server Registration fails - figure this out !"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Aug 2005 06:29:54 -0600
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
>>
>>
- Next message: Steinarr G.: "Enterprice manager."
- Previous message: Russell Stevens: "Re: Internet password attacks"
- In reply to: ErwinB: "Re: Server Registration fails - figure this out !"
- Next in thread: ErwinB: "Re: Server Registration fails - figure this out !"
- Reply: ErwinB: "Re: Server Registration fails - figure this out !"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
