installation help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

installation help

Author

Topic

ravin4u
Starting Member

6 Posts

Posted - 2007-12-04 : 11:11:47

hi

i m trying installing sqlserver 2000 in my PC(WIN XP). all the process are happening properly.. but while starting SQL and Configuring the database the setup exists and throws the message to check sqlstp.log.

when checked, i got this error.... please help

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

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

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

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

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

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

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

SQL Server configuration failed.

thanks in advance

regards
Ravin

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-12-04 : 11:15:26

What version of SQLServer are you attempting to install on XP? Note that not all versions will work on XP.

Future guru in the making.

ravin4u
Starting Member

6 Posts

Posted - 2007-12-04 : 11:17:08

as mentioned in my topic SQL SERVER 2000

quote:
Originally posted by Zoroaster

What version of SQLServer are you attempting to install on XP? Note that not all versions will work on XP.

Future guru in the making.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 11:17:16

Which edition of SQL Server 2000 are you trying to install on your Windows XP?

E 12°55'05.25"
N 56°04'39.16"

ravin4u
Starting Member

6 Posts

Posted - 2007-12-04 : 11:18:48

sorry its workgroup edition

quote:
Originally posted by Peso

Which edition of SQL Server 2000 are you trying to install on your Windows XP?

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 11:21:01

Only Express edition and Developer edition are available to install on Windows XP.

E 12°55'05.25"
N 56°04'39.16"

ravin4u
Starting Member

6 Posts

Posted - 2007-12-04 : 11:23:36

but i installed in another XP machines its working fine....

quote:
Originally posted by Peso

Only Express edition and Developer edition are available to install on Windows XP.

E 12°55'05.25"
N 56°04'39.16"

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-12-04 : 11:32:03

2000 Workgroup edition is supported to work with XP, sounds like your ODBC registry settings are missing. Check HKEY_LOCAL_MACHINE\Software\ODBC\ and compare to your other working XP install and see if there is anything missing there.

Future guru in the making.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 11:33:28

You are right. It seems Workgroup Edition can be installed in Windows XP.
Here is some text from Microsoft.com

quote:
Operating System for Workgroup Edition
Microsoft Windows 2000 Server with Service Pack (SP) 4 or later; Windows 2000 Professional Edition with SP 4 or later; Windows XP with Service Pack 2 or later; Windows Server 2003 Standard Edition, Enterprise Edition, or Datacenter Edition with Service Pack 1 or later; Windows Small Business Server 2003 with SP 1 or later

E 12°55'05.25"
N 56°04'39.16"

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-12-04 : 11:36:02

One thing to try also is reinstalling MDAC on the machine:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
Do that and reboot and see if that works, if not then do the stare and compare in the registry I suggested earlier.

Future guru in the making.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources