all groups > sql server connect > december 2003 >
You're in the

sql server connect

group:

Cannot connect / Cannot Configure


Cannot connect / Cannot Configure Bob O-
12/31/2003 7:43:58 PM
sql server connect:
I installed SQL Server 2000 on Win2k3, and it seemed
to install correctly, but I could never connect to the
database. I uninstalled it and attempted to reinstall it,
but I always get this message "Setup failed to configure
the server" then it aborts.

I tried everything in MSKB #801499, but it still will not
install. I've deleted the install directories and temp
files too. Here's the text from the sqlstp.log file:

Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql
server};server=SANDBOX;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error
126 (sql server).
driver={sql
server};server=SANDBOX;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error
126 (sql server).
driver={sql
server};server=SANDBOX;UID=sa;PWD=;database=master
Specified driver could not be loaded due to system error
126 (sql server).
SQL Server configuration failed.

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

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

20:07:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -
Action 4 -Service MSSQLSERVER
20:07:55 Process Exit Code: (0)
20:07:55 StatsGenerate returned: 2
20:07:55 StatsGenerate
(0x0,0x1,0xf00000,0x0,1033,303,0x0,0x1,0,0,0
20:07:55 StatsGenerate -1,Administrator)
20:07:55 Installation Failed.

Any ideas are appreciated.

~Bob

RE: Cannot connect / Cannot Configure kevmc NO[at]SPAM online.microsoft.com
1/2/2004 9:03:20 PM
Looks like it could be a problem with the installation of the MDAC
components. Try shutting down all ODBC applications on the machine and
installing the latest bits for MDAC 2.6. (sevice pack 2)

http://www.microsoft.com/downloads/details.aspx?FamilyID=8e5f816c-4918-4250-
b8bd-3794582c9089&DisplayLang=en
Thanks,

Kevin McDonnell
Microsoft Corporation

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


RE: Cannot connect / Cannot Configure Bob O-
1/6/2004 1:44:46 PM
I tried your suggestion, but I still get the same error.
Take a look at this page that has log text:
http://www.microsvc.com/sqlstp.htm

~Bob


[quoted text, click to view]
RE: Cannot connect / Cannot Configure kevmc NO[at]SPAM online.microsoft.com
1/7/2004 12:43:08 AM
Run the MDAC Component Checker against your server. There is still an
underlying problem then.

307255 INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
http://support.microsoft.com/?id=307255

Thanks,

Kevin McDonnell
Microsoft Corporation

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


RE: Cannot connect / Cannot Configure Bob 0-
1/10/2004 7:11:13 PM
Kevin, thanks for your help. The checker shows mdac 2.8 rtm. Is this what I need?

----- Kevin McDonnell [MSFT] wrote: -----

Run the MDAC Component Checker against your server. There is still an
underlying problem then.

307255 INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
http://support.microsoft.com/?id=307255

Thanks,

Kevin McDonnell
Microsoft Corporation

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



RE: Cannot connect / Cannot Configure kevmc NO[at]SPAM online.microsoft.com
1/13/2004 9:58:24 PM
That is the latest version available for MDAC. Check the dasetup.log file
for errors. It should be in the following location.

C:\Winnt or C:\Windows


Thanks,

Kevin McDonnell
Microsoft Corporation

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


RE: Cannot connect / Cannot Configure bob NO[at]SPAM microsvc.com
1/15/2004 4:52:39 PM
Kevin, I looked over the log file and at the bottom it
says:

State after Install:
Setup was Successful: 1
Setup Requires Reboot: 0
Setup Will Reboot the Machine: 1
Exiting: Setup is shutting down..

Everything looks good to me. Suggestions?

Regards,
~Bob


[quoted text, click to view]
RE: Cannot connect / Cannot Configure kevmc NO[at]SPAM online.microsoft.com
1/19/2004 7:04:00 PM
Make sure you have both a SQLServer driver sqlsrv32.dll and sqlsrv32.rll
file with the same version.

Thanks,

Kevin McDonnell
Microsoft Corporation

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


RE: Cannot connect / Cannot Configure Bob O-
1/26/2004 7:01:05 PM
Kevin, These 2 files had slightly different versions, but when I checked these 2 file versions on a Win2k Server, they were the same as this server (slightly different). I copied them from Win2k Server to the Win2k3 server and SQL Server still does not want to configure at the end of the setup. Where do we go from here

RE: Cannot connect / Cannot Configure kevmc NO[at]SPAM online.microsoft.com
1/28/2004 11:56:52 PM
I would suggest opening up a support case so that an MDAC person can go
through your configuration more closely.

Thanks,

Kevin McDonnell
Microsoft Corporation

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


AddThis Social Bookmark Button