error 1069

[Richard Knispel]

I asked this question elsewhere, but I am still hoping for some clue. I
can't start SQL server because the login doesn't work on my home WinXP
computer.

This is what I did:
Downloaded GER_SQLEVAL from <http://download.microsoft.com/> (274MB)
It installed nicely and autostarts "SQL Server Service Manager" after
power up.
In the Programs folder I now have
- Books Online
- Client Network Utility
- Configure SQL XML Support in IIS
- Enterprise Manager
- Import and Export Data
- Profiler
- Query Analyzer
- Server Network Utility

This is what I got:
The SQL Server Manager offers my PC as Server and 3 services:
- Distibuted Transaction Coordinator
- SQL Server
- SQL Server Agent

All attempts to start on of the services end with error 1069 "incorrect
login" (fehlerhafte Anmeldung)

What did I miss?

Richard

[Erland Sommarskog]

Richard Knispel (mu*******@12move.de) writes:

This is what I got:
The SQL Server Manager offers my PC as Server and 3 services:
- Distibuted Transaction Coordinator
- SQL Server
- SQL Server Agent

All attempts to start on of the services end with error 1069 "incorrect
login" (fehlerhafte Anmeldung)

It seems that you have set up SQL Server with domain login (as opposed
to the local service account), but this login does either not exist,
or the password for it is in correct.

Right-click My Computer, choose Manage, find Services, and in this list
find the MSSQL Server services. Right-click the service, select Properties
and then go to the Log On tab to remedy the problem.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Richard Knispel]

Erland Sommarskog schrieb:

It seems that you have set up SQL Server with domain login (as
opposed to the local service account), but this login does either
not exist, or the password for it is incorrect.

Right-click My Computer, choose Manage, find Services, and in this
list find the MSSQL Server services. Right-click the service, select
Properties and then go to the Log On tab to remedy the problem.

Seems like I am making some progress now. In fact I didn't have password
protected acounts on my computer up to now. Maybe this is necessary. And
I certainly didn't have a domain logon activated either. (WinXP)

Still somewhat puzzled, but I can start those SQL services now. Thanks
for the help.

Richard