Search the Community
Showing results for tags '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 'm... -
I have inherited an SCCM 2211 environment that was supposed to have been setup in HA, but it was not fully configured (no passive site node). I'm a bit stumped with how the SQL AOG has been configured and the person that built it is no longer around. In the past when setting up HA, I would setup the... -
Hi All, I was wondering if someone could give me some pointers to a HowTo Guide for SQL 2016 Always-On. I've been using a guide from sqlrx.com which has brought me to a point but it's not complete idiot proof obviously as I'm stuck.. I've created the AG - Availability Group and I've b...
-
Following along in the documentation, I get to where I want to install the Reporting Services Point Role. Figure no big deal. In walking through the steps of role setup everything is great until I go to dropdown the selection for the Reporting Server Instance. It does not see the reporting serv... -
Hello, We are just starting down the path of SCCM and building out a DEV environment. Will install 1702 then upgrade to 1710 and then possibly 1802. Looking at the Hardware and Server requirements wondering if anyone could shed any light into their builds. There are a number of posts out there... -
Hi All, I hope you are well, Currently I have an issue I have unsuccessfully been battling with for a few days now. The original plan was to have the sccm db running on a sql high availability always on group setup. 1 x primary server 1 x sup server 1 x dp server 2...
-
I am in the process of upgrading our SCCM infrastructure from Svr2008R2 and SQL2008R2 to 2012R2 so I can upgrade to current branch. We are doing in-place upgrades, to 2012R2 on our Primary Site and also our separate DB server. Our DBA is going to start by upgrading our SQL version to 2014 on the b...
-
Just a tip or something to be aware of. One of my admins pointed out they were running low on disk space on the drive where the SQL server was installed. Turns out that by default the ReportServer DB log file is set to grow to 2TB by default! Went into SSMS and changed the ReportServer DB to "simple...
-
Error with Database replication link after expanding primary standalone to CAS with primary. Replicator link analyzer says the sql server boker login is missing. -
I am trying to add a CAS to a stand along primary server and I get to the point where it is asking for the Path to the SQL Server data file and the Path to the SQL Server Log file, but doesn't proceed any further. If the SQL server is remote, does it still use a local C:\... path, and would it be th...
-
Hi All. Long time lurker here but now is the first time I have been moved to create an account and ask for some advice. I’m looking for a bit of direction on how to proceed as I’m a bit stuck, I’d like to fix this without breaking anything else in SCCM. I’m running SCCM build 1606 –... -
Hello all, I've ran into a few issues with SCCM 2012 R2 SP1, I have a remote 2 node SQL cluster, essentially one of the nodes failed a few months ago so it's been online for a while, during this time the SCCM DB was moved to this cluster, today the 2nd node is now online so I was expecting that...
-
Hello, I'm new to SQL and I need help understanding the best approach to our current problem. I need to build a custom parameter-based report in Microsoft SQL Report Builder 3.0 where you select two or more collections as parameters. The report should then cross reference which computers exist in a...
-
As part of our companies SCCM 2012 design process, I'm tasked with attaining some network traffic modelling for a CAS design and a single Primary Site design. Scenario: 10,000 managed devices spread in over 22 locations globally 1x CAS 2x Primary Sites (5,000 devices per site) What would the... -
Hi all, I've my lab setup running under two servers (SCCM server and SQL server). I did this to keep the environment as equal as other environments where I work with. However, I need more space (hdd) and maybe this will also help me to gain some performance. I want to install the a new insta...
-
Hi guys, Planning to upgrade our configmgr to 2012r2SP1 but first wanted to check with you what's the minimum supported SQL version, currently running 2008 R2 SP1 CU9, any help please? thanks, MW -
Hey everyone, especially Niall, thank you so much for this community. It's been a great help! I am standing up a new SCCM 2012 R2 server and am setting it up with the plan to deploy SUS updates from SCCM (currently using a standalone WSUS server in our environment). We are running the SQL serv...
-
Hello, I am trying to move the database from a SQL 2008 R2 cluster to SQL 2014 cluster. Our current set up is: Windows 2008 r2, SCCM 2012 (cu2 only, planing to upgrade to 2012 R2 as soon as DB is working), SQL 2008 r2 SP3. I took a backup of the DB on the old cluster, restored in the new o...
-
I am attempting to write a powershell script for our 2012 SP1 environment that well ask for the input of a package ID and it will prestage its dependencies all in separate pkgx files so it is easier to tell what has already been pre-staged. Each dependency will be named by package ID. I have th... -
SCCM 2012 R2 Console unable to Connect its SQL 2012 Database
angurpatel posted a question in How do I ?
Trying to connect Config Manager CAS Console to its SQL database and getting error (Screenshot 1). Also SMS_EXECUTIVE and other SMS Services could not Start (Screenshot 2). Getting one of the event error as - License Activation (slui.exe) failed with the following error code: hr=0x800705B4 I can...
-
Hi Forum, Please help! Here's the story. When we had our SCCM installed it seems that some bright spark decided to put a trial version of SQL on the server its installed on. Last week the trial ran out and reporting stopped and then no one could connect via the consoles. Our apps team fixed... -
Hello All, I'm looking for a query or report that will return the network information for all systems or all machines in a collection. Our environment unfortunately still uses wins and I need to see how many machines out in the wild might be missing their secondary wins server address. Googl...
-
Hi All, environment: SCCM 2012R2 / SQL 2008R2 Could someone please advise re solving the problem? Just followed all the steps to apply CU4 for ConfigManager/SQL but when it comes to updating SQL i’m getting following errors: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure ‘k...
-
Hi All, I am currently managing a production SCCM R2 CU2 server with an SQL 2012 site database server and reporting services point and I have the Site System status for the SQL component server role listed as critical under System Status\Site Status. I suspect its a bug but I just want to get some... -
I am looking for a query that finds all computers joined to the domain since XX date. I tried using the query below which looks back over the last week for new computers but this also discovers any computers that have been modified in the last 7 days. Does anyone have a query that is based on date...
