Re: Server Registration fails - figure this out !

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/31/05 

Date: Tue, 30 Aug 2005 17:43:19 -0600

No...you are getting login failures. That article pertains
to connection failures. Similar but a bit different.
You are connecting but the authentication is failing. So you
reach the server (you don't in the article) and when SQL
Server checks the credentials for your login, that's where
you are failing.

-Sue

On Tue, 30 Aug 2005 13:26:59 +0200, ErwinB <eba@iqs.be>
wrote:

>Sorry to come back to my little question, but I found this article in MS
>Knowledge Base : http://support.microsoft.com/kb/839269/
>
>Could this be the same issue that I have with Windows SBS Server, e.g. a
>recent update that closed some ports in the firewall (RRAS-server) ? Or
>am I way off here ?
>
>ErwinB
>
>
>
>Sue Hoegemeier wrote:
>> Glad it's working.
>> I was more interested in trying to help you solve the
>> problem than in earning any beer. But if I ever get to
>> Belgium I'll remember the recommendation on what to drink
>> and do my best to keep drinking them to make sure they are
>> the best.
>> Have a good one and drink to my health anyway if you can.
>> Answering questions up here too often can take a toll on
>> one's health and sanity.
>>
>> -Sue
>>
>> On Mon, 29 Aug 2005 23:48:57 +0200, ErwinB <eba@iqs.be>
>> wrote:
>>
>>
>>>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
>>>>>>
>>>>>>
>>