SQL 2005 installation SCC problem

  • Does any one knows why the SCC is running like forever and the sql server 2005 installation never finishes? There's never any fail msg seen.

    I am trying to install sql server 2005 express with advance services on an machine with AMD Athlon XP 2000+ CPU. Does that not Pentium III - compatible CPU and failed the H/W requirement in the beginning and thus stop the SCC from running the full installation?

    In addition, my machine WinXP only has 255MB of ram and 60G of free HD space shouldn't be really matter according to the hardware requirement web pages from MS, should it?

    I had been running the installation for almost 24hrs+. I am hoping to get some insight whether this (sql server 2005) will work on my machine at all. thank you. [Wink]

  • Have you checked the installation log file at

    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

    MJ

  • Hi Manu,

    yes i did check the LOG and LOG/Files folders nothing unusual. in the SQLSetup0008_Machine_SCC (my 8th attempt), all callback function lines return TRUE. And the last line is as follow:

    Processing article DriveWriteAccess

    Openning namespace \\root\cimv2

    GetNamespace \\root\cimv2 returned 0 (0x0)

    Scc Error: 0 (0x0)

    Error code: 0 (0x0)

    Calling callback function for reason: 0x4

    Callback function returned TRUE

    Processing article COMPlus

    The time that it was last modified was the same time that I ran the setup. that means the SCC did not write anything at all in the last 23hr59min the SCC never saved any log file?! the only things that the setup ever installed were the support files and the native clients program. What log file(s) am I supposed to look into and at what lines? thanks

    wn

  • Is distributed transaction coordinator (MSDTC) service started on your machine?

    Check the com+ applications on the machine-->my computer (Control panel\administrative tools\Componant services\Computers\My Computer\Com+ Applications).

    MJ

  • UH OH... it's not completely started. it's running forever too!

    i see the following in the event viewer however:

    warning in COM+>>

    The CRM log file was originally created on a computer with a different name. It has been updated with the name of the current computer. If this warning appears when the computer name has been changed then no further action is required.

    error in MSDTS>>

    MS DTC log file not found. After ensuring that all Resource Managers coordinated by MS DTC have no indoubt transactions, please run msdtc -resetlog to create the log file.

    MS DTC Transaction Manager start failed. LogInit returned error 0x2.

    what is going on? is it another installation piece before I install the sql2k5? is it something made by MS?

    wn

  • Ok i ran the reset of MSDTC and the setup started by during the installation of the Database Engine setup component, it failed. The following is from the XXXXSQL.log file

    ---- Context -----------------------------------------------

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Error Code: -2146885628

    MSI (s) (10!D0) [19:46:21:253]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Doing Action: Do_sqlScript

    PerfTime Start: Do_sqlScript : Sat Mar 07 19:46:21 2009

    Service MSSQL$SQLEXPRESSMAR09 with parameters '-m SqlSetup -Q -qLatin1_General_BIN -T4022 -T3659 -T3610 -T4010' is being started at Sat Mar 07 19:46:21 2009

    Service failed unexpectedly (2148081668)

    Error Code: -2146885628

    Windows Error Text: Cannot find object or property.

    Source File Name: sqlsetuplib\service.cpp

    Compiler Timestamp: Sat Oct 25 08:47:19 2008

    Function Name: sqls::Service::Start

    Source Line Number: 301

    ---- Context -----------------------------------------------

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Error Code: -2146885628

    MSI (s) (10!D0) [19:46:35:274]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Doing Action: Do_sqlScript

    PerfTime Start: Do_sqlScript : Sat Mar 07 19:46:35 2009

    Service MSSQL$SQLEXPRESSMAR09 with parameters '-m SqlSetup -Q -qLatin1_General_BIN -T4022 -T3659 -T3610 -T4010' is being started at Sat Mar 07 19:46:35 2009

    Service failed unexpectedly (2148081668)

    Error Code: -2146885628

    Windows Error Text: Cannot find object or property.

    Source File Name: sqlsetuplib\service.cpp

    Compiler Timestamp: Sat Oct 25 08:47:19 2008

    Function Name: sqls::Service::Start

    Source Line Number: 301

    ---- Context -----------------------------------------------

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Error Code: -2146885628

    MSI (s) (10!D0) [19:46:49:204]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Doing Action: Do_sqlScript

    PerfTime Start: Do_sqlScript : Sat Mar 07 19:46:49 2009

    Service MSSQL$SQLEXPRESSMAR09 with parameters '-m SqlSetup -Q -qLatin1_General_BIN -T4022 -T3659 -T3610 -T4010' is being started at Sat Mar 07 19:46:49 2009

    Service failed unexpectedly (2148081668)

    Error Code: -2146885628

    Windows Error Text: Cannot find object or property.

    Source File Name: sqlsetuplib\service.cpp

    Compiler Timestamp: Sat Oct 25 08:47:19 2008

    Function Name: sqls::Service::Start

    Source Line Number: 301

    ---- Context -----------------------------------------------

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Error Code: -2146885628

    MSI (s) (10!D0) [19:49:53:318]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    Doing Action: Do_sqlScript

    PerfTime Start: Do_sqlScript : Sat Mar 07 19:49:54 2009

    Service MSSQL$SQLEXPRESSMAR09 with parameters '-m SqlSetup -Q -qLatin1_General_BIN -T4022 -T3659 -T3610 -T4010' is being started at Sat Mar 07 19:49:54 2009

    Service failed unexpectedly (2148081668)

    Error Code: -2146885628

    Windows Error Text: Cannot find object or property.

    Source File Name: sqlsetuplib\service.cpp

    Compiler Timestamp: Sat Oct 25 08:47:19 2008

    Function Name: sqls::Service::Start

    Source Line Number: 301

    ---- Context -----------------------------------------------

    Setting status of unmanaged components and removing unmanaged resources

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Do_sqlScript

    SqlScriptHlpr

    Start service MSSQL$SQLEXPRESSMAR09

    Error Code: -2146885628

    MSI (s) (10!D0) [19:51:45:079]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    MSI (c) (44:AC) [19:50:07:959]: Entering MsiProvideComponentFromDescriptor. Descriptor: ']gAVn-}f(ZXfeAR6.jiHandWritingFiles>RMn1s[Rh9@Iqc3L`JQB,, PathBuf: D7FC76C, pcchPathBuf: D7FC768, pcchArgsOffset: D7FC6C0

    MSI (c) (44:AC) [19:50:07:969]: Machine policy value 'DisableUserInstalls' is 0

    MSI (c) (44:AC) [19:50:08:500]: MsiProvideComponentFromDescriptor is returning: 0

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

    The error is (-2146885628) Cannot find object or property.

    .

    MSI (s) (10:6C) [19:51:50:006]: User policy value 'DisableRollback' is 0

    MSI (s) (10:6C) [19:51:50:026]: Machine policy value 'DisableRollback' is 0

    Action ended 19:51:49: InstallFinalize. Return value 3.

    MSI (s) (10:6C) [19:51:51:148]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=979868999,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

    MSI (s) (10:6C) [19:51:51:148]: Executing op: DialogInfo(Type=0,Argument=1033)

    MSI (s) (10:6C) [19:51:51:148]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)

    MSI (s) (10:6C) [19:51:51:148]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])

    MSI (s) (10:6C) [19:51:51:168]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

    MSI (s) (10:6C) [19:51:51:168]: Executing op: ProductInfo(ProductKey={B0F9497C-52B4-4686-8E73-74D866BBDF59},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151195587,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={92FF70AD-2527-4302-AC39-6695F1DE6B81},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)

    MSI (s) (10:6C) [19:51:51:178]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])

    MSI (s) (10:6C) [19:51:51:178]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server82680000lpc:MAINDESKTOP\SQLEXPRESSMAR09)

    MSI (s) (10:C4) [19:51:51:278]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI13C.tmp, Entrypoint: Rollback_sqlScript

    Thanks for much help.

    wn

  • No mine is AMD Athlon XP 2000+ CPU. unless it's using the same stepping that I don't know of. I tried a few different thing including turning off anti-virus and releasing IP and using Local Service account. I'd already trie 3 times and nothing worked so far. When looking at KBase at MS help and support, article ID:920114 does not seem to apply to my system at all. Well, the thing is under properties dialog box, there is no security tab for XP at all...

    So, I can't say for sure that Athlon XP is bad listed for SQL2k5.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply