question

KarunKhanna-4030 avatar image
0 Votes"
KarunKhanna-4030 asked saldana-msft edited

SCCM SQL installation for SCCM Build

I need to install sccm for test env. i am proposing in-built sql. but now client is saying can we put the sccm sql instance on another application sql server as it will save the license cost.

Can you please advise the best way to go about it with few pros and cons. Thanks.

mem-cm-generalmem-cm-site-deployment
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexZhu-MSFT avatar image
0 Votes"
AlexZhu-MSFT answered GarthJones-8673 commented

Hi,

Sure, it works. We can create a new instance for configuration manager on the server (that is already running multiple instances for other products) if the performance is ok. Configuration Manager doesn't care about this.

If we choose all-in-one deployment (the sql and sccm in the same server), the advantage is that we have better control of the database.

Alex
If the response is helpful, please click "Accept Answer" and upvote it.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

does sql license free with sccm?
as i am using for test env with 300 machines, is there a sql version like standard which we can use or as we are using it for our organization it has to be a paid license?

0 Votes 0 ·

Yes CM does come with it own SQL lic. and yes it is generally not recommend to share CM's SQL server with any other apps. Only SQL standard is included with CM.

0 Votes 0 ·

So i need to install SQL before installing SCCM, how will it detect that the sql standard i am installing is licensed.
also, any drawbacks for using standard instead of enterprise?

0 Votes 0 ·
Show more comments
AlexZhu-MSFT avatar image
0 Votes"
AlexZhu-MSFT answered Anoop-C-Nair-MVP commented

Hi,

To check the license information, we can run below query in the SSMS and check SQLEdition field, as highlighted in the following screenshot. If not licensed, word "Evaluation" will appear in this field.


112002-sql-license-info.png

 SELECT SERVERPROPERTY('LicenseType') as Licensetype, 
        SERVERPROPERTY('NumLicenses') as LicenseNumber,
        SERVERPROPERTY('productversion') as Productverion, 
        SERVERPROPERTY ('productlevel')as ProductLevel, 
        SERVERPROPERTY ('edition') as SQLEdition,@@VERSION as SQLversion

As GarthJones said, if the sql instance is only used by SCCM, the license is included. For test environment, standard edition is enough. Enterprise edition provides additional features and should be opted for large companies. Description from MS official article, for your reference:

Enterprise: The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization1, and end-to-end business intelligence - enabling high service levels for mission-critical workloads and end-user access to data insights.
Standard: SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premises and cloud - enabling effective database management with minimal IT resources.

Alex
If the response is helpful, please click "Accept Answer" and upvote it.



· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the response, very helpful.

One last question : i have asked the procurement team to download the iso for SCCM 2002 from VLSC. once the file is downloaded, before installing i need to install SQL. so should i just download sql standard from internet and install on my primary, what to do on page where it asks for product key (as sql standard is free for sccm) ?

0 Votes 0 ·

Your procurement team can get you the SQL lic key from VLSC too. It is the same key for all SQL instances.

0 Votes 0 ·

i didnt understand, sorry just trying to understand how is the sql standard is free. Client told me that he doesnt want to pay so if standard is free with sccm then feel free to use. But i am not able to understand how to install sql, i have got the iso for sccm from the client via VLSC.

can i download the sql standard from internet (evaluation) and install on sccm server, wil lit automatically detect that sccm is being installed and will not expire after 180 days.

0 Votes 0 ·
Show more comments