Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot start SQL Server 2000 on Windows XP Home Edition?

Posted on 2004-03-25
6
Medium Priority
?
1,451 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 13

Accepted Solution

by:
danblake earned 200 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

885 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