Wednesday, March 21, 2012
Problem opening SSMS Express
I experience a problem after installing "SQL Server 2005 Books On Line"
(December 2005) on my notebook, which have also an installation of SQL
Server 2005 Express Edition. Management Studio Express Edition (November
CTP) don't start...
If I try to open it, nothing happens. Anyone can help me?
Thanks
David
David wrote:
> Hi,
> I experience a problem after installing "SQL Server 2005 Books On Line"
> (December 2005) on my notebook, which have also an installation of SQL
> Server 2005 Express Edition. Management Studio Express Edition (November
> CTP) don't start...
> If I try to open it, nothing happens. Anyone can help me?
> Thanks
I find the solution:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57857
David
Wednesday, March 7, 2012
problem intstalling SQLEXPR.EXE
everytime i try installing SQLEXPR.EXE.. it will give mi a problem saying SQL server 2005 setup has detect incompatible components from beta verisons of VS, .net framework, or SQL server 2005.
i did uninstall all beta version.. n try again.. but still e same problem..
how can it be solve and whats e probem?
Take a look at the setup logs to get a more specific idea which component is causing the problem. There a number of components that got installed when you installed the Beta, you need to get rid of all of them.
Setup logs are located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOGS.
There are several threads on solving this error in the SQL Setup forum, so you should search that forum for the details.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
Problem installing SSQL Server 2000 client tools
I'm trying to re-install SQL Server 2000 Desktop Engine and
SQL Server client tools. I have succesfully re-installed the desktop engine,
but I am getting the following error message when attempting to re-install the
client tools.
"Setup has detected an existing client tools only installation.
Please use the maintenance mode to add client components"
Unfortunately the Upgrade/Add/Remove option is greyed out as
an install option.
I attempted the registry hive rebuild option and the install appeared
to succeed. However, I cannot access any tools (Enterprise Manager
comes up with the message "The selected file cannot be found").
At this point, the desktop engine appears in Add/Remove programs
Window, but no other SQL Server components.
Any help very much appreciated!
Eric Yeoman.
Eventually solved the problem by manually uninstalling SQL Server;
http://support.microsoft.com/kb/290991/#4
Problem installing SQL2K on WinXP Home
I am trying to install MS SQL 2000 Server on Windows XP Home edition.
I found in Microsoft that the above installation is possible.
But when i run the installation, i am getting a black screen that is
closes after a second. Nothing else happens.
Any ideas how to troubleshoot this?
Thank youLook for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.|||Originally posted by rnealejr
Look for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.
I searched for the file you are referring but with no success. I cannot find such a file anywhere on my disk.
Any other ideas?!
Thanks for the reply.
Problem installing sql2k Cluster on Win2k3 server
I cannot install SQL 2000 on a win2k3 cluster, I get the
error: Setup Failed to Perform Required Operations on the
Cluster Nodes.
Here is the SQLSTP.log file:
13:22:32 Begin Setup
13:22:32 8.00.194
13:22:32 Mode = Normal
13:22:32 ModeType = NORMAL
13:22:32 GetDefinitionEx returned: 0, Extended: 0x0
13:22:32 ValueFTS returned: 1
13:22:32 ValuePID returned: 1
13:22:32 ValueLic returned: 1
13:22:32 System: Windows NT Enterprise Server
13:22:32 SQL Server ProductType: Enterprise Edition [0x3]
13:22:32 IsNTCluster returned: 1
13:22:32 Begin Action: SetupInitialize
13:22:32 End Action SetupInitialize
13:22:32 Begin Action: SetupInstall
13:22:32 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ..
..
13:22:32 CommonFilesDir=C:\Program Files\Common Files
13:22:32 Windows Directory=C:\WINDOWS\
13:22:32 Program Files=C:\Program Files\
13:22:32 TEMPDIR=C:\WINDOWS\TEMP\
13:22:32 Begin Action: SetupInstall
13:22:32 digpid size : 256
13:22:32 digpid size : 164
13:22:32 Begin Action: CheckFixedRequirements
13:22:32 Platform ID: 0xf00000
13:22:32 Version: 5.2.3790
13:22:32 File Version - C:\WINDOWS\system32\shdocvw.dll:
6.0.3790.0
13:22:32 End Action: CheckFixedRequirements
13:22:32 Begin Action: ShowDialogs
13:22:32 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
13:22:32 Begin Action ShowDialogsHlpr: 0x1
13:22:32 Begin Action: DialogShowSdWelcome
13:22:33 End Action DialogShowSdWelcome
13:22:33 Dialog 0x1 returned: 1
13:22:33 End Action ShowDialogsHlpr
13:22:33 ShowDialogsGetDialog returned:
nCurrent=0x2,index=1
13:22:33 Begin Action ShowDialogsHlpr: 0x2
13:22:33 Begin Action: DialogShowSdMachineName
13:22:42 ShowDlgMachine returned: 1
13:22:42 Name = AVL, Type = 0x10000008
13:22:42 Begin Action: CheckRequirements
13:22:42 Processor Architecture: x86 (Pentium)
13:22:42 ComputerName: AVLNODO1
13:22:42 User Name: Administrator
13:22:42 IsAllAccessAllowed returned: 1
13:22:42 OS Language: 0x409
13:22:42 End Action CheckRequirements
13:22:42 This combination of Package and Operating System
allows a full product install.
13:22:42 End Action DialogShowSdMachineName
13:22:42 begin ShowDialogsUpdateMask
13:22:42 nFullMask = 0x183000f7, nCurrent = 0x2,
nDirection = 0
13:22:42 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
13:22:42 Dialog 0x2 returned: 0
13:22:42 End Action ShowDialogsHlpr
13:22:42 ShowDialogsGetDialog returned:
nCurrent=0x4,index=2
13:22:42 Begin Action ShowDialogsHlpr: 0x4
13:22:42 Begin Action: DialogShowSdInstallMode
13:22:42 InstallMode : 0x1
13:22:42 End Action DialogShowSdInstallMode
13:22:42 begin ShowDialogsUpdateMask
13:22:42 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection
= 1
13:22:42 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:42 Dialog 0x4 returned: 1
13:22:42 End Action ShowDialogsHlpr
13:22:42 ShowDialogsGetDialog returned:
nCurrent=0x10,index=4
13:22:42 Begin Action ShowDialogsHlpr: 0x10
13:22:42 Begin Action: DialogShowSdRegisterUserEx
13:22:43 End Action DialogShowSdRegisterUserEx
13:22:43 begin ShowDialogsUpdateMask
13:22:43 nFullMask = 0x1bf7c037, nCurrent = 0x10,
nDirection = 1
13:22:43 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:43 Dialog 0x10 returned: 1
13:22:43 End Action ShowDialogsHlpr
13:22:43 ShowDialogsGetDialog returned:
nCurrent=0x20,index=5
13:22:43 Begin Action ShowDialogsHlpr: 0x20
13:22:43 Begin Action: DialogShowSdLicense
13:22:45 End Action DialogShowSdLicense
13:22:45 Dialog 0x20 returned: 1
13:22:45 End Action ShowDialogsHlpr
13:22:45 ShowDialogsGetDialog returned:
nCurrent=0x4000,index=14
13:22:45 Begin Action ShowDialogsHlpr: 0x4000
13:22:45 Begin Action: DialogShowSdVirtualServer
13:22:58 ShowDlgVirtualServer returned: 0
13:22:58 Ipaddress = 192.168.0.80,255.255.255.0,Public
13:22:58 szNewList = 192.168.0.80,255.255.255.0,Public
13:22:58 szModifiedList =
13:22:58 szRemovedList =
13:22:58 End Action DialogShowSdVirtualServer
13:22:58 begin ShowDialogsUpdateMask
13:22:58 nFullMask = 0x1bf7c037, nCurrent = 0x4000,
nDirection = 1
13:22:58 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:58 Dialog 0x4000 returned: 1
13:22:58 End Action ShowDialogsHlpr
13:22:58 ShowDialogsGetDialog returned:
nCurrent=0x8000,index=15
13:22:58 Begin Action ShowDialogsHlpr: 0x8000
13:22:58 Begin Action : DialogShowSdDiskGroups
13:23:00 ShowDlgDiskGroups returned: 1
13:23:00 Disk Group = DATABASE
13:23:00 End Action : DialogShowSdDiskGroups
13:23:00 begin ShowDialogsUpdateMask
13:23:00 nFullMask = 0x1bf7c037, nCurrent = 0x8000,
nDirection = 1
13:23:00 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:00 Dialog 0x8000 returned: 1
13:23:00 End Action ShowDialogsHlpr
13:23:00 ShowDialogsGetDialog returned:
nCurrent=0x10000,index=16
13:23:00 Begin Action ShowDialogsHlpr: 0x10000
13:23:00 Begin Action: DialogShowSdClusterDef
13:23:05 ShowDlgClusterDef returned: 1
13:23:05 PrefOwners = AVLNODO1,AVLNODO2, NumIp = 2
13:23:05 Begin Action : ValidateNodeActions
13:23:05 Begin Action : ValidateNodeActions
13:23:05 End Action : ValidateNodeActions
13:23:05 End Action : ValidateNodeActions
13:23:05 End Action DialogShowSdClusterDef
13:23:05 begin ShowDialogsUpdateMask
13:23:05 nFullMask = 0x1bf7c037, nCurrent = 0x10000,
nDirection = 1
13:23:05 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:05 Dialog 0x10000 returned: 1
13:23:05 End Action ShowDialogsHlpr
13:23:05 ShowDialogsGetDialog returned:
nCurrent=0x20000,index=17
13:23:05 Begin Action ShowDialogsHlpr: 0x20000
13:23:05 Begin Action : Cluster Security - DlgAcct
13:23:14 ShowDlgAcct returned: 1
13:23:14 [DlgAccount]
13:23:14 Domain = AVL-CWP
13:23:14 DomainAcct = Administrator
13:23:14 DomainPwd
13:23:14 Result = 1
13:23:14 End Action : Cluster Security - DlgAcct
13:23:14 begin ShowDialogsUpdateMask
13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x20000,
nDirection = 1
13:23:14 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:14 Dialog 0x20000 returned: 1
13:23:14 End Action ShowDialogsHlpr
13:23:14 ShowDialogsGetDialog returned:
nCurrent=0x40000,index=18
13:23:14 Begin Action ShowDialogsHlpr: 0x40000
13:23:14 Begin Action: DialogShowSdCliSvr
13:23:14 DisplaySystemPreReq
13:23:14 ShowDlgClientServerSelect returned: 1
13:23:14 Type : 0x2
13:23:14 End Action DialogShowSdCliSvr
13:23:14 begin ShowDialogsUpdateMask
13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x40000,
nDirection = 1
13:23:14 Updated Dialog Mask: 0x1bffc037, Disable Back =
0x1
13:23:14 Dialog 0x40000 returned: 1
13:23:14 End Action ShowDialogsHlpr
13:23:14 ShowDialogsGetDialog returned:
nCurrent=0x80000,index=19
13:23:14 Begin Action ShowDialogsHlpr: 0x80000
13:23:14 Begin Action: DialogShowSdInstanceName
13:23:14 Begin Action: ShowDlgInstanceName
13:23:15 End Action: ShowDlgInstanceName
13:23:15 ShowDlgInstanceName returned : 1
13:23:15 InstanceName : MSSQLSERVER
13:23:20 CreateSetupTopology(AVL), Handle : 0x1194098,
returned : 0
13:23:20 CreateSetupTopology returned : 0, Handle :
0x1194098
13:23:20 Topology Type : 34, Return Value : 0
13:23:20 ST_GetPhysicalNode returned : 0, PNHandle :
0x11940e8
13:23:20 PN_EnumerateEx returned : 0
13:23:20 PN_GetSQLStates returned : 0, SqlStates : 0x0
13:23:20 PN_StartScan [0x11940e8] returned : 0
13:23:20 PN_GetNext [0x11940e8] returned : 18, Handle:
[0x0]
13:23:20 No more items in enumeration.
13:23:20 ReleaseSetupTopology
13:23:20 End Action DialogShowSdInstanceName
13:23:20 begin ShowDialogsUpdateMask
13:23:20 nFullMask = 0x1bffc037, nCurrent = 0x80000,
nDirection = 1
13:23:20 Updated Dialog Mask: 0x1bffc037, Disable Back =
0x1
13:23:20 Dialog 0x80000 returned: 1
13:23:20 End Action ShowDialogsHlpr
13:23:20 ShowDialogsGetDialog returned:
nCurrent=0x100000,index=20
13:23:20 Begin Action ShowDialogsHlpr: 0x100000
13:23:20 Begin Action: DialogShowSdSetupType
13:23:20 Begin Action: Setup Type
13:23:24 SQL program folder: C:\Program Files\Microsoft
SQL Server
13:23:24 SQL data folder: D:\Program Files\Microsoft SQL
Server
13:23:24 Windows system folder: C:\WINDOWS\system32\
13:23:24 Prog req: 38205, Data req: 34432, Sys req: 183105
13:23:24 Prog avail: 32618500, Data avail: 137948088, Sys
avail: 32618500
13:23:24 Prog req vs. avail, 221310, 32618500
13:23:24 Data req vs. avail, 34432, 137948088
13:23:24 Sys req vs. avail, 183105, 32618500
13:23:24 DisplaySystemPreReq
13:23:24 [SetupTypeSQL]
13:23:24 szDir = C:\Program Files\Microsoft SQL Server
13:23:24 szDir = C:\Program Files\Microsoft SQL Server
13:23:24 Result = 301
13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
13:23:24 End Action: Setup Type
13:23:24 Setup Type: Typical (301)
13:23:24 End Action DialogShowSdSetupType
13:23:24 begin ShowDialogsUpdateMask
13:23:24 nFullMask = 0x1bffc037, nCurrent = 0x100000,
nDirection = 301
13:23:24 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:24 Dialog 0x100000 returned: 301
13:23:24 End Action ShowDialogsHlpr
13:23:24 ShowDialogsGetDialog returned:
nCurrent=0x400000,index=22
13:23:24 Begin Action ShowDialogsHlpr: 0x400000
13:23:24 Begin Action: DlgServices
13:23:34 ShowDlgServices returned: 1
13:23:34 [DlgServices]
13:23:34 Local-Domain= 61680
13:23:34 AutoStart= 0
13:23:34 SQLDomain= AVL-CWP
13:23:34 SQLDomainAcct= _sqlmanager
13:23:34 SQLDomainPwd
13:23:34 AgtDomain= AVL-CWP
13:23:34 AgtDomainAcct= _sqlmanager
13:23:34 AgtDomainPwd
13:23:34 Result= 1
13:23:34 End Action DlgServices
13:23:34 begin ShowDialogsUpdateMask
13:23:34 nFullMask = 0x1bdfc037, nCurrent = 0x400000,
nDirection = 1
13:23:34 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:34 Dialog 0x400000 returned: 1
13:23:34 End Action ShowDialogsHlpr
13:23:34 ShowDialogsGetDialog returned:
nCurrent=0x800000,index=23
13:23:34 Begin Action ShowDialogsHlpr: 0x800000
13:23:34 Begin Action: DlgSQLSecurity
13:23:35 ShowDlgSQLSecurity returned: 1
13:23:35 LoginMode = 1,szPwd
13:23:35 End Action DlgSQLSecurity
13:23:35 begin ShowDialogsUpdateMask
13:23:35 nFullMask = 0x1bdfc037, nCurrent = 0x800000,
nDirection = 1
13:23:35 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:35 Dialog 0x800000 returned: 1
13:23:35 End Action ShowDialogsHlpr
13:23:35 ShowDialogsGetDialog returned:
nCurrent=0x1000000,index=24
13:23:35 Begin Action ShowDialogsHlpr: 0x1000000
13:23:35 Begin Action: DlgCollation
13:23:40 ShowDlgCollation returned: 1
13:23:40 collation_name =
SQL_Latin1_General_CP1_CI_AS,locale_name =
Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags =
0x30001
13:23:40 End Action DlgCollation
13:23:40 begin ShowDialogsUpdateMask
13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x1000000,
nDirection = 1
13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:40 Dialog 0x1000000 returned: 1
13:23:40 End Action ShowDialogsHlpr
13:23:40 ShowDialogsGetDialog returned:
nCurrent=0x2000000,index=25
13:23:40 Begin Action ShowDialogsHlpr: 0x2000000
13:23:40 Begin Action: DlgNetwork
13:23:40 ShowDlgNetwork returned: 1
13:23:40 [DlgServerNetwork]
13:23:40 NetworkLibs = 255
13:23:40 TCPPort = 1433
13:23:40 TCPPrxy = Default
13:23:40 NMPPipeName = \\.\pipe\sql\query
13:23:40 Result = 1
13:23:40 End Action DlgNetwork
13:23:40 begin ShowDialogsUpdateMask
13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x2000000,
nDirection = 1
13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:40 Dialog 0x2000000 returned: 1
13:23:40 End Action ShowDialogsHlpr
13:23:40 ShowDialogsGetDialog returned:
nCurrent=0x8000000,index=27
13:23:40 Begin Action ShowDialogsHlpr: 0x8000000
13:23:40 Begin Action: DialogShowSdStartCopy
13:23:41 End Action DialogShowSdStartCopy
13:23:41 begin ShowDialogsUpdateMask
13:23:41 nFullMask = 0x1bdfc037, nCurrent = 0x8000000,
nDirection = 1
13:23:41 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:41 Dialog 0x8000000 returned: 1
13:23:41 End Action ShowDialogsHlpr
13:23:41 ShowDialogsGetDialog returned:
nCurrent=0x10000000,index=28
13:23:41 Begin Action ShowDialogsHlpr: 0x10000000
13:23:41 Begin Action: DialogShowSdLicenseMode
13:23:45 ShowDlgLicense returned: 1
13:23:45 ShowDlgLicense returned: LicenseMode = 0,
LicenseLimit = 2
13:23:45 End Action DialogShowSdLicenseMode
13:23:45 Dialog 0x10000000 returned: 1
13:23:45 End Action ShowDialogsHlpr
13:23:45 ShowDialogsGetDialog returned:
nCurrent=0x0,index=0
13:23:45 End Action ShowDialogs
13:23:45 Setup is installing Microsoft Distributed
Transaction Coordinator (MSDTC) ...
13:23:45 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -
SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "E:\x86
\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log" -
CtxAcct "AVL-CWP\Administrator" -CtxEPwd
13:23:47 Process Exit Code: (0)
13:23:47 Begin Action : ClusterSetupHelper
13:23:47 Begin Action : CreateClustISSFiles
13:23:47 End Action : CreateClustISSFiles
13:23:47 Begin Action : ClusterWriteRemIni
13:23:47 End Action : ClusterWriteRemIni
13:23:47 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=2
Server.1=AVLNODO1
Server.2=AVLNODO2
[Server.1]
NumRemoteServices=1
1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
1.server=AVLNODO1
1.script=\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.is s
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\AVLNODO1
\E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO1
\admin$\setup.log" -e "stpsilnt._ex" -b -
x "C:\WINDOWS\TEMP\"
1.user=AVL-CWP\Administrator
1.password=095c53b158d550021ef0
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
1.server=AVLNODO2
1.script=\\AVLNODO1\admin$\AVLNODO2_MSSQLSERVER.is s
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\AVLNODO1
\E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO2
\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=AVL-CWP\Administrator
1.password=095c53b158d550021ef0
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
13:23:48 Setup is performing required operations on
cluster nodes. This may take a few minutes...
13:23:48 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
C:\WINDOWS\remsetup.ini
13:25:06 Process Exit Code: (2) The system cannot find the
file specified.
13:25:06 Begin Action : GetRemsetupRetCode
13:25:06 Installation return status on AVLNODO1 : 2
13:25:06 Installation return status on AVLNODO2 : 2
13:25:06 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 09/24/04
13:23:48 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x64] created for execution.
CThread::Process [0x64]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=Nb k=Rm
k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.iss -f2 "\\AVLNODO1
\admin$\setup.log" -e "stpsilnt._ex" -b -
x "C:\WINDOWS\TEMP\"' (AVLNODO1) ...
CThread::Run thread [0x68] created for execution.
CThread::Process [0x68]
CThreadPool::RunUntilCompleteHlpr start thread
[0x64],index=0
CThreadPool::RunUntilCompleteHlpr start thread
[0x68],index=1
Script file copied to '\\AVLNODO2
\ADMIN$\AVLNODO2_MSSQLSERVER.iss' successfully.
Installing remote service (AVLNODO2)...
Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=ClSec k=Rm
k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
\\AVLNODO2\ADMIN$\AVLNODO2_MSSQLSERVER.iss -f2 "\\AVLNODO2
\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"'
(AVLNODO2) ...
CProcess::RunUntilComplete [0x64] exit code: 2
Remote process exit code was '2' (AVLNODO1).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x64]
Thread [0x64] exit code: [0x2]
CRemoteProcess::RunUntilComplete [0x68] exit code: 2
Remote process exit code was '2' (AVLNODO2).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
returned: 2
CThreadPool::RunUntilCompleteHlpr signaled thread [0x68]
Thread [0x68] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need
execution: 0
One or more errors occurred while running the
remote/unattended setups.
Disconnecting from remote machine (AVLNODO1)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 09/24/04 13:24:49
####
Disconnecting from remote machine (AVLNODO2)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 09/24/04 13:25:06
####
13:25:06 End Action : Run setup on cluster nodes
13:25:06 One or more errors occurred while running remote
setup on the clustered machines.
13:28:20 Setup failed to perform required operations on
the cluster nodes.
13:28:20 Begin Action : ClusterErrorCleanup
13:28:20 End Action : ClusterErrorCleanup
13:28:20 End Action : ClusterSetupHelper
Any idea?
check KB815431 and 321063 to see if that helps.
Jeff
"Edd" <anonymous@.discussions.microsoft.com> wrote in message
news:0be701c4a265$3815dcd0$a501280a@.phx.gbl...
> Hi:
> I cannot install SQL 2000 on a win2k3 cluster, I get the
> error: Setup Failed to Perform Required Operations on the
> Cluster Nodes.
> Here is the SQLSTP.log file:
> 13:22:32 Begin Setup
> 13:22:32 8.00.194
> 13:22:32 Mode = Normal
> 13:22:32 ModeType = NORMAL
> 13:22:32 GetDefinitionEx returned: 0, Extended: 0x0
> 13:22:32 ValueFTS returned: 1
> 13:22:32 ValuePID returned: 1
> 13:22:32 ValueLic returned: 1
> 13:22:32 System: Windows NT Enterprise Server
> 13:22:32 SQL Server ProductType: Enterprise Edition [0x3]
> 13:22:32 IsNTCluster returned: 1
> 13:22:32 Begin Action: SetupInitialize
> 13:22:32 End Action SetupInitialize
> 13:22:32 Begin Action: SetupInstall
> 13:22:32 Reading
> Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ..
> .
> 13:22:32 CommonFilesDir=C:\Program Files\Common Files
> 13:22:32 Windows Directory=C:\WINDOWS\
> 13:22:32 Program Files=C:\Program Files\
> 13:22:32 TEMPDIR=C:\WINDOWS\TEMP\
> 13:22:32 Begin Action: SetupInstall
> 13:22:32 digpid size : 256
> 13:22:32 digpid size : 164
> 13:22:32 Begin Action: CheckFixedRequirements
> 13:22:32 Platform ID: 0xf00000
> 13:22:32 Version: 5.2.3790
> 13:22:32 File Version - C:\WINDOWS\system32\shdocvw.dll:
> 6.0.3790.0
> 13:22:32 End Action: CheckFixedRequirements
> 13:22:32 Begin Action: ShowDialogs
> 13:22:32 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 13:22:32 Begin Action ShowDialogsHlpr: 0x1
> 13:22:32 Begin Action: DialogShowSdWelcome
> 13:22:33 End Action DialogShowSdWelcome
> 13:22:33 Dialog 0x1 returned: 1
> 13:22:33 End Action ShowDialogsHlpr
> 13:22:33 ShowDialogsGetDialog returned:
> nCurrent=0x2,index=1
> 13:22:33 Begin Action ShowDialogsHlpr: 0x2
> 13:22:33 Begin Action: DialogShowSdMachineName
> 13:22:42 ShowDlgMachine returned: 1
> 13:22:42 Name = AVL, Type = 0x10000008
> 13:22:42 Begin Action: CheckRequirements
> 13:22:42 Processor Architecture: x86 (Pentium)
> 13:22:42 ComputerName: AVLNODO1
> 13:22:42 User Name: Administrator
> 13:22:42 IsAllAccessAllowed returned: 1
> 13:22:42 OS Language: 0x409
> 13:22:42 End Action CheckRequirements
> 13:22:42 This combination of Package and Operating System
> allows a full product install.
> 13:22:42 End Action DialogShowSdMachineName
> 13:22:42 begin ShowDialogsUpdateMask
> 13:22:42 nFullMask = 0x183000f7, nCurrent = 0x2,
> nDirection = 0
> 13:22:42 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
> 13:22:42 Dialog 0x2 returned: 0
> 13:22:42 End Action ShowDialogsHlpr
> 13:22:42 ShowDialogsGetDialog returned:
> nCurrent=0x4,index=2
> 13:22:42 Begin Action ShowDialogsHlpr: 0x4
> 13:22:42 Begin Action: DialogShowSdInstallMode
> 13:22:42 InstallMode : 0x1
> 13:22:42 End Action DialogShowSdInstallMode
> 13:22:42 begin ShowDialogsUpdateMask
> 13:22:42 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection
> = 1
> 13:22:42 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:42 Dialog 0x4 returned: 1
> 13:22:42 End Action ShowDialogsHlpr
> 13:22:42 ShowDialogsGetDialog returned:
> nCurrent=0x10,index=4
> 13:22:42 Begin Action ShowDialogsHlpr: 0x10
> 13:22:42 Begin Action: DialogShowSdRegisterUserEx
> 13:22:43 End Action DialogShowSdRegisterUserEx
> 13:22:43 begin ShowDialogsUpdateMask
> 13:22:43 nFullMask = 0x1bf7c037, nCurrent = 0x10,
> nDirection = 1
> 13:22:43 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:43 Dialog 0x10 returned: 1
> 13:22:43 End Action ShowDialogsHlpr
> 13:22:43 ShowDialogsGetDialog returned:
> nCurrent=0x20,index=5
> 13:22:43 Begin Action ShowDialogsHlpr: 0x20
> 13:22:43 Begin Action: DialogShowSdLicense
> 13:22:45 End Action DialogShowSdLicense
> 13:22:45 Dialog 0x20 returned: 1
> 13:22:45 End Action ShowDialogsHlpr
> 13:22:45 ShowDialogsGetDialog returned:
> nCurrent=0x4000,index=14
> 13:22:45 Begin Action ShowDialogsHlpr: 0x4000
> 13:22:45 Begin Action: DialogShowSdVirtualServer
> 13:22:58 ShowDlgVirtualServer returned: 0
> 13:22:58 Ipaddress = 192.168.0.80,255.255.255.0,Public
> 13:22:58 szNewList = 192.168.0.80,255.255.255.0,Public
> 13:22:58 szModifiedList =
> 13:22:58 szRemovedList =
> 13:22:58 End Action DialogShowSdVirtualServer
> 13:22:58 begin ShowDialogsUpdateMask
> 13:22:58 nFullMask = 0x1bf7c037, nCurrent = 0x4000,
> nDirection = 1
> 13:22:58 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:58 Dialog 0x4000 returned: 1
> 13:22:58 End Action ShowDialogsHlpr
> 13:22:58 ShowDialogsGetDialog returned:
> nCurrent=0x8000,index=15
> 13:22:58 Begin Action ShowDialogsHlpr: 0x8000
> 13:22:58 Begin Action : DialogShowSdDiskGroups
> 13:23:00 ShowDlgDiskGroups returned: 1
> 13:23:00 Disk Group = DATABASE
> 13:23:00 End Action : DialogShowSdDiskGroups
> 13:23:00 begin ShowDialogsUpdateMask
> 13:23:00 nFullMask = 0x1bf7c037, nCurrent = 0x8000,
> nDirection = 1
> 13:23:00 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:00 Dialog 0x8000 returned: 1
> 13:23:00 End Action ShowDialogsHlpr
> 13:23:00 ShowDialogsGetDialog returned:
> nCurrent=0x10000,index=16
> 13:23:00 Begin Action ShowDialogsHlpr: 0x10000
> 13:23:00 Begin Action: DialogShowSdClusterDef
> 13:23:05 ShowDlgClusterDef returned: 1
> 13:23:05 PrefOwners = AVLNODO1,AVLNODO2, NumIp = 2
> 13:23:05 Begin Action : ValidateNodeActions
> 13:23:05 Begin Action : ValidateNodeActions
> 13:23:05 End Action : ValidateNodeActions
> 13:23:05 End Action : ValidateNodeActions
> 13:23:05 End Action DialogShowSdClusterDef
> 13:23:05 begin ShowDialogsUpdateMask
> 13:23:05 nFullMask = 0x1bf7c037, nCurrent = 0x10000,
> nDirection = 1
> 13:23:05 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:05 Dialog 0x10000 returned: 1
> 13:23:05 End Action ShowDialogsHlpr
> 13:23:05 ShowDialogsGetDialog returned:
> nCurrent=0x20000,index=17
> 13:23:05 Begin Action ShowDialogsHlpr: 0x20000
> 13:23:05 Begin Action : Cluster Security - DlgAcct
> 13:23:14 ShowDlgAcct returned: 1
> 13:23:14 [DlgAccount]
> 13:23:14 Domain = AVL-CWP
> 13:23:14 DomainAcct = Administrator
> 13:23:14 DomainPwd
> 13:23:14 Result = 1
> 13:23:14 End Action : Cluster Security - DlgAcct
> 13:23:14 begin ShowDialogsUpdateMask
> 13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x20000,
> nDirection = 1
> 13:23:14 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:14 Dialog 0x20000 returned: 1
> 13:23:14 End Action ShowDialogsHlpr
> 13:23:14 ShowDialogsGetDialog returned:
> nCurrent=0x40000,index=18
> 13:23:14 Begin Action ShowDialogsHlpr: 0x40000
> 13:23:14 Begin Action: DialogShowSdCliSvr
> 13:23:14 DisplaySystemPreReq
> 13:23:14 ShowDlgClientServerSelect returned: 1
> 13:23:14 Type : 0x2
> 13:23:14 End Action DialogShowSdCliSvr
> 13:23:14 begin ShowDialogsUpdateMask
> 13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x40000,
> nDirection = 1
> 13:23:14 Updated Dialog Mask: 0x1bffc037, Disable Back =
> 0x1
> 13:23:14 Dialog 0x40000 returned: 1
> 13:23:14 End Action ShowDialogsHlpr
> 13:23:14 ShowDialogsGetDialog returned:
> nCurrent=0x80000,index=19
> 13:23:14 Begin Action ShowDialogsHlpr: 0x80000
> 13:23:14 Begin Action: DialogShowSdInstanceName
> 13:23:14 Begin Action: ShowDlgInstanceName
> 13:23:15 End Action: ShowDlgInstanceName
> 13:23:15 ShowDlgInstanceName returned : 1
> 13:23:15 InstanceName : MSSQLSERVER
> 13:23:20 CreateSetupTopology(AVL), Handle : 0x1194098,
> returned : 0
> 13:23:20 CreateSetupTopology returned : 0, Handle :
> 0x1194098
> 13:23:20 Topology Type : 34, Return Value : 0
> 13:23:20 ST_GetPhysicalNode returned : 0, PNHandle :
> 0x11940e8
> 13:23:20 PN_EnumerateEx returned : 0
> 13:23:20 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 13:23:20 PN_StartScan [0x11940e8] returned : 0
> 13:23:20 PN_GetNext [0x11940e8] returned : 18, Handle:
> [0x0]
> 13:23:20 No more items in enumeration.
> 13:23:20 ReleaseSetupTopology
> 13:23:20 End Action DialogShowSdInstanceName
> 13:23:20 begin ShowDialogsUpdateMask
> 13:23:20 nFullMask = 0x1bffc037, nCurrent = 0x80000,
> nDirection = 1
> 13:23:20 Updated Dialog Mask: 0x1bffc037, Disable Back =
> 0x1
> 13:23:20 Dialog 0x80000 returned: 1
> 13:23:20 End Action ShowDialogsHlpr
> 13:23:20 ShowDialogsGetDialog returned:
> nCurrent=0x100000,index=20
> 13:23:20 Begin Action ShowDialogsHlpr: 0x100000
> 13:23:20 Begin Action: DialogShowSdSetupType
> 13:23:20 Begin Action: Setup Type
> 13:23:24 SQL program folder: C:\Program Files\Microsoft
> SQL Server
> 13:23:24 SQL data folder: D:\Program Files\Microsoft SQL
> Server
> 13:23:24 Windows system folder: C:\WINDOWS\system32\
> 13:23:24 Prog req: 38205, Data req: 34432, Sys req: 183105
> 13:23:24 Prog avail: 32618500, Data avail: 137948088, Sys
> avail: 32618500
> 13:23:24 Prog req vs. avail, 221310, 32618500
> 13:23:24 Data req vs. avail, 34432, 137948088
> 13:23:24 Sys req vs. avail, 183105, 32618500
> 13:23:24 DisplaySystemPreReq
> 13:23:24 [SetupTypeSQL]
> 13:23:24 szDir = C:\Program Files\Microsoft SQL Server
> 13:23:24 szDir = C:\Program Files\Microsoft SQL Server
> 13:23:24 Result = 301
> 13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
> 13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
> 13:23:24 End Action: Setup Type
> 13:23:24 Setup Type: Typical (301)
> 13:23:24 End Action DialogShowSdSetupType
> 13:23:24 begin ShowDialogsUpdateMask
> 13:23:24 nFullMask = 0x1bffc037, nCurrent = 0x100000,
> nDirection = 301
> 13:23:24 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:24 Dialog 0x100000 returned: 301
> 13:23:24 End Action ShowDialogsHlpr
> 13:23:24 ShowDialogsGetDialog returned:
> nCurrent=0x400000,index=22
> 13:23:24 Begin Action ShowDialogsHlpr: 0x400000
> 13:23:24 Begin Action: DlgServices
> 13:23:34 ShowDlgServices returned: 1
> 13:23:34 [DlgServices]
> 13:23:34 Local-Domain = 61680
> 13:23:34 AutoStart = 0
> 13:23:34 SQLDomain = AVL-CWP
> 13:23:34 SQLDomainAcct = _sqlmanager
> 13:23:34 SQLDomainPwd
> 13:23:34 AgtDomain = AVL-CWP
> 13:23:34 AgtDomainAcct = _sqlmanager
> 13:23:34 AgtDomainPwd
> 13:23:34 Result = 1
> 13:23:34 End Action DlgServices
> 13:23:34 begin ShowDialogsUpdateMask
> 13:23:34 nFullMask = 0x1bdfc037, nCurrent = 0x400000,
> nDirection = 1
> 13:23:34 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:34 Dialog 0x400000 returned: 1
> 13:23:34 End Action ShowDialogsHlpr
> 13:23:34 ShowDialogsGetDialog returned:
> nCurrent=0x800000,index=23
> 13:23:34 Begin Action ShowDialogsHlpr: 0x800000
> 13:23:34 Begin Action: DlgSQLSecurity
> 13:23:35 ShowDlgSQLSecurity returned: 1
> 13:23:35 LoginMode = 1,szPwd
> 13:23:35 End Action DlgSQLSecurity
> 13:23:35 begin ShowDialogsUpdateMask
> 13:23:35 nFullMask = 0x1bdfc037, nCurrent = 0x800000,
> nDirection = 1
> 13:23:35 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:35 Dialog 0x800000 returned: 1
> 13:23:35 End Action ShowDialogsHlpr
> 13:23:35 ShowDialogsGetDialog returned:
> nCurrent=0x1000000,index=24
> 13:23:35 Begin Action ShowDialogsHlpr: 0x1000000
> 13:23:35 Begin Action: DlgCollation
> 13:23:40 ShowDlgCollation returned: 1
> 13:23:40 collation_name =
> SQL_Latin1_General_CP1_CI_AS,locale_name =
> Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags =
> 0x30001
> 13:23:40 End Action DlgCollation
> 13:23:40 begin ShowDialogsUpdateMask
> 13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x1000000,
> nDirection = 1
> 13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:40 Dialog 0x1000000 returned: 1
> 13:23:40 End Action ShowDialogsHlpr
> 13:23:40 ShowDialogsGetDialog returned:
> nCurrent=0x2000000,index=25
> 13:23:40 Begin Action ShowDialogsHlpr: 0x2000000
> 13:23:40 Begin Action: DlgNetwork
> 13:23:40 ShowDlgNetwork returned: 1
> 13:23:40 [DlgServerNetwork]
> 13:23:40 NetworkLibs = 255
> 13:23:40 TCPPort = 1433
> 13:23:40 TCPPrxy = Default
> 13:23:40 NMPPipeName = \\.\pipe\sql\query
> 13:23:40 Result = 1
> 13:23:40 End Action DlgNetwork
> 13:23:40 begin ShowDialogsUpdateMask
> 13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x2000000,
> nDirection = 1
> 13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:40 Dialog 0x2000000 returned: 1
> 13:23:40 End Action ShowDialogsHlpr
> 13:23:40 ShowDialogsGetDialog returned:
> nCurrent=0x8000000,index=27
> 13:23:40 Begin Action ShowDialogsHlpr: 0x8000000
> 13:23:40 Begin Action: DialogShowSdStartCopy
> 13:23:41 End Action DialogShowSdStartCopy
> 13:23:41 begin ShowDialogsUpdateMask
> 13:23:41 nFullMask = 0x1bdfc037, nCurrent = 0x8000000,
> nDirection = 1
> 13:23:41 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:41 Dialog 0x8000000 returned: 1
> 13:23:41 End Action ShowDialogsHlpr
> 13:23:41 ShowDialogsGetDialog returned:
> nCurrent=0x10000000,index=28
> 13:23:41 Begin Action ShowDialogsHlpr: 0x10000000
> 13:23:41 Begin Action: DialogShowSdLicenseMode
> 13:23:45 ShowDlgLicense returned: 1
> 13:23:45 ShowDlgLicense returned: LicenseMode = 0,
> LicenseLimit = 2
> 13:23:45 End Action DialogShowSdLicenseMode
> 13:23:45 Dialog 0x10000000 returned: 1
> 13:23:45 End Action ShowDialogsHlpr
> 13:23:45 ShowDialogsGetDialog returned:
> nCurrent=0x0,index=0
> 13:23:45 End Action ShowDialogs
> 13:23:45 Setup is installing Microsoft Distributed
> Transaction Coordinator (MSDTC) ...
> 13:23:45 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -
> SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "E:\x86
> \Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log" -
> CtxAcct "AVL-CWP\Administrator" -CtxEPwd
> 13:23:47 Process Exit Code: (0)
> 13:23:47 Begin Action : ClusterSetupHelper
> 13:23:47 Begin Action : CreateClustISSFiles
> 13:23:47 End Action : CreateClustISSFiles
> 13:23:47 Begin Action : ClusterWriteRemIni
> 13:23:47 End Action : ClusterWriteRemIni
> 13:23:47 Begin Action : Run setup on cluster nodes
> [args]
> NumRemoteServers=2
> Server.1=AVLNODO1
> Server.2=AVLNODO2
> [Server.1]
> NumRemoteServices=1
> 1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
> 1.server=AVLNODO1
> 1.script=\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.is s
> 1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\AVLNODO1
> \E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO1
> \admin$\setup.log" -e "stpsilnt._ex" -b -
> x "C:\WINDOWS\TEMP\"
> 1.user=AVL-CWP\Administrator
> 1.password=095c53b158d550021ef0
> 1.name=SQLSetup1
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc1.exe
> [Server.2]
> NumRemoteServices=1
> 1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
> 1.server=AVLNODO2
> 1.script=\\AVLNODO1\admin$\AVLNODO2_MSSQLSERVER.is s
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\AVLNODO1
> \E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO2
> \admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=AVL-CWP\Administrator
> 1.password=095c53b158d550021ef0
> 1.name=SQLSetup2
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc2.exe
> 13:23:48 Setup is performing required operations on
> cluster nodes. This may take a few minutes...
> 13:23:48 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
> C:\WINDOWS\remsetup.ini
> 13:25:06 Process Exit Code: (2) The system cannot find the
> file specified.
> 13:25:06 Begin Action : GetRemsetupRetCode
> 13:25:06 Installation return status on AVLNODO1 : 2
> 13:25:06 Installation return status on AVLNODO2 : 2
> 13:25:06 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 09/24/04
> 13:23:48 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x64] created for execution.
> CThread::Process [0x64]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=Nb k=Rm
> k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
> \\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.iss -f2 "\\AVLNODO1
> \admin$\setup.log" -e "stpsilnt._ex" -b -
> x "C:\WINDOWS\TEMP\"' (AVLNODO1) ...
> CThread::Run thread [0x68] created for execution.
> CThread::Process [0x68]
> CThreadPool::RunUntilCompleteHlpr start thread
> [0x64],index=0
> CThreadPool::RunUntilCompleteHlpr start thread
> [0x68],index=1
> Script file copied to '\\AVLNODO2
> \ADMIN$\AVLNODO2_MSSQLSERVER.iss' successfully.
> Installing remote service (AVLNODO2)...
> Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=ClSec k=Rm
> k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
> \\AVLNODO2\ADMIN$\AVLNODO2_MSSQLSERVER.iss -f2 "\\AVLNODO2
> \admin$\setup.log" -e "stpsilnt._ex" -x "C:\"'
> (AVLNODO2) ...
> CProcess::RunUntilComplete [0x64] exit code: 2
> Remote process exit code was '2' (AVLNODO1).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
> returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x64]
> Thread [0x64] exit code: [0x2]
> CRemoteProcess::RunUntilComplete [0x68] exit code: 2
> Remote process exit code was '2' (AVLNODO2).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
> returned: 2
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x68]
> Thread [0x68] exit code: [0x2]
> CThreadPool::RunUntilComplete returned 2
> CThreadPool::RunUntilComplete execution level=1, need
> execution: 0
> One or more errors occurred while running the
> remote/unattended setups.
> Disconnecting from remote machine (AVLNODO1)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 09/24/04 13:24:49
> ####
> Disconnecting from remote machine (AVLNODO2)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 09/24/04 13:25:06
> ####
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 13:25:06 End Action : Run setup on cluster nodes
> 13:25:06 One or more errors occurred while running remote
> setup on the clustered machines.
> 13:28:20 Setup failed to perform required operations on
> the cluster nodes.
> 13:28:20 Begin Action : ClusterErrorCleanup
> 13:28:20 End Action : ClusterErrorCleanup
> 13:28:20 End Action : ClusterSetupHelper
>
> Any idea?
>
|||From the sqlstp.log it is clear that the unattended installation on both the nodes failed with return code 2
> 13:25:06 Installation return status on AVLNODO1 : 2
> 13:25:06 Installation return status on AVLNODO2 : 2
Error code 2 ==> "The system cannot find the file specified."
Next step will be to go the AVLNODO1 and AVLNODO1 and review the sqlstpN.log where N is an integer.
Cut and paste the sqlstpN.log if you need more help.
Additional Information:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
problem installing Sql Server SP4
I am getting the following error message when installing sp4 on a 2nd
instance of sql server 2k on a win2003 server
"Specified file cannot be opened as write. Ensure file is not is use and
restart setup
C:\Program Files\Sql Server\80\Shared\msxmlsql.dll"
I rebooted the server and still get the same error message. When I click OK
on the error message sp4 setup shuts down. Any suggestions appreciated what
I can do to get around this problem.
Thanks,
RichI fixed the problem. Turns out that I had a 2nd instance (a new instance of
sql server running). I had to shut down the first instance. THat was what
was using the file below. I was then able to lnstall sp4.
"Rich" wrote:
> Hello,
> I am getting the following error message when installing sp4 on a 2nd
> instance of sql server 2k on a win2003 server
> "Specified file cannot be opened as write. Ensure file is not is use and
> restart setup
> C:\Program Files\Sql Server\80\Shared\msxmlsql.dll"
> I rebooted the server and still get the same error message. When I click
OK
> on the error message sp4 setup shuts down. Any suggestions appreciated wh
at
> I can do to get around this problem.
> Thanks,
> Rich
Problem installing SQL Server Reporting Services
Reporting Services for serveral hours. My environment is as follows:
XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
(Enterprise).
I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
The problem is that when I try to install the RS I only get the option
to install the Client Components (not very helpful for developing
reports locally)
While this looks like a great tool I'm inclined to go back to using
Crystal Reports unless I can get this resolved without <<<wasting>>
much more time!
Anyone have any thoughts?
GlennYou only want the client app on your computer. You can only install the RS
Enterprise on a server. The client app works perfectly fine for developing
reports and deploying them locally to view them. You will have to setup a
separate report server to deploy reports into production, if I understand
your needs.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||You are supposed to be able to install this version of XP Pro (see this
link: http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp)
Do you have XP Pro with SP1?
Another point to consider, XP Pro does not have IIS by default running. Have
you installed IIS? Add/Remove Programs Windows Components.
IIS needs to be installed plus ASP.Net needs to be installed and running. My
guess is something with the web server is not setup correctly.
Bruce L-C
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl...
> You only want the client app on your computer. You can only install the
RS
> Enterprise on a server. The client app works perfectly fine for
developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn
>|||I am having the same problem.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||I'm having a similar problem...
Enterprise and Developer set up on one server machine, Developer on 2
other desktops. If you access Report Manager from the Server machine,
everything looks fine. But Report Manager accessed from the
non-server machines shows the top banner only... No tabs, no folders,
nothing below the line, so a developer can't upload without switching
over to the server, and even then there are often errors.
Is there some configuration subtlety we missed?
Otherwise this thing is giving me problems with OutOfMemory errors on
local debugs that I know aren't too big.
Ideas?
Jody
"Lance" <ldacy@.fellowshiptech.com> wrote in message news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> You only want the client app on your computer. You can only install the RS
> Enterprise on a server. The client app works perfectly fine for developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn|||Your problem seems different. He was having a problem installing. Your
problem seems to be accessing it. It looks to me like you haven't setup your
roles for the developers on other machines.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> I'm having a similar problem...
> Enterprise and Developer set up on one server machine, Developer on 2
> other desktops. If you access Report Manager from the Server machine,
> everything looks fine. But Report Manager accessed from the
> non-server machines shows the top banner only... No tabs, no folders,
> nothing below the line, so a developer can't upload without switching
> over to the server, and even then there are often errors.
> Is there some configuration subtlety we missed?
> Otherwise this thing is giving me problems with OutOfMemory errors on
> local debugs that I know aren't too big.
> Ideas?
> Jody
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> > You only want the client app on your computer. You can only install the
RS
> > Enterprise on a server. The client app works perfectly fine for
developing
> > reports and deploying them locally to view them. You will have to setup
a
> > separate report server to deploy reports into production, if I
understand
> > your needs.
> >
> >
> > "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> > news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > > I've been trying to install the MSDN Developers edition of SQL Server
> > > Reporting Services for serveral hours. My environment is as follows:
> > >
> > > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > > (Enterprise).
> > >
> > > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > > The problem is that when I try to install the RS I only get the option
> > > to install the Client Components (not very helpful for developing
> > > reports locally)
> > >
> > > While this looks like a great tool I'm inclined to go back to using
> > > Crystal Reports unless I can get this resolved without <<<wasting>>
> > > much more time!
> > >
> > > Anyone have any thoughts?
> > >
> > > Glenn|||Hello all. Thanks for the feedback... sorry for not finishing up the
thread.
My solution was to re-install WIN XP Pro SP1. Once SP1 was
re-installed RS installed with no further problems.
Hope this helps!
Glenn
"Kurt" <kurt_junk@.sdlf.com> wrote in message news:<OUz#lSzfEHA.1092@.TK2MSFTNGP11.phx.gbl>...
> I am having the same problem.
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn
problem installing SQL Server Express CTP April 2005
How ever hard i tried to install "SQL Server Express CTP april 2005" i get errors. Earlier my system had previous version (beta 2) of the same. I removed and tried to install but cannot.
My system is already installed with MSDE 2000, Is it necessary to uninstall that ?
My another system is installed with SQL Server 2000 , i could also not able to install / rather i could not connect to SQL Express however tried.
could any one help.
thanks
There are a number of possibilities. Rather than speculate on what your problem might be, could you tell us:
What error do you get?
What OS and version are you installing on?
Is this machine connected to a domain? Is it in a workgroup?
Could you attach the setup logs?
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
problem installing sql server express
i'm stuck at SQL Server Database Services and at Setting File Security. Can someone help? Seeing the SQL Server Database Services log i get this:
Action start 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlUserSecurity
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlUserSecurity
PerfTime Start: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<Func Name='Write_sqlUserSecurity'>
<Func Name='ScheduleActionX'>
<Func Name='SetCAContext'>
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Adding Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
MSI (s) (44!E8) [22:25:56:417]: Doing action: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Action start 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Deleting Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its current value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
Action ended 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>
<EndFunc Name='Write_sqlUserSecurity' Return='0' GetLastError='0'>
PerfTime Stop: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (44:E4) [22:25:56:433]: Doing action: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (44:DC) [22:25:56:448]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIED.tmp, Entrypoint: Write_sqlFileSDDL
Action start 22:25:56: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlFileSDDL
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlFileSDDL
PerfTime Start: Write_sqlFileSDDL : Thu Dec 01 22:25:56 2005
I'm having the same problem installing SQL 2005 Enterprise Edtion. Once it gets to the "Setting File Security...", it just sits there hung. The only way to kill it is using the Task Manager.
It also looked like it was hung during "Installing Local Goups", but after 30 minutes or so, it moved on.
Hopefully someone from Microsoft can help us out!!!
|||... I'm having the same problem with the developer edition :(|||PROBLEM SOLVED : (?) Well, I think. I still need to test, but at least the install finished without error. Yesterday, I started the install at 2:46 PM and just let it run. Almost 8 hours later at 10:33 PM it finished.I only installed the SQL Server. I'll start the install for the services now and get back to you later when it finishes. It shouldn't take more than a few days! |||Good news, it only took 3.5 more hours to install all the services. Yes, it looked like it was hung there a few times, but I just let it go.
|||There is a workaround documented at
http://support.microsoft.com/?kbid=910070
-Jeffrey Baker
SQL Server Setup|||
Or simply disable your network temporarily if you are not installing from a network drive. Works like a charm !
Visit : http://sqljunkies.com/WebLog/simons/archive/2007/06/01/SQL_2005_install_hangs_on__Setting_File_Security_.aspx
SQL 2005 install hangs on "Setting File Security"
When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage.
This is due to th install trying to do some security resolution with domain controllers.
The easiest answer is to unplug the network cable (or disable the network interface), however if you are doing a remote install that may not be possible.
This KB discusses the issue http://support.microsoft.com/kb/910070/en-us and does provide hotfix which can be applied to the install so you don't encounter the problem
problem installing sql server express
i'm stuck at SQL Server Database Services and at Setting File Security. Can someone help? Seeing the SQL Server Database Services log i get this:
Action start 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlUserSecurity
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlUserSecurity
PerfTime Start: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<Func Name='Write_sqlUserSecurity'>
<Func Name='ScheduleActionX'>
<Func Name='SetCAContext'>
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Adding Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
MSI (s) (44!E8) [22:25:56:417]: Doing action: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Action start 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Deleting Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its current value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
Action ended 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>
<EndFunc Name='Write_sqlUserSecurity' Return='0' GetLastError='0'>
PerfTime Stop: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (44:E4) [22:25:56:433]: Doing action: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (44:DC) [22:25:56:448]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIED.tmp, Entrypoint: Write_sqlFileSDDL
Action start 22:25:56: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlFileSDDL
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlFileSDDL
PerfTime Start: Write_sqlFileSDDL : Thu Dec 01 22:25:56 2005
I'm having the same problem installing SQL 2005 Enterprise Edtion. Once it gets to the "Setting File Security...", it just sits there hung. The only way to kill it is using the Task Manager.
It also looked like it was hung during "Installing Local Goups", but after 30 minutes or so, it moved on.
Hopefully someone from Microsoft can help us out!!!
|||... I'm having the same problem with the developer edition :(|||PROBLEM SOLVED : (?) Well, I think. I still need to test, but at least the install finished without error. Yesterday, I started the install at 2:46 PM and just let it run. Almost 8 hours later at 10:33 PM it finished.I only installed the SQL Server. I'll start the install for the services now and get back to you later when it finishes. It shouldn't take more than a few days! |||Good news, it only took 3.5 more hours to install all the services. Yes, it looked like it was hung there a few times, but I just let it go.
|||There is a workaround documented at
http://support.microsoft.com/?kbid=910070
-Jeffrey Baker
SQL Server Setup|||
Or simply disable your network temporarily if you are not installing from a network drive. Works like a charm !
Visit : http://sqljunkies.com/WebLog/simons/archive/2007/06/01/SQL_2005_install_hangs_on__Setting_File_Security_.aspx
SQL 2005 install hangs on "Setting File Security"
When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage.
This is due to th install trying to do some security resolution with domain controllers.
The easiest answer is to unplug the network cable (or disable the network interface), however if you are doing a remote install that may not be possible.
This KB discusses the issue http://support.microsoft.com/kb/910070/en-us and does provide hotfix which can be applied to the install so you don't encounter the problem
PROBLEM INSTALLING SQL SERVER EXPRESS
Hi,
I successfully installed Visual Basic 2005 express edition and but the SQL Server component did not get installed.
12:37:11 AM Sunday, April 09, 2006: [Fail] ConfigSamplesDll_DoTasks:: [Fail] Config_SSE_INST_Install: SQL Express service install (failed). The process did not return a success value. ExitCode: 1282 Command: 'C:\Documents and Settings\Oluwaseyi Awoga\Local Settings\Temp\SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all SCCCHECKLEVEL=IncompatibleComponents:1 instancename=SQLEXPRESS'.
I keep getting this error. Can anybody help me? I have uninstalled and installed ALL versions of the .NET framework etc several times. Thanks
This is also the error signature. Thanks for your help.
Error Signature:
EventType : BEX P1 : setup.exe P2 : 2005.90.1399.0 P3 : 434f6403
P4 : msdtcprx.dll P5 : 2001.12.4414.258 P6 : 41109703 P7 : 0000a2c9
P8 : c0000409 P9 : 00000000
This is the content of the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
Microsoft SQL Server 2005 Setup beginning at Sun Apr 09 01:46:18 2006
Process ID : 952
c:\e37376beb65a16277a8441b9\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/3/9 1:46:17
Complete: LoadResourcesAction at: 2006/3/9 1:46:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18
Loaded DLL:c:\e37376beb65a16277a8441b9\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18, returned true
Running: ValidateWinNTAction at: 2006/3/9 1:46:18
Complete: ValidateWinNTAction at: 2006/3/9 1:46:18, returned true
Running: ValidateMinOSAction at: 2006/3/9 1:46:18
Complete: ValidateMinOSAction at: 2006/3/9 1:46:18, returned true
Running: PerformSCCAction at: 2006/3/9 1:46:18
Complete: PerformSCCAction at: 2006/3/9 1:46:18, returned true
Running: ActivateLoggingAction at: 2006/3/9 1:46:18
Complete: ActivateLoggingAction at: 2006/3/9 1:46:18, returned true
Running: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18
Complete: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__952" returned false.
Running: PerformSCCAction2 at: 2006/3/9 1:46:18
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/3/9 1:46:18, returned true
Running: PerformDotNetCheck at: 2006/3/9 1:46:18
Complete: PerformDotNetCheck at: 2006/3/9 1:46:18, returned true
Running: ComponentUpdateAction at: 2006/3/9 1:46:18
Complete: ComponentUpdateAction at: 2006/3/9 1:46:23, returned true
Running: DetectLocalBootstrapAction at: 2006/3/9 1:46:23
Complete: DetectLocalBootstrapAction at: 2006/3/9 1:46:23, returned true
Running: LaunchLocalBootstrapAction at: 2006/3/9 1:46:23
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1282
Aborting queue processing as nested installer has completed
Message pump returning: 1282
Thanks!!
|||I'm going to move this to the SQL Setup forum.
- Mike
|||I don't believe 1282 is a Setup error code; it's probably a Windows error code. 1282 translates to stack buffer overflow. We did fix one or two such issues a long time back. If the version of Express you're trying to install is pre-RTM then please download the RTM version or the remastered Express SP1 which should be available soon, and try again. If you're already trying with RTM then I suspect we're going to need to see the complete SQL Install logs to debug your problem.
Paul
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.
I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>
|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.
|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> > The problem seems to be with the authentication. It froze when Windows
> > updates attempted to install it, so I downloaded the exe from the ms
> > site. However this freezes too while running the "Authentication
> > Verification". This also happens if I just click the Test button.
> > I tried both Windows Authentication and SQL authentication and same
> > happens on both.
> > Any ideas what could cause this problem?
> > Thanks,
> > zoro.
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> > I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> > III ). It didn't really locked up though,
> > but it took good 10 minutes... could it be resource related in your case
> > too?
> > r
> >
> > "Zoro" <ilz...@.gmail.com> wrote in message
> >
> > news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> >
> > > The problem seems to be with the authentication. It froze when Windows
> > > updates attempted to install it, so I downloaded the exe from the ms
> > > site. However this freezes too while running the "Authentication
> > > Verification". This also happens if I just click the Test button.
> > > I tried both Windows Authentication and SQL authentication and same
> > > happens on both.
> > > Any ideas what could cause this problem?
> > > Thanks,
> > > zoro.
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
>
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John
Problem installing SQL Server 2005 Service Pack 2
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work
.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in
.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in th
e
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run und
er
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>
Problem installing SQL Server 2005 Service Pack 2
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.
Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>
|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>
Problem installing SQL Server 2005 Service Pack 2
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
> >I tried to run the new SP2 and it crashes. I get the dialog asking to send
> > the crash data to microsoft.
> >
> > I then checked the upgrade log and found a message saying that it could
> > not
> > log into the server. I know it had the right password because the service
> > pack checks that near the begining.
> >
> > I then checked the service and noticed that is was stopped. I then tried
> > to
> > manually start and stop the service during the upgrade each time I saw
> > that
> > it needed to start or stop it by the messages that came up. That didn't
> > work.
> > It got to a point later that said it could not stop the service.
> >
> > I then changed the login of the services themselves to be tan admin user.
> > That seemed to allow the service pack to start and stop the service ok,
> > but
> > it still crashes near the end now. The message is again that it can't log
> > in.
> >
> > I also must mention that after the first time this happened the small icon
> > on the lower right of the tray that is the sql server is gone.
> >
> > Please help. I need to get the SP2 to succeed so that it will be back to
> > normal.
> >
>
>
Problem installing SQL Server 2005 fails on MSXML6
For some reason when ever try to install SQL Server 2005 the install fails on MSXML6.
I get the following log file, can anyone make any sense of this.
=== Verbose logging started: 30/08/2007 22:16:00 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (84:10) [22:16:00:859]: Resetting cached policy values
MSI (c) (84:10) [22:16:00:859]: Machine policy value 'Debug' is 0
MSI (c) (84:10) [22:16:00:859]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (c) (84:10) [22:16:00:859]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (84:10) [22:16:00:859]: Grabbed execution mutex.
MSI (c) (84:10) [22:16:00:859]: Cloaking enabled.
MSI (c) (84:10) [22:16:00:859]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (84:10) [22:16:00:859]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (40:88) [22:16:00:859]: Grabbed execution mutex.
MSI (s) (40:58) [22:16:00:859]: Resetting cached policy values
MSI (s) (40:58) [22:16:00:859]: Machine policy value 'Debug' is 0
MSI (s) (40:58) [22:16:00:859]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (s) (40:58) [22:16:00:859]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (40:58) [22:16:00:859]: MainEngineThread is returning 1605
MSI (c) (84:10) [22:16:00:859]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:10) [22:16:00:859]: MainEngineThread is returning 1605
=== Verbose logging stopped: 30/08/2007 22:16:00 ===
I am having the same problem, Found that I could install the package seperatly in some cases but the SQL Install for Dev edition and Express edition (Through VS Setup) does not work and the full setup fails.
|||I was able to install the SQL Express Edition with the latest Service pack intergrated into the instal, but then installing the developer edition over the top I get the same errors. Dev edition will not install.|||I have tried transfering the Files from the CD to the Hard Drive, and it does not work. I have even re downloaded the msxml package from MS Downloads and swapped it into the install to see if that works. But still nothing seems to work.
|||Initially even the SQLExpress edition wouldnt install because of the same problem but when I downloaded MSXML6 by itself it seem to work. However SQL Server 2005 Developer Edition doesn't install.
|||anyone get a solution to this problem, i;m having similar issues installing SQL Server 2005 standard. Keeps failing on MSXML6. I've tried uninstalling msxml6 and reinstalling from sql disk and a fresh download from ms site but always get "the system administrator has set policies to prevent this installation"
I run regmon from sysinternals - lots of reg activity, so hard to analyse, but I noticed that msiexec.exe was trying to get HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\TMAS_OEHook.dll key but getting "NOT FOUND" - this is part of trend pc cillin 12 - not sure if relevant.
|||
Looks like I fixed it.
I tried uninstalling msxml6 but it wouldn't saying "This action is only valid for products that are currently installed."
So I found this forum post
http://207.46.236.188/msdn/rss.aspx?postid=1977209&forumid=26&siteid=1
I downloaded http://www.ursoftware.com/download.php to uninstall msxml6
Looks like a great util as I've loads of old *** on my home pc.
I then run the msxml6 from sql server disk 1 and it worked
So then rerun sql server setup and all seems okay.
Well that's my friday evening wasted, I was intending to get some coding done but that will be saturday wasted as well now.
|||I was quite excited when I got seen your post. However when I used the ursoftware to remove MSXML6 and tried to reinstall SQL server it failed in the same way.
Isnt there anyone from microsoft out there than can help us!!!!!
Why is this happening!!!
|||Has anybody solved this problem? I have the same problem and dont know what to do. I have uninstalled this but when I try to rienstall SQL Server the problem already happens.
How is possible that Microsoft has not solved it?
Thanks
|||I found it. This is the solution. Thanks To krobson
In this page...
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=2113041&isthread=false&siteid=1&authhash=aad032b508898d0d2d15a68c05396c2b476b4c7c&ticks=633247841167440228
The Solution is also here.....
--
Hey,
I had the same issues installing MSXML6.0 with my SQL Server 2005 Express Edition as part of CRM Dynamics 3.0. Despite there being no policy (local or global) in place to enforce such a thing, I kept getting a failed installation of SQL Express due to an issue with MSXML6.0. Whenever I tried to install MSXML6.0 stand-alone, all I would receive is this blasted error message:
"The system administrator has set policies to prevent this installation"
I tried several things over several hours including the following:
- registered then unregistered Windows installer package
- uninstalled and reinstalled Windows Installer package
- logging on as local admin to install
- creating a policy and enforcing the use of Windows Installer, as well as elevating the install rights of everyone.
- getting desperate I removed and reinstalled the .NET framework 1.1, 2 and 3 (this was the last thing I changed before having the issues)
- basically tried every recommendation I found through Google on every forum...TO NO AVAIL.
I used the Windows Installer Cleanup Utility (available here: http://support.microsoft.com/kb/290301) to remove the install configuration for MSXML6.0.
After that being done, everything works fine now and no words can express my relief...
I hope this helps someone else.
Kris
|||you rock absalon78! That did the job for me! thank you for taking the time to share it with us!Problem installing SQL Server 2005 fails on MSXML6
For some reason when ever try to install SQL Server 2005 the install fails on MSXML6.
I get the following log file, can anyone make any sense of this.
=== Verbose logging started: 30/08/2007 22:16:00 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (84:10) [22:16:00:859]: Resetting cached policy values
MSI (c) (84:10) [22:16:00:859]: Machine policy value 'Debug' is 0
MSI (c) (84:10) [22:16:00:859]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (c) (84:10) [22:16:00:859]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (84:10) [22:16:00:859]: Grabbed execution mutex.
MSI (c) (84:10) [22:16:00:859]: Cloaking enabled.
MSI (c) (84:10) [22:16:00:859]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (84:10) [22:16:00:859]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (40:88) [22:16:00:859]: Grabbed execution mutex.
MSI (s) (40:58) [22:16:00:859]: Resetting cached policy values
MSI (s) (40:58) [22:16:00:859]: Machine policy value 'Debug' is 0
MSI (s) (40:58) [22:16:00:859]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (s) (40:58) [22:16:00:859]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (40:58) [22:16:00:859]: MainEngineThread is returning 1605
MSI (c) (84:10) [22:16:00:859]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:10) [22:16:00:859]: MainEngineThread is returning 1605
=== Verbose logging stopped: 30/08/2007 22:16:00 ===
I am having the same problem, Found that I could install the package seperatly in some cases but the SQL Install for Dev edition and Express edition (Through VS Setup) does not work and the full setup fails.
|||I was able to install the SQL Express Edition with the latest Service pack intergrated into the instal, but then installing the developer edition over the top I get the same errors. Dev edition will not install.|||I have tried transfering the Files from the CD to the Hard Drive, and it does not work. I have even re downloaded the msxml package from MS Downloads and swapped it into the install to see if that works. But still nothing seems to work.
|||Initially even the SQLExpress edition wouldnt install because of the same problem but when I downloaded MSXML6 by itself it seem to work. However SQL Server 2005 Developer Edition doesn't install.
|||anyone get a solution to this problem, i;m having similar issues installing SQL Server 2005 standard. Keeps failing on MSXML6. I've tried uninstalling msxml6 and reinstalling from sql disk and a fresh download from ms site but always get "the system administrator has set policies to prevent this installation"
I run regmon from sysinternals - lots of reg activity, so hard to analyse, but I noticed that msiexec.exe was trying to get HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\TMAS_OEHook.dll key but getting "NOT FOUND" - this is part of trend pc cillin 12 - not sure if relevant.
|||
Looks like I fixed it.
I tried uninstalling msxml6 but it wouldn't saying "This action is only valid for products that are currently installed."
So I found this forum post
http://207.46.236.188/msdn/rss.aspx?postid=1977209&forumid=26&siteid=1
I downloaded http://www.ursoftware.com/download.php to uninstall msxml6
Looks like a great util as I've loads of old *** on my home pc.
I then run the msxml6 from sql server disk 1 and it worked
So then rerun sql server setup and all seems okay.
Well that's my friday evening wasted, I was intending to get some coding done but that will be saturday wasted as well now.
|||I was quite excited when I got seen your post. However when I used the ursoftware to remove MSXML6 and tried to reinstall SQL server it failed in the same way.
Isnt there anyone from microsoft out there than can help us!!!!!
Why is this happening!!!
|||Has anybody solved this problem? I have the same problem and dont know what to do. I have uninstalled this but when I try to rienstall SQL Server the problem already happens.
How is possible that Microsoft has not solved it?
Thanks
|||I found it. This is the solution. Thanks To krobson
In this page...
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=2113041&isthread=false&siteid=1&authhash=aad032b508898d0d2d15a68c05396c2b476b4c7c&ticks=633247841167440228
The Solution is also here.....
--
Hey,
I had the same issues installing MSXML6.0 with my SQL Server 2005 Express Edition as part of CRM Dynamics 3.0. Despite there being no policy (local or global) in place to enforce such a thing, I kept getting a failed installation of SQL Express due to an issue with MSXML6.0. Whenever I tried to install MSXML6.0 stand-alone, all I would receive is this blasted error message:
"The system administrator has set policies to prevent this installation"
I tried several things over several hours including the following:
- registered then unregistered Windows installer package
- uninstalled and reinstalled Windows Installer package
- logging on as local admin to install
- creating a policy and enforcing the use of Windows Installer, as well as elevating the install rights of everyone.
- getting desperate I removed and reinstalled the .NET framework 1.1, 2 and 3 (this was the last thing I changed before having the issues)
- basically tried every recommendation I found through Google on every forum...TO NO AVAIL.
I used the Windows Installer Cleanup Utility (available here: http://support.microsoft.com/kb/290301) to remove the install configuration for MSXML6.0.
After that being done, everything works fine now and no words can express my relief...
I hope this helps someone else.
Kris
|||you rock absalon78! That did the job for me! thank you for taking the time to share it with us!|||this worked for me too, tnx alot