sql

Question 1

SCCM Sql Server Migration from 2021 to 2019

Question

Hi We currently have SCCM 2012 r2 with SQL 2012. We plan on upgrading the environment to new servers as we need to decommission the old physical servers. I have setup a new VM 2019 with SQL 2019, whats the best ...

in progress 0

Configuration Manager 1 year 1 Answer 357 views Beginner

Question 2

SQL Query for collection creation date, deployment name and enforcement state of endpoints

Question

Hello HTMDians, Help needed from all SQL Guru's in our forum. I have been trying to write one SQL Query where i need to fetch the compliance of the collection along with the enforcement state of each servers inside the collection and ...

solved 0

Configuration Manager 1 year 3 Answers 312 views Admin

Question 3

I need to create a sql query to find out bios details of a single machine, help me as i do not have any sql experience.

Question

i came across a script online now i want to know if i edit the machine name with the one i have will give me result of that particular machine or will it bring result of machine in my environment Select

solved 0

Configuration Manager 2 years 7 Answers 669 views Beginner

Question 4

CMG DNS CNAME question

Question

Hi I am currently doing a CMG deployment on 2010 release of MECM. The pre-reqs have been completed to the best of my knowledge and the deployment of Azure services/MECM integration and CMG has gone well. Client settings have been updated ...

solved 0

Configuration Manager 2 years 2 Answers 428 views Beginner

Question 5

Where is SQL express on MECM media?

Question

Hi All Am I right in thinking that MECM 2002 does come with a flavour of SQL express on the same media or does this need to be downloaded separately? In the past I have downloaded and installed SQL on a separate ...

solved 0

Configuration Manager 2 years 4 Answers 37 views Beginner

Question 6

All clients are shown as offline (gray icon). In bgbserver.log: SMS_NOTIFICATION_SERVER errors for ssl and sql

Question

Hi! =) Recently I made settings for PXE and sccm site configuration (https communication clients), these edits did not help and I returned everything back. But from that moment on, all clients turned gray and errors appeared in the logs:

solved 0

Configuration Manager 2 years 1 Answer 409 views Beginner

Question 7

Hi, for SQL Server reporting services 2019 which product we should choose under VLSC portal in order to get license key ??

Question

Hi, for SQL Server reporting services 2019 which product we should choose under VLSC portal in order to get license key ??

solved 0

Configuration Manager 2 years 2 Answers 292 views Beginner

Question 8

Software Update Group Patch Status

Question

Hi Team. Currently he gave the client a patch status report of the month, where he shows me all the computers and their different patch status (Installed, Not required, Error, in progress, pending restart or unknown status).

solved 0

Configuration Manager 3 years 3 Answers 113 views Beginner

Question 9

SQL on same server or remote for MECM and WSUS

Question

Hi All Wanted to bounce my thoughts with fellow members. I am about to embark on a mini project for a customer. It's for a small experiment and a new network and infrastructure environment will be created on-premises. Unfortunately for this piece ...

solved 0

Configuration Manager 3 years 1 Answer 147 views Beginner

Question 10

SQL Reporting services 2017 – Unable to select instance ID

Question

Hi Team, I had installed SQL 2017 with default instance "MSSQLSERVER" in my testing lab for SCCM 1902 setup, while installing reporting services 2017, it automatically creating one instance as "SSRS", without selecting default one. Because of this I can't able ...

in progress 1

Configuration Manager 3 years 3 Answers 107 views Beginner

Register Now

Login

Lost Password

Login

Register Now

sql