February 13, 2006 at 8:53 am
Hi all,
I was reinstalling SQL 2000 but at the end I received a message that shows "Setup failed to configure the server. Refer to the server error logs and C:\WINNT\sqlstp.log for more information"
I was looking at this file but I don't find the reason because the installation is failing.
I include the las part of this file "sqlstp.log":
Starting Service ...
Modern_Spanish_CS_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=name_server;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=name_server;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=name_server;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
###########################################
16:20:49 Process Exit Code: (-1)
16:21:07 Setup failed to configure the server. Refer to the server error logs and C:\WINNT\sqlstp.log for more information.
16:21:07 Action CleanUpInstall:
16:21:07 C:\DOCUME~1\SUPERV~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
16:21:07 Process Exit Code: (1060) The specified service does not exist as an installed service.
16:21:07 C:\DOCUME~1\SUPERV~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
16:21:07 Process Exit Code: (0)
16:21:07 StatsGenerate returned: 2
16:21:07 StatsGenerate (0x0,0x1,0xf00,0x100,1033,303,0x0,0x1,0,0,0
16:21:07 StatsGenerate -1,supervisor)
16:21:07 Installation Failed.
I deleted all files about SQL folder but it happens again. I don't know if I can delete something in the registry and like this to can install it.
Someone knows anything about this?
Any suggestion will be appreciate.
Thanks
February 13, 2006 at 10:57 am
Can you give me some background on what happened to this server that you need to re-install SQL Server? I would recommend first un-installing SQL Server and doing a fresh install as opposed to attempting to re-install over the top of an existing SQL Server instance. This may sound silly, but are you performing the install using a local admin account?
February 14, 2006 at 2:19 am
I installed SQL Server and Analisys Services and later I un-install Analisys Services. When I wanted to connect to the server from EM, it's was imposible. The MSSQLServer service is started but I can't work with EM.
Then, I decided un-install SQL Server too and to install it again from fresh install. I have tried it twice.
All installation process is good but at the end of the process is showed the error message.
I saw into the sqlstp.log file two things:
About rights... yes, the account is local admin.
Thanks for your help.
February 14, 2006 at 4:06 am
1. Please go to Control Panel => ODBC Administrator and check that you have SQL Driver listed
2. If not, download component checker from support.microsoft.com and check MDAC dll versions
3. If there are mismatches, apply proper MDAC Service pack.
4. I am available at bmlakhani@yahoo.com feel free to ping me in next 2 hour.
February 14, 2006 at 5:15 am
In the Control Panel I haven't SQL driver.
I run component checker but it shows the message "The following products releases were matched: UNKNOWN"
After, I have installed MDAC 2.7.1 but in the Control Panel didn`t appear anything.
I did a test. I installed Connectivity only in SQL Server and this option was installed success and I can open "Client Network Utility". In the Control Panel doesn't appear anything in Drivers tab.
Now, I will try to install again SQL Server.
I told you the results.
Thanks
February 14, 2006 at 5:21 am
lets do this.
Delete below key from Registry (please take backup) and reinstall MDAC
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents
Reinstall MDAC and run component checker again
February 14, 2006 at 5:37 am
I can't delete this value.
I received the message "Unable to delete all specified values"
The value into this key is :
I tested to delete all key (included the ExceptionComponent folder) and I could, but I exported again (I think you told me that I delete only the value of the key and not the folder.)
February 14, 2006 at 5:40 am
You wil find many GUID (Long numbers; something like {DD90D410-1823-43EB-9A16-A2331BF08799}) under that key.
Please try deleting them and reinstall MDAC
February 14, 2006 at 5:44 am
Only there is the value that I told you.
There aren't anymore.
February 14, 2006 at 5:44 am
Is there any driver listed in ODBC Administartor??
February 14, 2006 at 5:47 am
No.
There aren't any drivers listed in ODBC. I think is very strange. I have W2003 SP1 installed.
February 14, 2006 at 6:03 am
That's interesting
Download a tool from below link and run it
http://www.betav.com/Files/Content/Tools/tools.htm
Download mdacrt.exe from there any Run it. You should see drivers listed there after this...
Once you see drivers listed there, then Try running Setup.
Let me know results
February 14, 2006 at 7:53 am
Although I saw in the web that the tool was for W2000, I did a registry backup and I run the MDAC repair.
After I take a look into ODBC Administrator and, surprise, I had severals drivers installed. One of then was SQL Server.
Then I installed again SQL Server and now all has been success.
Note: I looked at the registry key (HKLM\...\...\CurrentVersion\Setup\ExceptionComponents) for curiosity and the value is the same. I don't know whether that is good or bad. Besides, I re-run again component checker and I received the same error message "UNKNOWN".
I think the most important is that I could install the application. I hope in a next future that I haven't errors in the server.
Many thanks for your help.
February 14, 2006 at 6:26 pm
Nice to hear that issue is resolved by solution provided by me.
I have no idea why Component Checker returns unknown.
If you need any help in that, I need to do some research. Let me know if you need reason for this.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply