WID is simply an instance of SQL Express built into the OS. There's really not an explicit downside to using it except that if the system already has SQL Server loaded you're adding a small amount of additional load.
J From: [email protected] [mailto:[email protected]] On Behalf Of John Aubrey Sent: Wednesday, October 15, 2014 9:54 AM To: '[email protected]' Subject: RE: [mssms] WID or Database for WSUS? I used the built in database. I was worried about SQL licenses. If I remember correctly I had it set up with SQL in a previous deployment and SCOM wasn't happy with it. Constantly throwing up alerts. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Justin Chalfant Sent: Wednesday, October 15, 2014 10:49 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] WID or Database for WSUS? WID is Windows Internal Database, DB would be using a SQL database. I generally install the WSUS database on the SQL server the site server is using rather than WID. Check this out: http://technet.microsoft.com/en-us/library/cc708452(v=ws.10).aspx Thanks, Justin Chalfant Premier Field Engineer - Configuration Manager Public Sector Microsoft Services Tel : (303) 846-2701 Email: [email protected]<mailto:[email protected]> If you have any feedback about my work, please let either myself or my manager Rusty Gray know at [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Wednesday, October 15, 2014 8:12 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] WID or Database for WSUS? What's the difference between WID and DB when configuring WSUS for SCCM? Does it matter which one is used? Thanks, Brian
