none
Move database to new server

    Question

  • I am trying to move my database to a new server.  When I try and modify my SQL server configuration (Running Setup.exe from .\bin\i386) the process stops the servers, moves on to the second process then crashes. 

     

    EDIT:  I am running SCCM SP2 R3 SQL R2 SP1


    Jason
    • Edited by freebird_ Thursday, January 26, 2012 11:30 PM
    Thursday, January 26, 2012 11:20 PM

All replies

  • Here is an excellent guide to achive this. Yes, you need to stop the SCCM related services and run preinst.exe /stopsite before starting this activity.

    http://www.windows-noob.com/forums/index.php?/topic/693-guide-moving-your-site-database/

    and if you're using FEP (integrated) then see, http://blogs.technet.com/b/clientsecurity/archive/2011/07/14/how-to-move-the-fep-databases-and-the-cm-site-database.aspx


    Anoop C Nair - @anoopmannur

    MY BLOG:  http://anoopmannur.wordpress.com

    User Group:  ConfigMgr Professionals

    This posting is provided AS-IS with no warranties/guarantees and confers no rights.

    Friday, January 27, 2012 2:31 AM
  • I do run preinst.exe/stopsite and it does stop the site.  I am running FEP integrated and have followed the your link.  However, when I run the config manager setup to repoint my DB that process crashes on update registry.  I am not sure but I think it might be a permisson issue.  Is there a log I should be looking at?  On the new SQL server each SQL process is running under a different service account which only one has local admin rights.  Do all of the SQL services need local admin rights?
    Jason
    Friday, January 27, 2012 2:56 AM
  • Problem signature:
      Problem Event Name:    APPCRASH
      Application Name:    SETUP.EXE_System Center Configuration Manager
      Application Version:    4.0.6487.2000
      Application Timestamp:    4ab33f39
      Fault Module Name:    SETUP.EXE
      Fault Module Version:    4.0.6487.2000
      Fault Module Timestamp:    4ab33f39
      Exception Code:    c0000005
      Exception Offset:    0023ec94
      OS Version:    6.1.7601.2.1.0.272.7
      Locale ID:    1033
      Additional Information 1:    0a9e
      Additional Information 2:    0a9e372d3b4ad19135b953a78882e789
      Additional Information 3:    0a9e
      Additional Information 4:    0a9e372d3b4ad19135b953a78882e789
    Jason
    Friday, January 27, 2012 3:12 AM
  • Here is a copy of the ConfigMgrSetup log

    ===================== << Starting SMS V4 SP2 Setup >> =====================
    <01-26-2012 19:07:32> Commandline :
    "E:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\SETUP.EXE"
    <01-26-2012 19:07:32> This is 64 bit.
    <01-26-2012 19:07:32> Verifying the Reg for AssetIntelligence Installation
    <01-26-2012 19:07:32> Found installation of AssetIntelligence Full version
    <01-26-2012 19:07:32> Setup detected an existing SCCM installation. Currently installed version is 6487
    <01-26-2012 19:07:32> Phase is 1C7
    <01-26-2012 19:07:32> Setting the default CSV folder path
    <01-26-2012 19:07:32> SMS Build Number = 6487
    <01-26-2012 19:07:32> SMS Version = 4.0
    <01-26-2012 19:07:32> SMS Minimum Build Number = 800
    <01-26-2012 19:07:32> Verifying SMS Active Directory Schema Extensions.
    <01-26-2012 19:07:33> DS Root:CN=Schema,CN=Configuration,DC=Domain,DC=com
    <01-26-2012 19:07:33> Verifying SMS Active Directory Schema Extensions.
    <01-26-2012 19:07:33> DS Root:CN=Schema,CN=Configuration,DC=Domain,DC=com
    <01-26-2012 19:07:33> Registered type SCCM MASTER for SCCM master
    <01-26-2012 19:07:33> Registered type SMS Master for SCCM master
    <01-26-2012 19:07:33> Registered type SCCM SMS_EHC for SCCM SMS_EHC
    <01-26-2012 19:07:33> Registered type SMS ACCESS for SCCM SMS_EHC
    <01-26-2012 19:07:34> Setup has detected an existing site server installation on this computer. Because you are running Setup from your local start menu, you cannot install a new Configuration Manager component or upgrade an existing installation. To modify this installation, you must run Setup from the Configuration Manager installation media.
    <01-26-2012 19:07:34> Setup has detected an existing site server installation on this computer. Because you are running Setup from your local start menu, you cannot install a new Configuration Manager component or upgrade an existing installation. To modify this installation, you must run Setup from the Configuration Manager installation media.
    <01-26-2012 19:07:38> Verifying the Reg for AssetIntelligence Installation
    <01-26-2012 19:07:38> Found installation of AssetIntelligence Full version
    <01-26-2012 19:07:38> Getting best SC file
    <01-26-2012 19:08:20> Entry: KillUserApps()
    <01-26-2012 19:08:20> Exiting Kill User apps
    <01-26-2012 19:08:20> IsValidNetBIOSName validation of 'ISDB' succeeded
    <01-26-2012 19:08:20> Registered type ISDB MASTER for ISDB master
    <01-26-2012 19:08:20> Registered type SMS Master for ISDB master
    <01-26-2012 19:08:20> Registered type ISDB SMS_EHC for ISDB SMS_EHC
    <01-26-2012 19:08:20> Registered type SMS ACCESS for ISDB SMS_EHC
    <01-26-2012 19:08:20> SQL Server ISDB is not clustered.
    <01-26-2012 19:08:20> Checking the SQL version.
    <01-26-2012 19:08:20> Sql version is 10.50, 10.50.2500.0.
    <01-26-2012 19:08:20> Verifying SMS Active Directory Schema Extensions.
    <01-26-2012 19:08:20> DS Root:CN=Schema,CN=Configuration,DC=Domain,DC=com
    <01-26-2012 19:08:20> Verifying SMS Active Directory Schema Extensions.
    <01-26-2012 19:08:21> DS Root:CN=Schema,CN=Configuration,DC=Domain,DC=com
    <01-26-2012 19:08:21> Entry: KillUserApps()
    <01-26-2012 19:08:21> Exiting Kill User apps
    <01-26-2012 19:08:21> Running test query.
    <01-26-2012 19:08:21> Sql version is 10.50, 10.50.2500.0.
    <01-26-2012 19:08:21> Getting best SC file
    <01-26-2012 19:08:21> SMS Shutdown: Calling StopServices()
    <01-26-2012 19:08:28> Precautionary shutdown of services
    <01-26-2012 19:08:28> Stopping service SMS_SITE_COMPONENT_MANAGER
    <01-26-2012 19:08:34> Stopping service SMS_SQL_MONITOR
    <01-26-2012 19:08:34> Service SMS_SQL_MONITOR is not installed, skip it.
    <01-26-2012 19:08:34> Stopping service SMS_EXECUTIVE
    <01-26-2012 19:08:34> Stopping service SMS_SERVER_BOOTSTRAP_SCCM
    <01-26-2012 19:08:34> Service SMS_SERVER_BOOTSTRAP_SCCM is not installed, skip it.
    <01-26-2012 19:08:34> Stopping service SMS_REPORTING_POINT
    <01-26-2012 19:08:34> Stopping service SMS_SERVER_LOCATOR_POINT
    <01-26-2012 19:08:34> Stopping service SMS Remote Control Agent
    <01-26-2012 19:08:34> Service SMS Remote Control Agent is not installed, skip it.
    <01-26-2012 19:08:34> Stopping service SMS_SITE_BACKUP
    <01-26-2012 19:08:34> Stopping service SMS_SITE_SQL_BACKUP
    <01-26-2012 19:08:34> Stopping service SMS_SITE_VSS_WRITER
    <01-26-2012 19:08:34> Attempting to stop WMI, and all dependent services.
    <01-26-2012 19:08:34> Stopping CcmExec.
    <01-26-2012 19:08:36> Stopping iphlpsvc.
    <01-26-2012 19:08:38> Stopping WMI.
    <01-26-2012 19:08:40> Applying database security settings.
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON spGetAIProxySettings TO [smsdbrole_AIUS]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON GetPendingUploadData TO [smsdbrole_AIUS]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON UnknownSystem_DISC TO [smsdbrole_PSP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON Sites TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON SysResList TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON RoamingBoundaryIPSubnet TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON RoamingBoundaryIPv6Prefix TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON RoamingBoundaryIPRange TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT SELECT ON RoamingBoundaryADSite TO [smsdbrole_SLP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetAllInventoryClasses TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetClientIDFromMacAddress TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetClientIDFromSmbiosID TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetInventoryClassProperties TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetSiteInfoFromADSite TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetSiteInfoFromIPAddress TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetSiteInfoFromIPv6Prefix TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetSiteInfoUnified TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetContentDPInfoProtected TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetContentDPInfoUnprotected TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetProtectedSMPSites TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetUnprotectedSMPSites TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetStateMigClientInfo TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetStateMigAssocInfo TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetMigrationInfoForRestoreClient TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetMigrationInfoUsersForRestoreClient TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetSelectiveDownloadMap TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetPeerDPList TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetWSUSServerLocations TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetPendingPackagesForBranchDP TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetPolicyBody TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetPolicyBodyAfterAuthorization TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_IsPolicyBodyAuthorized TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_IsClientRegistered TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON sp_GetPublicKeyForSMSID TO [smsdbrole_MP]
    <01-26-2012 19:08:40> Adding Permission: GRANT EXECUTE ON MP_GetEncryptionCertificateForSMSID TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetProvisioningModePolicyAssignments TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetMachinePolicyAssignments TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetUserAndUserGroupPolicyAssignments TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetListOfMPsInSite TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetHINVLastUpdateTime TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetLocalSitesFromAssignedSite TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetMPSitesFromAssignedSite TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetMPListForSite TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetSdmPackageBody TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_MatchDrivers TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON sp_GetPublicKeySMSUID TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON spGetResourceClientState TO [smsdbrole_MP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON spGetClientItemState TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON NBS_GetPXEAction TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON NBS_LookupDevice TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON PXE_GetSiteTypeAndDefaultMP TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON PXE_GetUnknownMachineResource TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON PXE_GetDefaultMPForSite TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON PXE_GetPXECert TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON PXE_GetMpCertificates TO [smsdbrole_PSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MCS_GetPkgInfoForMulticastShare TO [smsdbrole_MCS]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON sp_GetPublicKeyForSMSID TO [smsdbrole_MCS]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON MP_GetEncryptionCertificateForSMSID TO [smsdbrole_MCS]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetMachinePolicies TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetPackageVersion TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetSettings TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetSoftwareDistBody TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetSoftwareDistIDs TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetHinvTranslations TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON DMP_GetDiscoveryTranslations TO [smsdbrole_DMP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetProfile TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetCurProvServerCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetAMTMachineProperties TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetClientCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetAMTCapMachines TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetSystemDisc TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetProvAccounts TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetPowerSchemes TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetCurAuditPolicies TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetWirelessProfiles TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_Get8021xProfiles TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetWirelessClientCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_AddWirelessClientCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetWirelessServerCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetWired8021xProfiles TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_IPToResourceID TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetSiteMode TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_Remove8021xCert TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_Get8021xCertForRevoke TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON spExtEnableDeleteDetection TO [smsdbrole_extract]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON Report TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON ReportParameters TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON DrillThroughColumns TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON Dashboard TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON DashboardReports TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON LocalizedNameLookup TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON fn_Split TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON fn_DriverPlatform TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON sp_CreateReportProc TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnCILocales TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnSUM_DetectionStatusRank TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnSCCMMultiByteToWideChar TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnBuildCICategories TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnConvertBinaryToHexString TO [webreport_approle]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON fn_Split TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT SELECT ON fn_DriverPlatform TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnCILocales TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnSUM_DetectionStatusRank TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnSCCMMultiByteToWideChar TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnBuildCICategories TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON fnConvertBinaryToHexString TO [smsschm_users]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetACLs TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetRealms TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON AMT_GetThisSitesNetBiosNames TO [smsdbrole_AMTSP]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdateSettings TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdatePolicyInfo TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdatePingInfo TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_GetUnhealthyClients TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdatePolicyCollectionFinished TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdatePingCollectionFinished TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdateHistoryCurrentState TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdateCurrentHealth TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_SyncClientSummary TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_CleanAgedRecords TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_GetMPList TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding Permission: GRANT EXECUTE ON CH_UpdateInactiveClients TO [smsdbrole_CH]
    <01-26-2012 19:08:41> Adding smsdbrole_siteprovider to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteprovider'
    <01-26-2012 19:08:41> Adding smsdbrole_siteserver to db_owner: EXEC sp_addrolemember 'db_owner', 'smsdbrole_siteserver'
    <01-26-2012 19:08:41> Adding a login for SMS Site Server: IF NOT EXISTS (select * from master.sys.server_principals where name='Domain\SCCM$') CREATE LOGIN [Domain\SCCM$] FROM WINDOWS
    <01-26-2012 19:08:42> Creating user for SMS Site Server to master db: IF NOT EXISTS (select * from sys.database_principals where name='Domain\SCCM$') CREATE USER [Domain\SCCM$]
    <01-26-2012 19:08:42> Granting an execute permissions on sys.xp_msver: GRANT EXECUTE on sys.xp_msver to [Domain\SCCM$]
    <01-26-2012 19:08:42> Granting VIEW SERVER STATE to site server: GRANT VIEW SERVER STATE to [Domain\SCCM$]
    <01-26-2012 19:08:42> Adding site server machine account to db_datareader role: sp_addrolemember 'db_datareader', 'Domain\SCCM$'
    <01-26-2012 19:08:42> Adding site server to securityadmin: sp_addsrvrolemember 'Domain\SCCM$', 'securityadmin'
    <01-26-2012 19:08:42> Creating user for SMS Site Server: IF NOT EXISTS (select * from sys.database_principals where name='Domain\SCCM$') CREATE USER [Domain\SCCM$]
    <01-26-2012 19:08:42> Adding site server to smsdbrole_siteserver: EXEC sp_addrolemember 'smsdbrole_siteserver', 'Domain\SCCM$'
    <01-26-2012 19:08:42> Adding a login for SMS Provider: IF NOT EXISTS (select * from master.sys.server_principals where name='Domain\SCCM$') CREATE LOGIN [Domain\SCCM$] FROM WINDOWS
    <01-26-2012 19:08:42> Creating user for SMS Provider: IF NOT EXISTS (select * from sys.database_principals where name='Domain\SCCM$') CREATE USER [Domain\SCCM$]
    <01-26-2012 19:08:42> Adding SMS Provider machine account to smsdbrole_siteprovider: EXEC sp_addrolemember 'smsdbrole_siteprovider', 'Domain\SCCM$'
    <01-26-2012 19:08:42> Creating logins and assigning roles for site systems.
    <01-26-2012 19:08:42> Assigning server SCCM to role AI Update Service Point
    <01-26-2012 19:08:42> Assigning server SCCM to role SMS AMT Service Point
    <01-26-2012 19:08:42> Assigning server SCCM to role SMS Device Management Point
    <01-26-2012 19:08:42> Assigning server SCCM to role SMS Management Point
    <01-26-2012 19:08:42> Assigning server SCCM to role SMS Reporting Point
    <01-26-2012 19:08:42> Assigning server SCCM to role SMS Server Locator Point
    <01-26-2012 19:08:42> Setting up Reporting Security.
    <01-26-2012 19:08:44> READ_COMMITTED_SNAPSHOT enabled.
    <01-26-2012 19:08:44> SQL CLR enabled.


    Jason
    Friday, January 27, 2012 3:19 AM
  • I can't see any errors in the above log snippet

    Anoop C Nair - @anoopmannur

    MY BLOG:  http://anoopmannur.wordpress.com

    User Group:  ConfigMgr Professionals

    This posting is provided AS-IS with no warranties/guarantees and confers no rights.

    Friday, January 27, 2012 7:19 AM
  • Any thoughts on how to proceed?  Is there a log file on sql that might help?
    Jason
    Friday, January 27, 2012 5:59 PM
  • Hope, you already have a look at windows-noob link. This may help check any permission related steps that you missed?

    Anoop C Nair - @anoopmannur

    MY BLOG:  http://anoopmannur.wordpress.com

    User Group:  ConfigMgr Professionals

    This posting is provided AS-IS with no warranties/guarantees and confers no rights.

    Saturday, January 28, 2012 2:03 AM
  • Yes my SCCM server is a local admin on my sql box.  I have found these errors on my SCCM box.

     


    Severity    Type    Site code    Date / Time    System    Component    Message ID    Description
    Warning    Milestone    EHC    1/27/2012 6:16:12 PM    SCCM    SMS_COMPONENT_STATUS_SUMMARIZER    4504    Unable to decrypt the SQL server login user name and/or password.


    Severity    Type    Site code    Date / Time    System    Component    Message ID    Description
    Error    Milestone    EHC    1/27/2012 6:15:06 PM    SCCM    SMS_INVENTORY_DATA_LOADER    599    SQL Login data is incomplete.

     

     

    And this error on my SQL box

     

    Login failed for user 'DOMAIN\SQLISDB'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]


    Jason
    Saturday, January 28, 2012 2:45 AM