Solved

2008 express install fails. Not all privileges or groups referenced are assigned to the caller

Posted on 2011-09-19
9
4,677 Views
Last Modified: 2012-06-21
OS Win Srv 2008 R2 x64.   Installing MSSQL Express 2008 R2 with Advanced Services x64
 
Install completes 90% (SqlEngineDBStartCinfigAction_install_configrc_Cpu64)
 
 and then returns this error.
 
 
 
 TITLE: Microsoft SQL Server 2008 R2 Setup
 
------------------------------
 
The following error has occurred:
 
Not all privileges or groups referenced are assigned to the caller.
 
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
 
For help, click: http://go.microsoft.com/fwlink?LinkID=20476HYPERLINK "http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0xB2652E58%25400xDC80C325"&HYPERLINK
 
Retry doesn't work and Cancel doesn't close the dialogue box.  The install totally hangs.
 
The same .exe installs into Win 7 with no problem.  the w/tools version of Express, installed on this same server with out a problem.  I restored a, pre MSSQL install, image of the server before trying to install with Advanced Services.
0
Comment
Question by:Bobmumm
  • 7
9 Comments
 
LVL 10

Expert Comment

by:sqlservr
ID: 36559069
these 3 pre requistics are requiered when installing
   * Dot Net Framework 3.5
    * MDAC version 2.8 or above
    * Windows Installer 4.5 or above
0
 
LVL 7

Expert Comment

by:mozcullu
ID: 36559366
Looks like a security issue. Did you try to run it with Run as administrator option or disable UAC (User Account Control) on server
0
 

Author Comment

by:Bobmumm
ID: 36561725
sqlservr

Windows update already installed .NET framekwork 4 Client and Extended.  From my rearch MDAC doesn't apply to Window Server 2008 R2.  How do you determine the Windows Installer version (it is not listed in Control Panel\Programs and Features)?  From what I read 4.5 is not compatible with Windows Server 2008 R2 and I cannot find a place to download Installer 5.0.  If you could guide me as to how update the installer that would be very useful.  When I ran SQLEXPRADV_x64_ENU.exe as Administrator (see reply to mozcullu) I did get an update installer message before reparing .NET framework, but I can't figure out hwo to update the installer.


mozcullu

I tried running SQLEXPRADV_x64_ENU.exe as Administrator.  Prompted to update .NET and installer.  Repaired framework 4 and ran again and got the same call error after getting through 90% of the installation.  If you look in CP\Prog and Feat  most of the Software is installed but the installer is completely hung.  I haven't been able to figure out how to update the installer.
0
 

Author Comment

by:Bobmumm
ID: 36561739
Typo 'From my rearch MDAC' should read 'From my research MDAC'
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

Author Comment

by:Bobmumm
ID: 36561917
Here is the last entry in the Details.txt file

2011-09-19 10:07:24 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110919_095349\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2011-09-19 10:07:24 Slp: Prompting user if they want to retry this action due to the following failure:
2011-09-19 10:07:24 Slp: ----------------------------------------
2011-09-19 10:07:24 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-09-19 10:07:24 Slp: Inner exceptions are being indented
2011-09-19 10:07:24 Slp:
2011-09-19 10:07:24 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2011-09-19 10:07:24 Slp:     Message:
2011-09-19 10:07:24 Slp:         Not all privileges or groups referenced are assigned to the caller.
2011-09-19 10:07:24 Slp:        
2011-09-19 10:07:24 Slp:     Data:
2011-09-19 10:07:24 Slp:       WatsonData = SOFTWARE\Microsoft\Microsoft SQL Server
2011-09-19 10:07:24 Slp:       DisableRetry = true
2011-09-19 10:07:24 Slp:     Inner exception type: System.ComponentModel.Win32Exception
2011-09-19 10:07:24 Slp:         Message:
2011-09-19 10:07:24 Slp:                 Not all privileges or groups referenced are assigned to the caller.
2011-09-19 10:07:24 Slp:                
2011-09-19 10:07:24 Slp:         Stack:
2011-09-19 10:07:24 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
2011-09-19 10:07:24 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
2011-09-19 10:07:24 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.WriteHklmRegistryKeyToFile(ServiceContainer ctx, String keyName, String fileName)
2011-09-19 10:07:24 Slp: ----------------------------------------
0
 

Author Comment

by:Bobmumm
ID: 36562931
New installation of Windows Server 2008 R2, ran update several times to get all the updates in.

Micrososft .NET Framework 4 Client Profiles and Extended have been installed by Windows Update.
Ran msiexec /? to see installed version of Windows Installer:  Windows ® Installer. V 5.0.7601.17514

Ran SQLEXPRADV_x64_ENU.exe as Administrator.  Replies need
     SQL Server 2008 R2 setup requires Microsoft .Net Framework and an updated
     Windows       Installer to be installed.
     To enable the >NET Framework Core role, click OK. To exit Setup, click Cancel.

Clicked OK and it proceeds with the installation.  I install everything and use the defaults on everything.

It again hangs 90% through the install with the 'assigned to caller' error message.  The install is hung from that point, pressing neither Retry or Cancel allows the install to proceed.

1.4 G of files have been loaded into the Program Files\Microsoft SQL Server folder tree.

15 programs have been added to CP\Programs and Features

Six SQL programs are in Services and The SQL Server is started. The Report Server is noticeably absent.

The summary log shows that many things failed
Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Full-Text Search
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Reporting Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Basic
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Business Intelligence Development Studio
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Microsoft Sync Framework
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

If anybody has succesfully loaded MSSQL Express 2008 R2 x64 with Advanced Services on a Windows Server 2008 R2 installation I would like to hear form you.
0
 

Author Comment

by:Bobmumm
ID: 36564657
The above attempts were on a Win Srv Enterprise 2008 R2 x64 installation.  I tried it on a Win Srv Standard 2008 R2 x64 installation.  Had the same problem.  Tried it a second time with User Account Control turned off and still had the same problem.

Has anyone been succesful in installing MSSQL EXPESS 2008 R2 with Advanced Services on any edition of Windows Server 2008 R2?  I've esuccessfully installed it on Win 7 and Win Srv 2003.
0
 

Accepted Solution

by:
Bobmumm earned 0 total points
ID: 36578232
I was running the SQL isntall exe from a separate internal phycial drive.  When I copied the exe to
the server desktop and ran it form there, it not only ran faster the install completerd without a hitch.
0
 

Author Closing Comment

by:Bobmumm
ID: 36597831
It is th esolution.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now