OK,,
Do the following steps since you are going to install a new WSUS on server 2012. It does not matter its SQL 2012 OR SQL 2012 SP1.. Its working with SQL 2012 sp1 as well.
1- Add the WSUS as a Role Service select the WSUS Service
and Database.
2- Then on the Content Location give the Location to download the contents. (Make sure you have enough Disk space and the Drive is formatted in NTFS.)
3- Once the WSUS role completely added under the server manager Notification pane
it will show additional configuration required and just select it and click run to configure the required settings. It will create the necessary WSUS content files with the required permissions. (It will create TWO folders
named as UpdateServicesPackages and WsusContent)
4- Now once it completed you have completed the installation of WSUS Server.
5- Then Don't DO Any Configuration in WSUS server. we have to do all settings using SCCM sever.
6- Open the SCCM SP1 console and Go to Overview/Site Configuration/Sites. Then
right click the server and select the Add Site System Roles.
7- On the General Page make sure you selected the correct server and under Active Directory Membership the indicating details are correct an click Next to continue.
8- Under proxy setting key in the proxy server setting if you have any proxy in your environment and click next to continue.
9- on the next page will be the System Role Selection select the Software Update Point and Click Next
10-Under Software Update Point Click the Second option for WSUS to use Ports 8530 and 8531
for client communication. (This is the default setting for WSUS on Server 2012). Click Next.
11- If you use Proxy server specify the details on the proxy and Account Setting Page to communicate the SUP role with Proxy server. Click Next
12- On the Synchronize Source page select the Synchronize from Microsoft Update Server. Click Next.
13- On the Synchronizing Schedule page schedule as you want.
14- On the Supersedence Rules leave the default setting as it is and click Next
15- Under classification page select the classification you want t download and click next
16- On the products page select the products and click next.
17- select the language as you want and click next
18- on the summary page just verify the configuration you have done and click next to install the SUP role installation and once it done close the window.
19- Go to Overview/Site Configuration/Servers and Site System Roles and make sure the SUP role is showing under the Site system Roles the right hand site pane.
20- Check the System Status UNDER Monitoring page and Open the Trace Log Tool and Open the Log call
WSUSCtrl and verify the connectivity is success in WSUS and SCCM.
21-Once it success go to Software Library/Software Update/ Right Click on top of All software
Updates and click Synchronize Software Updates.
22- again go to Trace Log tool and open the WSYNCMGR.LOG and check the synchronization is successfully processing.
23- After the Sync is complete just open the All Software Update field and the right hand side you can see the downloads.
Thanks
Hasitha