SQL Server Performance Forum – Threads Archive

[SOLVED] Installation issues on Win2k SP4

Hi, Sorry if this has already been asked. I will search the forums after posting this, but it is an urgent matter which I must resolve as soon as possible, hence the post. While attempting to install MS SQL Server 2000 Enterprise on Windows 2000 (SP4,) the installation constantly fails, while it attempts to start the service during the installation process. The error message is something vague, stating the service could not be started, and to check the log file (sqlstp.log). All I can see in the log file are named pipes issues. Any help would be appreciated. Log File Contents: <blockquote id="quote">quote:<hr height="1" noshade id="quote"> 10:56:11 C

rogram FilesMicrosoft SQL Server80ToolsBinncnfgsvr.exe -F "C:WINNTsqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 65792 -U sa -P ############################################################################### Starting Service … SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659 Connecting to Server … driver={sql server};server=QA-MANDB-01;UID=sa<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken. [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()). driver={sql server};server=QA-MANDB-01;UID=sa<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken. [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()). driver={sql server};server=QA-MANDB-01;UID=sa<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=;database=master [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken. [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()). SQL Server configuration failed. ############################################################################### 10:56:36 Process Exit Code: (-1) 10:56:47 Setup failed to configure the server. Refer to the server error logs and C:WINNTsqlstp.log for more information. 10:56:47 Action CleanUpInstall: 10:56:47 C:WINNTTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT 10:56:47 Process Exit Code: (1060) The specified service does not exist as an installed service. 10:56:47 C:WINNTTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER 10:56:47 Process Exit Code: (0) 10:56:47 StatsGenerate returned: 2 10:56:47 StatsGenerate (0x0,0x1,0xf00,0x400,1033,303,0×0,0x1,0,0,0 10:56:47 StatsGenerate -1,Terminator) 10:56:47 Installation Failed. <hr height="1" noshade id="quote"></blockquote id="quote"> I found this in another thread, but it did not resolve the installation issue. <blockquote id="quote">quote:<hr height="1" noshade id="quote"> Stop the following services [before installing]: IIS – Internet Information Server Exchange Server SNA Server Disk Keeper SNMP Service Anti-virus software (such as McAfee) Backup products (such as ARC Server) <hr height="1" noshade id="quote"></blockquote id="quote">

So, it’s actually installing SQL Server but can’t start the service??? That’s what it looks like. Go to Control Panel/Administrative Tools/Services . See if the MSSQLSERVER and SQLServerAgent services are running. If they are, let’s work on it from there. It sounds like an authentication issue, which shouldn’t be that big of a deal to fix. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Hi, The installation actually fails (note the log output.) No MSSql services are listed in the services applet. Also, there is a warning in the event viewer from when it attempts to start MS SQL Server during the installation. Event Viewer Warning: <blockquote id="quote">quote:<hr height="1" noshade id="quote"> Event Type:Warning Event Source:MSSQLServer Event Category

<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Event ID:19011 Date:8/24/2004 Time:4:16:53 PM User:N/A Computer:QA-MANDB-01 Description: The description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: (SpnRegister) : Error 1355. <hr height="1" noshade id="quote"></blockquote id="quote"> Thanks!

Sweet. Look in your registry and see if you have these keys. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer If you do, you have a few options: 1. Delete them and restart the installation process. (I don’t recommend this one.)
2. Reinstall your OS and start over. (I do recommend this one if you’re cheap.)
3. Call MS Support and do whatever they tell you to do. (I definitely recommend this one. It’s $250.00 per incident.) MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

This is one of the critical parts of Kerberos and SQL Server interaction. With SQL Server, you can run the SQL Server service under one of the following: a LocalSystem account, a local user account from another computer, or a domain user account. When the computer that is running SQL Server starts, it tries to register its own SPN in Active Directory by using the DsWriteAccountSpn API call. If the call is not successful, the following warning is logged in Event Viewer: Source: MSSQLServer EventID: 19011 Description: SuperSocket info: (SpnRegister)
http://support.microsoft.com/?id=811889 – How to troubleshoot the "Cannot generate SSPI context" error message. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by derrickleggett 1. Delete them and restart the installation process. (I don’t recommend this one.) <hr height="1" noshade id="quote"></blockquote id="quote"> Tried this about 12 times, using different accounts (local system, local admin) and had the same error each time. I have not tried this using the domain admin account as the server itself is on the network, but in a workgroup. I did not join it to the domain. Now I’m wondering if that could be the issue? 2. Fresh Install: I’ve given that some thought, and who’s to say it just won’t happen again? 3. MS Support: Costs money….. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />]

I wouldn’t give 2 some thought. I would do it. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

We formatted the hard drive earlier today and re-installed everything. This solved the issue. Thanks!

It usually does. lol Glad your issue is fixed. Hopefully, you’ll never have to go through this again. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

]]>