Solved

Cannot start SQL Server 2000 on Windows XP Home Edition?

Posted on 2004-03-25
6
1,441 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

773 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