SQL Server Performance

Moving ReportServer

Discussion in 'SQL Server 2008 Reporting Services' started by acki4711, Feb 12, 2010.

  1. acki4711 Member

    Hi all,
    I moved reporting services dbs from 2005 to a newly installed 2008 machine, importet encryption keys and configured ssrs.
    (as described here: http://msdn.microsoft.com/en-us/library/ms143724.aspx)
    All looks fine, but restarting the ssrs results in the following error log entry:
    Failed to unload app domain DefaultDomain. The following exception occurred: Error while unloading appdomain. (Exception from HRESULT: 0x80131015).
    Starting browser window and connecting reporting service (http://hostname/reportserver) ends in a dump:
    library!ReportServer_0-1!c88!02/12/2010-09:00:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Interner Fehler beim Berichtsserver. Weitere Informationen finden Sie im Fehlerprotokoll., Incorrect security descriptor version;
    Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Interner Fehler beim Berichtsserver. Weitere Informationen finden Sie im Fehlerprotokoll.
    What is going wrong here? Any help is highly appreciated!
    TIA
    acki4711
  2. satya Moderator

    I think this is a problem with AD & SQL Server will associate the Windows principal via a SID the same way Windows does, but in addition to the SID, SQL Server also stores the friendly name (NetBIOS name) to map the SID to a SQL principal object (i.e. SELECT name, sid FROM sys.server_principals ).

    When the name changes in the AD the SID remain the same, but if a corresponding login or user was explicitly or implicitly created in SQL Server for this principal, then the names will be out of sync.

Share This Page