Midtown Computer Systems Enterprise

Convenient web based access to our favorite computer related Usenet groups.
MCSE.MS is not affiliated with Microsoft corporation, Cisco corporation, Oracle, CompTIA or any other vendor.
Check our Computer Hardware forum | Cell Phones reviews

Go Back  MCSE > Microsoft software reviews > Microsoft SQL server reviews > Microsoft SQL Server


Microsoft SQL Server microsoft.public.sqlserver.server

 
 
Thread Tools Display Modes
  #1  
Old 07-19-04, 07:18 PM
xsw
sql server installation hung/slow
I have a brand new server (windows 200) and trying to install sql server 2000 enterprise edition.

1) Tried to install directly from CDROM. It took almost 10 minutes for the welcome screen to come up:
12:21:48 Begin Setup
12:21:48 8.00.194
12:21:48 Mode = Normal
12:21:48 ModeType = NORMAL
12:21:48 GetDefinitionEx returned: 0, Extended: 0x0
12:21:48 ValueFTS returned: 1
12:21:48 ValuePID returned: 1
12:21:48 ValueLic returned: 1
12:21:48 System: Windows NT Terminal Server
12:21:48 SQL Server ProductType: Enterprise Edition [0x3]
12:21:48 Begin Action: SetupInitialize
12:21:48 End Action SetupInitialize
12:21:48 Begin Action: SetupInstall
12:21:48 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
12:21:48 CommonFilesDir=C:\Program Files\Common Files
12:21:48 Windows Directory=C:\WINNT\
12:21:48 Program Files=C:\Program Files\
12:21:48 TEMPDIR=C:\WINNT\TEMP\
12:21:48 Begin Action: SetupInstall
12:21:48 digpid size : 164
12:21:48 Begin Action: CheckFixedRequirements
12:21:48 Platform ID: 0xf00
12:21:48 Version: 5.0.2195
12:21:48 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1400
12:21:48 End Action: CheckFixedRequirements
12:21:48 Begin Action: ShowDialogs
12:21:48 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
12:21:48 Begin Action ShowDialogsHlpr: 0x1
12:21:48 Begin Action: DialogShowSdWelcome
12:30:01 Action Exit Handler:
12:30:02 StatsGenerate returned: 2
12:30:02 StatsGenerate (0x0,0x0,0xf00,0x0,1033,0,0x0,0x0,0,0,0
12:30:02 StatsGenerate -1,)

2) tried to install from local harddrive. The installation was successful. But it took 20 minutes for MDAC installation even to start:

18:10:29 Process Exit Code: (0)
18:10:29 Begin: InstallPkgs(ID_INSTALLMDAC)
18:10:29 Begin Action: Locked Connectivity Files Check
18:10:29 ConnectivityLocked returned: 0
18:10:29 The operation completed successfully.

18:10:29 End Action: Locked Connectivity Files Check
18:10:29 Setup is installing Microsoft Data Access Components (MDAC) ...
18:10:29 C:\sql2ksp3\x86\Other\sqlredis.exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS"
18:32:00 ExitCode: 0
18:32:00 End: InstallPkgs(ID_INSTALLMDAC)
18:32:00 **** STARTING OPEN OP IN WRITE MODE ****
18:32:00 **** CLOSED OPEN OP IN WRITE MODE ****
18:32:00 Begin: MoveFileData()
18:32:00 Enabled SELFREGISTERBATCH
18:32:00 Enabled CORECOMPONENTHANDLING
18:32:02 Begin Action: MoveFileDataSpecial
18:32:02 End Action: MoveFileDataSpecial
....................................

Any help is understanding the reason is highly appreicated. Thank you!
  #2  
Old 07-20-04, 04:16 AM
Sadeesh[MSFT]
Re: sql server installation hung/slow
Hi

Please try the below mentioned suggestion and let us know the behavior.
a.. Switch all services to Manual mode; however, do not touch the
following services (if present):

Alerter
Cluster Service
Computer Browser
Event Log
Kerberos Key Distribution Center (if servers are DCs)
License Logging Service
Messenger
Net Logon
NTLM Security Support Provider
Network Connectors
Plug and Play
Remote Procedure Call (RPC) Locator
Remote Procedure Call (RPC) Service
Remote Registry Service
Server
Print Spooler
TCP/IP NetBIOS Helper
Time Service
Workstation

Note: Some installations may not have all these services, because this list
covers both Windows NT 4.0 Enterprise Edition and Windows 2000 Advanced
Server.


Close Control Panel, and then restart the server. This clears the memory of
DLLs loaded by services; otherwise, these services would remain in memory
and hold locks on system resources.

Try to Install SQL Server and let us know if there is any difference.

HTH
Regards
Sadeesh

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

"xsw" <xsw@discussions.microsoft.com> wrote in message
news:679FAB8A-D47E-467A-B476-5B0B23C64062@microsoft.com...
>I have a brand new server (windows 200) and trying to install sql server
>2000 enterprise edition.
>
> 1) Tried to install directly from CDROM. It took almost 10 minutes for
> the welcome screen to come up:
> 12:21:48 Begin Setup
> 12:21:48 8.00.194
> 12:21:48 Mode = Normal
> 12:21:48 ModeType = NORMAL
> 12:21:48 GetDefinitionEx returned: 0, Extended: 0x0
> 12:21:48 ValueFTS returned: 1
> 12:21:48 ValuePID returned: 1
> 12:21:48 ValueLic returned: 1
> 12:21:48 System: Windows NT Terminal Server
> 12:21:48 SQL Server ProductType: Enterprise Edition [0x3]
> 12:21:48 Begin Action: SetupInitialize
> 12:21:48 End Action SetupInitialize
> 12:21:48 Begin Action: SetupInstall
> 12:21:48 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
> ...
> 12:21:48 CommonFilesDir=C:\Program Files\Common Files
> 12:21:48 Windows Directory=C:\WINNT\
> 12:21:48 Program Files=C:\Program Files\
> 12:21:48 TEMPDIR=C:\WINNT\TEMP\
> 12:21:48 Begin Action: SetupInstall
> 12:21:48 digpid size : 164
> 12:21:48 Begin Action: CheckFixedRequirements
> 12:21:48 Platform ID: 0xf00
> 12:21:48 Version: 5.0.2195
> 12:21:48 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1400
> 12:21:48 End Action: CheckFixedRequirements
> 12:21:48 Begin Action: ShowDialogs
> 12:21:48 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 12:21:48 Begin Action ShowDialogsHlpr: 0x1
> 12:21:48 Begin Action: DialogShowSdWelcome
> 12:30:01 Action Exit Handler:
> 12:30:02 StatsGenerate returned: 2
> 12:30:02 StatsGenerate (0x0,0x0,0xf00,0x0,1033,0,0x0,0x0,0,0,0
> 12:30:02 StatsGenerate -1,)
>
> 2) tried to install from local harddrive. The installation was
> successful. But it took 20 minutes for MDAC installation even to start:
>
> 18:10:29 Process Exit Code: (0)
> 18:10:29 Begin: InstallPkgs(ID_INSTALLMDAC)
> 18:10:29 Begin Action: Locked Connectivity Files Check
> 18:10:29 ConnectivityLocked returned: 0
> 18:10:29 The operation completed successfully.
>
> 18:10:29 End Action: Locked Connectivity Files Check
> 18:10:29 Setup is installing Microsoft Data Access Components (MDAC) ...
> 18:10:29 C:\sql2ksp3\x86\Other\sqlredis.exe /q:a /C:"setupre.exe MDACQFE=0
> WARN=1 -s -SMS"
> 18:32:00 ExitCode: 0
> 18:32:00 End: InstallPkgs(ID_INSTALLMDAC)
> 18:32:00 **** STARTING OPEN OP IN WRITE MODE ****
> 18:32:00 **** CLOSED OPEN OP IN WRITE MODE ****
> 18:32:00 Begin: MoveFileData()
> 18:32:00 Enabled SELFREGISTERBATCH
> 18:32:00 Enabled CORECOMPONENTHANDLING
> 18:32:02 Begin Action: MoveFileDataSpecial
> 18:32:02 End Action: MoveFileDataSpecial
> ...................................
>
> Any help is understanding the reason is highly appreicated. Thank you!



  #3  
Old 07-20-04, 07:14 PM
xsw
Re: sql server installation hung/slow
That worked.  Thanks!!!


"Sadeesh[MSFT]" wrote:

> Hi
>
> Please try the below mentioned suggestion and let us know the behavior.
> a.. Switch all services to Manual mode; however, do not touch the
> following services (if present):
>
> Alerter
> Cluster Service
> Computer Browser
> Event Log
> Kerberos Key Distribution Center (if servers are DCs)
> License Logging Service
> Messenger
> Net Logon
> NTLM Security Support Provider
> Network Connectors
> Plug and Play
> Remote Procedure Call (RPC) Locator
> Remote Procedure Call (RPC) Service
> Remote Registry Service
> Server
> Print Spooler
> TCP/IP NetBIOS Helper
> Time Service
> Workstation
>
> Note: Some installations may not have all these services, because this list
> covers both Windows NT 4.0 Enterprise Edition and Windows 2000 Advanced
> Server.
>
>
> Close Control Panel, and then restart the server. This clears the memory of
> DLLs loaded by services; otherwise, these services would remain in memory
> and hold locks on system resources.
>
> Try to Install SQL Server and let us know if there is any difference.
>
> HTH
> Regards
> Sadeesh
>
> --
> This posting is provided AS IS with no warranties, and confers no rights.
>
> "xsw" <xsw@discussions.microsoft.com> wrote in message
> news:679FAB8A-D47E-467A-B476-5B0B23C64062@microsoft.com...
>
>
>

  #4  
Old 07-20-04, 10:23 PM
Sadeesh[MSFT]
Re: sql server installation hung/slow
Good to hear that.

Thank you.

Regards
Sadeesh

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

"xsw" <xsw@discussions.microsoft.com> wrote in message
news:D3EE6708-1371-4987-9D89-DEA16B3C8D5F@microsoft.com...[vbcol=seagreen]
> That worked. Thanks!!!
>
>
> "Sadeesh[MSFT]" wrote:
>


  #5  
Old 07-30-04, 02:38 PM
jkbrake jkbrake is offline
Junior Member
Join Date: Jul 2004
Re: Re: sql server installation hung/slow
We had a similar problem doing a cluster install.  The interactive sql setup called the unattended installs on each of the two cluster nodes and would quit after a 30 minute timeout saying "Failed to perform operations on clustered nodes."  At one point, we determined the timeout was occuring because the installs were so slow and found your suggestion.  We turned off services and installed properly.  Later we tracked down the problem to a specific Dell Open Manage service called "Remote Access Control (RAC)".  This service also caused problems installing one other program.

Thanks,
James


Quote:
Originally posted by Sadeesh[MSFT]
Good to hear that.

Thank you.

Regards
Sadeesh

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

"xsw" <xsw@discussions.microsoft.com> wrote in message
news:D3EE6708-1371-4987-9D89-DEA16B3C8D5F@microsoft.com...[vbcol=seagreen]
> That worked. Thanks!!!
>
>
> "Sadeesh[MSFT]" wrote:
>
  #6  
Old 08-19-04, 12:09 AM
vdogg vdogg is offline
Junior Member
Join Date: Aug 2004
Re: Re: Re: sql server installation hung/slow
Quote:
Originally posted by jkbrake
We had a similar problem doing a cluster install. The interactive sql setup called the unattended installs on each of the two cluster nodes and would quit after a 30 minute timeout saying "Failed to perform operations on clustered nodes." At one point, we determined the timeout was occuring because the installs were so slow and found your suggestion. We turned off services and installed properly. Later we tracked down the problem to a specific Dell Open Manage service called "Remote Access Control (RAC)". This service also caused problems installing one other program.

Thanks,
James

Based on the lead above I stop two services:

RAC VNC Service
Remote Access Controller (RAC) Service

And that's all that is needed. We are on Dell 2650's. This works for both the SQL install and the SQL SP3 install.

BTW how did you guys figure out that it was the Dell RAC services?

Thanks,
V

Last edited by vdogg : 08-19-04 at 12:25 AM.
  #7  
Old 08-19-04, 09:33 AM
jkbrake jkbrake is offline
Junior Member
Join Date: Jul 2004
Re: Re: Re: Re: sql server installation hung/slow
Quote:
Originally posted by vdogg
Based on the lead above I stop two services:

RAC VNC Service
Remote Access Controller (RAC) Service

And that's all that is needed. We are on Dell 2650's. This works for both the SQL install and the SQL SP3 install.

BTW how did you guys figure out that it was the Dell RAC services?

Thanks,
V
Hi Vdogg,

We also have 2650's.

It turns out that when you stop one of those two services, the other stops.

We found it by process of trial and error. First we followed the instructions in the original solution. Of course, we got a successful install with approximately 20 services turned off.

Then, we began turning each service on one by one and tested the SQL server install starting with a couple disk related services. Then we decided to go after the 8 or so Dell Open Manage services which we believed were not needed for an operational system anyway. Luckily, it only took about 5 tries for us to find the Remote Access Controller (RAC) service was the culprit.

I'm glad this helped.

James
 


Popular forums
A+ (A Plus) Windows 2000 Active directory Exchange 2000 information store
Network+ Windows XP Security Exchange 2000 server administration
MCSE .NET Web services SQL Server
Cisco certification ASP .NET SQL 2000 Programming
Windows 2000 Registry .NET XML Viruses


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 04:28 AM.


Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Copyright MCSE braindumps 2003-2006