register local instance with MSDE

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?
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?
>
>
|||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...
>
>
|||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...[vbcol=seagreen]
> 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:
|||Sorry for confusion!
I just put MSDE in front of SQL Server Enterprise Manager to emphasize that
it is MSDE not SQL Server.
Thanks
"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...
>
>