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

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

"Masked Rider" <GoShopping@rogers.com> wrote in message
news:gEGUc.1787847$Ar.325137@twister01.bloor.is.net.cable.rogers.com...
> 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.
> > >
> > >
> >
> >
>
>