cannot install SQL Server 2000 on Windows XP home edition

cannot install SQL Server 2000 on Windows XP home edition

Post by CRB » Fri, 24 May 2002 15:20:29



Greetings,

I am unable to install SQL Server 2000 Personal edition on my machine
running windows XP Home edition. According to the SQL Server web site,
 that is a valid configuration.

I have reinstalled MDAC just in case, even though the SQL Server setup
reinstalls it as part of the installation. I am using the default
install
with Typical settings. I have tried different combinations in the
install,
such as NT authentication vs. SQL Server authentication, but did not
have
any success. The setup always fail after the files are copied and the
install attempts to configure SQL Server with my settings. I have
included
the last lines of the sqlstp.log. I believe it has to do with the
settings
under which to run the services. I have been only able to use "local
system"
as the account for sqlsvr.exe and sqlagent.exe. For some reason any
other
account that I choose, is not recognized as an account in my domain.
remember,
I am using XP Home Edition.

Any help would be greatly appreciated.

CD

sqlstp.log
-------------------
...
Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=HP;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

driver={sql server};server=HP;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

driver={sql server};server=HP;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

SQL Server configuration failed.

###############################################################################

23:06:27 Process Exit Code: (-1)
23:06:31 Setup failed to configure the server.   Refer to the server
error logs and C:\WINDOWS\sqlstp.log for more information.
23:06:31 Action CleanUpInstall:
23:06:31 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4
-Service SQLSERVERAGENT
23:06:31 Process Exit Code: (1060) The specified service does not
exist as an installed service.

23:06:31 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4
-Service MSSQLSERVER
23:06:31 Process Exit Code: (0)
23:06:31 StatsGenerate returned: 2
23:06:31 StatsGenerate
(0x80000000,0x1,0xf000000,0x0,1033,303,0x0,0x1,0,0,0
23:06:31 StatsGenerate -1,Owner)
23:06:31 Installation Failed.

 
 
 

cannot install SQL Server 2000 on Windows XP home edition

Post by Jun Chen[M » Sat, 25 May 2002 17:13:17


Hi,

It seems MDAC is still not installed properly on the computer. Would you
please also check if the following registry key exists:

HKLM\Software\ODBC|ODBCINST.INI\SQL Server\Driver

It should be pointing to c:\winnt\system32\SQLSRV32.dll. If it is not
present, add this string key and the proper value.

Thanks,
Jun Chen

This posting is provided "AS IS" with no warranties, and confers no rights.