Hi again...
I'm looking for experienced(or anyone who knows)users of SQL Server 2000.
One of our customers runs windows 2003 SBS sp1 and tries to install sql server 2000 Standard Edition(which is needed for one of our company's applications to run - Yeap, we support that as well).This version doesn't run on this OS unless Sql server 2K SP3 or latest is installed.Without Sp3 installed the sql service cannot start.However, installation is supposed to end.In a finished installation sp3 can be applied and the service CAN start and everything goes fine.
On this certain occasion the install cannot end.On the installation log file I can see that everything is copied fine.However, the final lines are as follows:
Starting Service ...
Greek_CI_AI
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=SERVER;UID=<login>;PWD=<password>;database=master
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection
[Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.
driver={sql server};server=SERVER;UID=<login>;PWD=<password>;database=master
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection
[Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.
driver={sql server};server=SERVER;UID=<login>;PWD=<password>;database=master
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection
[Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.
SQL Server configuration failed.
###############################################################################
13:20:44 Process Exit Code: (-1)
13:21:22 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
13:21:23 Action CleanUpInstall:
13:21:23 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
13:21:23 Process Exit Code: (1060) The specified service does not exist as an installed service.
13:21:23 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
13:21:23 Process Exit Code: (0)
13:21:23 StatsGenerate returned: 2
13:21:23 StatsGenerate (0x0,0x1,0xf000,0x100,1033,303,0x0,0x1,0,0,0
13:21:23 StatsGenerate -1,Administrator)
13:21:23 Installation Failed.
And the installation rolls back.
I should mention that the troubleshoot process is made by phone...
In a normal case the service cannot be started.In this case it seems like the service cannot even be installed.That's why the install process rolls back.
I couldn't find anything helpful in any specialized forum I checked.Norton 2005 Antivirus installed but it shouldn't mean anything cause the same occurs with the Antivirus uninstalled.OS fully updated.
I've checked the ODBC driver needed for the SQL to run, it's listed in the registry and it exists on the path specified.Tried to re-register it by regsvr32 yet I get the message that the dllregisterserver entry point was not found which means that the file specified is not a valid .dll file(BTW same s*** happens on my machine which runs xp but everything works just fine)
Same goes for the file ntwdblib.dll which is the client part of SQL Server.
It's a long shot I just wonder if anyone came accross this situation(Ok, it's not that usual and it is rather speciallized)or any ideas whatsoever.
Thanx in advance
