Re: Server Registration fails - figure this out !

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

Date: Mon, 29 Aug 2005 17:44:50 -0600

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: Salt in beer
    ... not worry about salt content. ... However, those who drink considerable ... quantities of liquid, whatever it is beer or water, ... health reasons, reallly... ...
    (rec.crafts.brewing)
  • Re: Server Registration fails - figure this out !
    ... > Have a good one and drink to my health anyway if you can. ... >>Thanks for your input, you must have a blessful influence on my server, ... >>PS I'm sorry to hear you're not interested in the finest Belgian beer. ...
    (microsoft.public.sqlserver.security)
  • BEER! Not Just for Breakfast, Its a Health Food!
    ... An entire decade of scientific research shows that drinking beer regularly, but moderately, can reduce some of the risks associated with aging. ... Heart attack - Like wine, beer's more refined brother, beer also has positive effects on the heart. ... Studies show that beer raises HDL or good cholesterol, and men who drink alcohol can reduce their risk of having a heart attack by as much as 35 percent when compared to men who don't drink. ... So in the coming summer heat, raise a glass to your health. ...
    (alt.politics)
  • Re: Red eye
    ... good health generally, no problems with blood pressure and suchlike. ... recent weeks I've noticed if I have a drink, nothing excessive, just one ... pint of beer for example, then my left eye swiftly becomes quite red, but ...
    (sci.med.vision)
  • Re: What the fuck?
    ... Alcohol is consumed by the great majority of ... "Beer was consumed to the exclusion of all else in the olden ... we should drink more beer now." ... Yes, alcohol is a drug technically, ...
    (rec.food.drink.beer)