Remove From My Forums

WSUS: WID vs SQL

Question
0

Sign in to vote

We have 6000 clients + 200 servers. We need to deploy SUP. We infrastructure is:

1xVM: SQL Server 2014

1xVM: Primary Site Server

4xVM: Distribution Poins

We're going to deploy extra VM por SUP....my question is:

Where is better locate WSUS DB ?? in this extra VM (WID) or SQL Server ??

Monday, October 24, 2016 9:01 AM

Answers

1

Sign in to vote
It depends on the "Hardware" specs, but why not using the primary or a DP to host the SUP (using the existing SQL server)?
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 9:15 AM
0

Sign in to vote
You should you SQL and not wid.

Yes the lic covers Uses.But only if it is used for cm.

Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Edited by Garth JonesMVP Monday, October 31, 2016 3:09 PM typo
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 11:25 AM
0

Sign in to vote
You can install SUSDB (being used by SUP/WSUS) on the SQL Server that's licensed by the CM license.
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 12:33 PM
0

Sign in to vote
Licensing is certainly something that you the customer must account for and so it's ultimately your choice here; however, the answer to this question often depends upon who you ask at Microsoft. We (the MVPs) have recently brought this up again with Microsoft and finally received the opposite answer through official channels.
Jason | http://blog.configmgrftw.com | @jasonsandys
- Proposed as answer by Garth JonesMVP Monday, October 31, 2016 3:10 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 31, 2016 2:09 PM

All replies

1

Sign in to vote
It depends on the "Hardware" specs, but why not using the primary or a DP to host the SUP (using the existing SQL server)?
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 9:15 AM
0

Sign in to vote

It's other option...so

1) is better use SQL that WID ?

2) Does SCCM license cover SQL Licence If I use SQL Server for WSUS ??

Monday, October 24, 2016 9:26 AM
0

Sign in to vote
You should you SQL and not wid.

Yes the lic covers Uses.But only if it is used for cm.

Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Edited by Garth JonesMVP Monday, October 31, 2016 3:09 PM typo
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 11:25 AM
0

Sign in to vote

I'm not sure about the licensing....

There are 2 products on that SQL: SCCM and WSUS although it is true that SCCM use WSUS...

Monday, October 24, 2016 12:31 PM
0

Sign in to vote

What about using SQL Express ??

Monday, October 24, 2016 12:32 PM
0

Sign in to vote
You can install SUSDB (being used by SUP/WSUS) on the SQL Server that's licensed by the CM license.
Torsten Meringer | http://www.mssccmfaq.de
- Proposed as answer by Jason Sandys [MSFT]MVP Monday, October 24, 2016 1:02 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 24, 2016 12:33 PM
0

Sign in to vote

We've done a question to microsoft. System Center doesn't cover this WSUS SQL License

So, we'll to use WID....

Actually our WSUS Database size is 4 GB....any problem to use WID for it ??

Monday, October 31, 2016 2:04 PM
0

Sign in to vote
Licensing is certainly something that you the customer must account for and so it's ultimately your choice here; however, the answer to this question often depends upon who you ask at Microsoft. We (the MVPs) have recently brought this up again with Microsoft and finally received the opposite answer through official channels.
Jason | http://blog.configmgrftw.com | @jasonsandys
- Proposed as answer by Garth JonesMVP Monday, October 31, 2016 3:10 PM
- Marked as answer by Jimmy LSMicrosoft contingent staff Monday, November 7, 2016 1:59 AM
Monday, October 31, 2016 2:09 PM
0

Sign in to vote

Microsoft answer:

Customer may run any number of Instancesof any SQL Server database software included in the Product in one OSEonly for the purpose of supporting that Product and any other Product that includes SQL Server database software.

The part highlighted in yellow covers Configuration Manager and its component. The part highlighted in green covers other products. If we apply the above, we have the following:

1) Is WSUS a component of Configuration Manager?

--No

2) Does WSUS falls under other Products?

--Yes

Does WSUS include SQL Server Technology?

--No

The end result is no for both (1) and (2); therefore, you can't use SQL Server Technology provided through System Center Configuration to support WSUS.

Monday, October 31, 2016 2:20 PM
0

Sign in to vote

Microsoft answer:

Customer may run any number of Instancesof any SQL Server database software included in the Product in one OSEonly for the purpose of supporting that Product and any other Product that includes SQL Server database software.

The part highlighted in yellow covers Configuration Manager and its component. The part highlighted in green covers other products. If we apply the above, we have the following:

1) Is WSUS a component of Configuration Manager?

--No

2) Does WSUS falls under other Products?

--Yes

Does WSUS include SQL Server Technology?

--No

The end result is no for both (1) and (2); therefore, you can't use SQL Server Technology provided through System Center Configuration to support WSUS.

Is WSUS need by CM? Yes and therefore it is license by the SQL license for CM.

Without WSUS you CAN'T use the SUP feature of CM and therefore it is a component of CM. and Therefore it is licensed by the CM SQL.

Like Jason state, we have gotten the exact opposite answer. There was a suggestion that the Lic team will even create an official blog post on the subject too.
Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

Monday, October 31, 2016 3:13 PM
0

Sign in to vote

Any URL, blogs, etc....where I can see Microsoft Lic Team talking about this situation ??

I need extra official information...because in our first question to Microsoft....They want to charge for our SQL Cores !!!!!! In this situation I'll use WID....

Monday, October 31, 2016 3:54 PM
0

Sign in to vote

Any URL, blogs, etc....where I can see Microsoft Lic Team talking about this situation ??

I need extra official information...because in our first question to Microsoft....They want to charge for our SQL Cores !!!!!! In this situation I'll use WID....

Working on it... Well I should say Jason (he beat me to it) pointed the licensing team to this thread, so....
Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

Monday, October 31, 2016 4:08 PM
0

Sign in to vote

Any update of Microsoft licensing team ?

Wednesday, November 9, 2016 7:52 AM
0

Sign in to vote

Any update of Microsoft licensing team ?
everything will need to go thought legal teams and that will take a while.
Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

Wednesday, November 9, 2016 2:03 PM
0

Sign in to vote

Any update of Microsoft licensing team ?

Please post you question to this docs site.. https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/support-for-sql-server-versions
Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

Thursday, November 10, 2016 10:49 PM

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Answered by:

WSUS: WID vs SQL

Question

Answers

All replies