Re: Server Registration fails - figure this out !

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

Date: Tue, 30 Aug 2005 13:26:59 +0200

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
>>>>>
>>>>>
>

Relevant Pages

  • Re: Server Registration fails - figure this out !
    ... Have a good one and drink to my health anyway if you can. ... but by SQL Server authentication. ... >PS I'm sorry to hear you're not interested in the finest Belgian beer. ...
    (microsoft.public.sqlserver.security)
  • Re: Zen Beer! Woo-HOO!
    ... Are they insinuating that you drink beer for the health aspect? ... "People consuming alcohol in moderate amounts ...
    (rec.sport.billiard)
  • Alcohol is making women fat
    ... AS women catch up with men in the drinking stakes, ... International health and longevity expert Dr John Tickell cited extended ... "The social pressures on the way we eat and drink are just so different to ...
    (soc.men)
  • Re: Restaurant Rules as written by your server
    ... The next time you're out eating at a resturant, look at your server. ... You want to yell at someone, ... If you order a fru-fru drink it might take the bartender a minute to ...
    (rec.food.cooking)
  • Re: Natural nausea treatment for chemo patients
    ... The diet soda we drink ... It is causing health problems on a scale never before seen. ... Big Pharmacy, medical profession, food industry, FDA, and politicians ... If it is not organic we should not eat or drink it ...
    (rec.org.mensa)