I want to put the sccm database on an external SQL server. Before that I need to install WSUS on the sccm-to-be server. Can I put the WSUS database locally or on the same SQL server externally? what are the advantages and disadvangates of these two setups? thanks in advance

Technically doesn't matter. The WSUS database itself does not get very big and is relatively low overhead. If you are already planning on using an remote SQL Server, I would recommend you go ahead and use it. A question that many will bring up though is why are you using a remote SQL Server? It is only required for very large sites and even then complicates setup and troubleshooting of issues. Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

Technically doesn't matter. The WSUS database itself does not get very big and is relatively low overhead. If you are already planning on using an remote SQL Server, I would recommend you go ahead and use it. A question that many will bring up though is why are you using a remote SQL Server? It is only required for very large sites and even then complicates setup and troubleshooting of issues. Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys

Thanks! And a very good question. I agree using a remote SQL server brings complicacity. The reasons when we decided were 1. to reduce the work load of the site server; 2. reduce one SQL license which is expensive. But if you have good advices I would like to hear.

Thanks! And a very good question. I agree using a remote SQL server brings complicacity. The reasons when we decided were 1. to reduce the work load of the site server; 2. reduce one SQL license which is expensive. But if you have good advices I would like to hear.

You can purchase SCCM with SQL bundled and save that license cost. In the grand scheme of things that extra little money is well worth the headache you are going to save by keep SQL local. John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

I hope you know that Best Practices is to keep SQL local.. http://technet.microsoft.com/en-ca/library/bb735870.aspx Best Practices for SQL Server Use a dedicated SQL Server for each site Do not use the Configuration Manager site database server to run other SQL Server applications Configure SQL Server to use Windows authentication Install Configuration Manager and SQL Server on the same computer Follow security best practices for SQL Server, noting the following issues: · The site server computer account must be a member of the Administrators group on the computer running SQL Server · If you install SQL Server using a domain user account, you must ensure that a Service Principal Name (SPN) is populated to Active Directory Domain Services http://www.enhansoft.com/

Hi, It's OK to use a remote databse as your SCCM and WSUS databse, before the installing, please take a look at following articles: Using a Remote SQL Server to Host the Site Database http://technet.microsoft.com/en-us/library/bb681007.aspx How to Install Configuration Manager Using a Remote SQL Server http://technet.microsoft.com/en-us/library/bb693554.aspxPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.