"Jay" <Jay@discussions.microsoft.com> wrote in message
news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@microsoft.com...
> Thank you Norman for your clarification.
>
> In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL
> Server
> Groups, I am trying to connect (LOCAL)(Windows NT: this is my local
> machine).
> I am having this error message: Connection Failed, check SQL server
> Registration
>
> 1.Using Windows Authentication in "Edit SQL Server Registration
> Properties"
> Error message: A connection can not be established to (LOCAL).
> Reason: Login failed
>
> 2.SQL Server Authentication in "Edit SQL Server Registration Properties"
> Error message: SQL server registration failed.
> Login failed for user.
>
> 3. Network administrator can connect to this "LOCAL" machine.
>
> Will you help me to clear oou my confused minds?
>
> Thanks, again.
>
>
> "Norman Yuan" wrote:
>
>> What exactly do you mean "register local instance with MSDE"?
>>
>> When you say "SQL Server authentication keep rejecting my login id and
>> password", do you mean you was trying to connect to the MSDE by supplying
>> username/password pair (meaning the MSDE must be enabled on mixed
>> security
>> mode)? Since by default installation, only Windows Integrated
>> Authentication
>> mode is enabled, unless you specifically enabled mixed security mode on
>> the
>> MSDE, you will not be able to access the MSDE by supplying
>> username/password. This could be the cause of your problem.
>>
>> "Jay" <Jay@discussions.microsoft.com> wrote in message
>> news:C83EC5C8-012D-4155-AA55-5228713A967C@microsoft.com...
>> > Thanks in advance.
>> >
>> > I am trying to register my local machine with MSDE 2000.
>> >
>> > SQL server authetication keep rejecting my login id and password.
>> > Please, advised me why it is not accepting.
>> > Is it because I don't have installed server portion of SQL 2000
>> > Server?
>> >
>> >
>> >
>> >
>>
>>
>>

"Arnie Rowland" wrote:

> There is no such product as: "MSDE SQL Server Enterprise Manage".
>
> Are you using EM with a properly licensed SQL Server installation?
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "Jay" <Jay@discussions.microsoft.com> wrote in message
> news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@microsoft.com...
> > Thank you Norman for your clarification.
> >
> > In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL
> > Server
> > Groups, I am trying to connect (LOCAL)(Windows NT: this is my local
> > machine).
> > I am having this error message: Connection Failed, check SQL server
> > Registration
> >
> > 1.Using Windows Authentication in "Edit SQL Server Registration
> > Properties"
> > Error message: A connection can not be established to (LOCAL).
> > Reason: Login failed
> >
> > 2.SQL Server Authentication in "Edit SQL Server Registration Properties"
> > Error message: SQL server registration failed.
> > Login failed for user.
> >
> > 3. Network administrator can connect to this "LOCAL" machine.
> >
> > Will you help me to clear oou my confused minds?
> >
> > Thanks, again.
> >
> >
> > "Norman Yuan" wrote:
> >
> >> What exactly do you mean "register local instance with MSDE"?
> >>
> >> When you say "SQL Server authentication keep rejecting my login id and
> >> password", do you mean you was trying to connect to the MSDE by supplying
> >> username/password pair (meaning the MSDE must be enabled on mixed
> >> security
> >> mode)? Since by default installation, only Windows Integrated
> >> Authentication
> >> mode is enabled, unless you specifically enabled mixed security mode on
> >> the
> >> MSDE, you will not be able to access the MSDE by supplying
> >> username/password. This could be the cause of your problem.
> >>
> >> "Jay" <Jay@discussions.microsoft.com> wrote in message
> >> news:C83EC5C8-012D-4155-AA55-5228713A967C@microsoft.com...
> >> > Thanks in advance.
> >> >
> >> > I am trying to register my local machine with MSDE 2000.
> >> >
> >> > SQL server authetication keep rejecting my login id and password.
> >> > Please, advised me why it is not accepting.
> >> > Is it because I don't have installed server portion of SQL 2000
> >> > Server?
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>