Solved

Cannot start SQL Server 2000 on Windows XP Home Edition?

Posted on 2004-03-25
6
1,438 Views
Last Modified: 2012-06-21
Hi,

I have on my computer Windows XP Home Edition,
and installed the developer edition of SQL Server 2000.

When I try to start the service "MSSQLSERVER", it is not
started. As user-name I use the name, with which I am
logged in to my computer, as passwort I use the passwort,
which I entered while the installation process.

In the event-log / applications I get the following message:
SuperSocket-Information: (SpnRegister) : Error 1355.
Weitere Informationen über die Hilfe- und Supportdienste erhalten
Sie unter http://go.microsoft.com/fwlink/events.asp.


When I try to start MSSQLSERVER manually, I get the message
"Error 1069: The service could not be started because of a
 wrong login"

What´s wrong?
0
Comment
Question by:spetrowitsch
  • 5
6 Comments
 
LVL 13

Expert Comment

by:danblake
ID: 10675393
SQL Server is not supported on Windows XP Home Edition.

You require a server based operating system such as Win NT4 (SP6), Windows 2000 (SP3 or above recommended), Windows 2003
0
 
LVL 13

Expert Comment

by:danblake
ID: 10675397
If you need SQL Server for Windows XP, you can try the cut-down version: MSDE (Free -- available from MS as a download).
0
 
LVL 6

Expert Comment

by:billy21
ID: 10675511
You don't need a server based operating system for SQL Server 2000 Developer Edition.  Only for Standard, Enterprise and Professional.  I am running Developer on XP Pro which is NOT a server OS.  I;'ve never tried it on Home though it may not be supported.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 13

Accepted Solution

by:
danblake earned 50 total points
ID: 10675537
Looks like I'm wrong:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

What login is the  MSSQLSERVER service using (Start -> Admin Tools -> Services) ?

Try changing this to the localsystem account on Win XP Home, and then try starting the service manually.
0
 
LVL 13

Expert Comment

by:danblake
ID: 10675581
It could be your local Win XP Account does not have log on as a service permissions, and this is the reason why the service could not be started.
0
 
LVL 13

Expert Comment

by:danblake
ID: 10675596
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now