sql

Hi, Has anyone come across this before? I am moving our SCCM database from SQL 2012 on a 2012r2 server to SQL 2019 on a 2019 server, by recovering from a backup. All seems to have gone fine, until the final step of running config manager setup again to choose the site maintenance option, to...

hey guys.. i am trying to install Scom but i have a problem with connecting to Sql2019 In this senario i have 3 vms, so i installed sql server on vms "Scom-DW" and "Scom-OP" but when i try to install scom and connect to sql from vm "Scom-MP", i get back the eror "Login failed. The login is from...

Dear community I'm dealing with an issue for a day now and i can't get passed it. I am trying to install a Second Site and it keep failing with... ERROR: Failed to start the SQL Server Express installation process. Configuration Manager Setup 22.07.2022 18:21:49 668 (0x029C) INFO: send...

Hi, SMS Site Cannot Access Sql server (2017) Any ideas...

Hello i have to query that returns SCCM error codes based on collection name and softwarename. This query is running well but in order to get the error codes, i use the view 'v_CIErrorDetails' whitch returns a lot of errors. I suppose these errors are history that SCCM keeps. Is there a way...

Hello i found an SQL query that i adapted in order to get all the SCCM applications located in "Software library/Applications" and it works nicely but i need to retrieve the "ObjectPath" column because i have a few subfolders i need to filter. here is the query: SELECT...

Dear Team, Iam having SCCM 2010 in a VM and database in a separate physical server (Windows server 2016 and SQL 2012 SP4). Now i want to update the database to 2017 for installing SCOM 2019 & SCVMM 2019 as these will not work on SQL 2012 (I need to use one SQL for 3 suites). For this purpose...

Hey everyone. I took over WSUS installed on an SCCM Server with the SUP role installed. WSUS was pretty FUBAR from years of neglect (updates never being declined/cleaned-up, no SQL database maintenance, etc.). I was trying to get Patch My PC installed and running, and after a week of wrestling...

I have download SQLEXPR_x64_ENU 2012 from Microsoft download center. When i am trying to install sql server and not getting all the features as mentioned in the below URL https://www.prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/ My server showing only attached...

Looking for some help with creating custom reports in SCCM not a DBA so I feel like a fish out of water. What I am trying to do is get a report that shows device by model, name, RAM, CPU and, OS. Any help would be great. Thanks.

I have installed SCCM and have the reporting role enabled. I can run reports from within SCCM but I am constantly being prompted for username and passwords when I try to access the reports from the reports manager URL. when I log into the web URL with my username and password, I am not able to...

Hello, Im facing a serious problem with my SCCM environment. We have a Primary site and several secondary Sites. After upgrading to 1802 I tried to upgrade a secondary site, this failed and that sec site lost his Database connection. I thought, Im removing the secondary and reinstall the...

SQL is getting full is there a tool or any other way to restrict how much drive space SQL will not suck up all available drive space?

Good Morning, A few days ago I noticed that the services for my SQL server with red and where not listed on the reports tab, so after I restarted them all seem fine. But now that I am trying to run report I an getting errors. Did my SQL got corrupted or what? HEre is a copy of the details that...

Hello Mr. Desai again, In restored (from backup) SCCM i have this - (Reports are not working) This was the state before my SCCM gone wrong, I changed account for Reporting role to SCCMReports account. - reports was working fine after this. And SCCMadmin had status not configured- I think...

ConfigMgr Error Object: instance of SMS_ExtendedStatus { CauseInfo = ""; Description = "SQL command failed: "; ErrorCode = 2168851714; File = "e:\\cm1606_rtm\\sms\\siteserver\\sdk_provider\\smsprov\\sspfolder.cpp"; Line = 1860; ObjectInfo = "Please check SMS Provider log file for details...

I am setting up a new Lab for SCCM and while installing the SCCM 2012 R2 setup remains at 'Setting up the SQL Server database'. Its been on the same window for more than 3 hours without any errors. I have already installed and configured SQL Server 2012 SP1 with no errors. While verifying the...

I have a weird situation and am completely stumped as to a resolution. To start with, my organization had their root CA cert expire on Monday and we had to recover from that over the week. It appears we are back in order, a new CA was stood up and all is well, all existing certs have been...

Hi Prajwal, I am getting the below attached error please help me on the same. Thanks, Lokesh .v

Hi, I have upgraded my SCCM 2012 R2 SP1 to SCCM Current Branch 1606 successfully. Then I wanted to do an in-place upgrade to the latest version, 1610. The prerequisites check gave me a warning. [Completed with warning]:Checks for supported SQL Server version I have one primary site with SQL...