Search the Community
Showing results for tags 'sql 2008 r2'.
-
Hello together We have an issue in our LAB, when we try to import any driver into SCCM 2012 RC2 Console. It doesnt matter which driver we try to import, it always fail with following error: "An error occureed while importing the selected driver" I had a look into the SmsAdminUI.log and what I found there, seems a bit strange :[6, PID:5604][03/19/2012 15:34:30] :Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe SMS Provider reported an error.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put(ReportProgress progressReport) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put() at Microsoft.ConfigurationManagement.AdminConsole.DesiredConfigurationManagement.ConsoleDcmConnection.Microsoft.ConfigurationManagement.DesiredConfigurationManagement.IDcmStoreConnection.StoreNewItem(ConfigurationItem item) at Microsoft.ConfigurationManagement.DesiredConfigurationManagement.ConfigurationItem.Persist(Object existingStoreItem) at Microsoft.ConfigurationManagement.AdminConsole.Driver.ImportDriverWizardForm.PutDriverObject(SmsDialogData pageData, IResultObject selectedObject, DriverConfigurationItemInfo driverInfo, List`1 allDriversInfoToRefreshDP, Boolean& hasValidDriver, Boolean& hasErrorDriver, PropertyDataUpdateAction& updateAction)\r\nConfigMgr Error Object:instance of SMS_ExtendedStatus{ CauseInfo = ""; Description = "SQL command failed: if (object_id('tempdb..#sp_setupci_resultstr') IS NOT NULL) drop table #sp_setupci_resultstr;"; ErrorCode = 2168851714; File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\ssputility.cpp"; Line = 2105; ObjectInfo = "Please check SMS Provider log file for details of the SQL errors"; Operation = "PutInstance"; ParameterInfo = ""; ProviderName = "ExtnProv"; SQLMessage = "[24000][0][Microsoft][sql Server Native Client 10.0]Invalid cursor state"; SQLSeverity = 0; SQLStatus = 0; StatusCode = 2147749889;}; We use SCCM 2012 with only a Primary Site and SQL Server 2008 R2 SP 1 CU4. May somebody experienced the same problem? Thank you for your help Best wishes
-
SCCM 2012 > issues with ReportServer_log.LDF size
h4x0r posted a topic in Configuration Manager 2012
We’ve been using SCCM 2012 since its release without any major issues, but I noticed today that we’re fast running out of room on the partition we have SQL2008 R2 installed on, and that the culprit was ReportServer_log.ldf. It is currently 145GB and growing, and nothing I have tried has reduced its size. So far I have changed the recovery node to Simple, performed a backup (which I thought was supposed to flush LDF files?), and performed a Shrink (file based) on our ReportServer DB (though I can't find any listing of ReportServer_log.LDF when using MS SQL Server Management Studio, and it reports that our ReportServer DB is only ~45MB). Any SCCM/SQL gurus out there that could offer some insight into how I can reduce its size, AND keep it from getting this large in the future? Is there a way to pull up/modify the LDF file from the Management Studio? Thanks for any input...I'm at a complete loss here!