dwhite@citadelitg.com

DO you have any Idea how to put my default user back into SQL?

Could it be a security issue? What does the server need in order to write to a SQL server on another box?

ok, I followed your procedure, and this is the error I received in the dataldr.log file Processing Inventory for Machine: HQ-IT-DWHITE Version 1.244 Generated: 06/18/2014 12:48:11 SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:20 PM 24032 (0x5DE0) Loading architecture System from the database. SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:20 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pWorkstationStatus_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:20 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSYSTEM_CONSOLE_USER_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:20 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSYSTEM_CONSOLE_USER_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:20 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSYSTEM_CONSOLE_USAGE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_EXECUTABLE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pINSTALLED_SOFTWARE_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pAdd_Remove_Programs_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pBROWSER_HELPER_OBJECT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pBROWSER_HELPER_OBJECT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSystem_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) CGroup::AddGroup - couldn't get procedure pSOFTWARE_SHORTCUT_DATA SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) Signaled to abort. SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0) Done: Machine=HQ-IT-DWHITE(GUID:131F743B-F112-4BEC-A85F-B06A3C3D240D) code=0 (0 stored procs in XHYQNJY1D.MIF) SMS_INVENTORY_DATA_LOADER 6/18/2014 12:49:21 PM 24032 (0x5DE0)

I am trying to run the report "Computers with Specific software registered in Add Remove Programs" to get an accurate count of what workstations have what software installed. I try to run the report and I get nothing back, I look at the Table and the View, and receive nothing back. I was wondering if anyone could help. I built a report that works, But it would be nicer to get the Add Remove list to work. Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName, SP.ProductName, SP.ProductVersion FROM v_GS_SoftwareProduct SP JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = "COL0000F'' ORDER By SYS.Netbios_Name0, SP.CompanyName, SP.ProductName, SP.ProductVersion attached are my client settings