Re: User Login Failed

From: Masked Rider (GoShopping_at_rogers.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 10:59:24 GMT

Just tried to do that. But after I changed it to Mixed Mode, when I bring
up the security tab again, it's back to Windows only. Somehow, it's not
allow me to change that. Thanks!

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:eoPDAHPhEHA.3632@TK2MSFTNGP09.phx.gbl...
> Does SQL Server allow mixed mode? Right-click on the server name in
> Enterprise Manager, select Properties, Security tab and check the
> Authentication part.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
> "Masked Rider" <GoShopping@rogers.com> wrote in message
> news:VXzUc.14$euc.11@news04.bloor.is.net.cable.rogers.com...
> > Hi, I've just installed Sql 2000 (and sp3a) on my Win 2003 server. But
I
> > have trouble connecting to it from my client machine. I keep getting
this
> > error when registering: "User login failed: Not associated with a
trusted
> > Sql Server connection". The client machine is running on XP Home. The
> user
> > I've setup uses Authentication with SQL Server because XP Home does not
> > allow for Window Domain logon.
> >
> > Also, when I bring up the properties of the user (on the Server), the
> number
> > of "*" appearing in the password field does not match the number of
> > character of the password I setup. It seems that no matter what length
of
> > password I'm setting up, the properties always shows it as "**********"
> (10
> > "*"). Is that normal???
> >
> > Any help is much appreciated.
> >
> >
>
>

Relevant Pages

  • Re: Cannot open database requested in login
    ... Ive just checked that and it is set to mixed mode. ... > you sql server is in windows authentication mode, ... > you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)
  • Re: Migrating from NT to Win2k in native mode
    ... from mixed mode authentication to Windows only authentication? ... What are the effects of switching SQL Server from 'Mixed mode' to 'Windows ...
    (microsoft.public.sqlserver.security)
  • Re: Registry
    ... I'm confused as to what Windows Only mode will buy you ... assuming that you don't use Mixed Mode logins for you day- ... to-day activities on the server (so that no passwords are ... >Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot open database requested in login
    ... you sql server is in windows authentication mode, ... you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)
Quantcast