none
problem installing sql server express

    Question

  • help i'm having serious problems installing sql server express and quite at a loss.

    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
    Thursday, December 1, 2005 2:32 PM

Answers

All replies

  • 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!!!

    Monday, December 5, 2005 6:48 PM
  • ... I'm having the same problem with the developer edition :(
    Tuesday, December 6, 2005 1:27 PM
  • 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! Tongue Tied
    Tuesday, December 6, 2005 3:12 PM
  • 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. Big Smile
    Tuesday, December 6, 2005 7:41 PM
  • There is a workaround documented at
    http://support.microsoft.com/?kbid=910070

    -Jeffrey Baker
    SQL Server Setup
    Wednesday, December 7, 2005 2:36 AM
  • 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 &quot;Setting File Security&quot;

    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

    Friday, June 15, 2007 1:12 AM
  • I am installing from a local copy.This method worked for me. As soon as i unplugged from the network, the installation resumed and zip right through it.

    Tuesday, October 9, 2007 7:54 PM
  • Great!!!  ...I could install SQL Developer Edition just disabling the network connection...Thanks everyone!!!

     

    Thursday, October 16, 2008 7:07 PM