Sql Server Install Failure - 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

SQL Server 2000 Forums

SQL Server Administration (2000)

Sql Server Install Failure

Author

Topic

grahambo
Starting Member

3 Posts

Posted - 2007-06-28 : 05:39:56

Hi all

I am attempting to install SQL Server 2000 on my machine and I am having an issue at the end of the installation when SQL tries to configure and setup the server

It says SQL was unable to configure server please check the log files. I have done so and below is where the error is happening

does anyone have any idea on how to fix this? It installs fine on my other machine it just seems to be this one that is giving me the problem. You should also note that I am installing SQLserver using debug mode due to an MDAC error im getting (I am using windows XP SP2 and the version of SQL is 2000 personal edition).

Any info anybody has on this problem is very much appriciated

Cheers
Graham

setupsql.log
###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=KARENSLAPTOP\TEST;UID=sa;PWD=;database=master

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

driver={sql server};server=KARENSLAPTOP\TEST;UID=sa;PWD=;database=master

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

driver={sql server};server=KARENSLAPTOP\TEST;UID=sa;PWD=;database=master

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

SQL Server configuration failed.

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

grahambo
Starting Member

3 Posts

Posted - 2007-06-28 : 09:13:36

All,

This problem was solved by doing the following

Open Windows Explorer, Navigate to the Windows Directory then going to the INF folder

Scroll down to MDAC.inf right click on the file and click install, it will ask you for a windows CD

should fix the problem

Graham

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources