blog post<\/a> about the same topic as my post here. There are some interesting configurations of SQL Server Communication Ports there. Following that post I change my SQL Server\u00a0to use static ports.<\/p>\nI also added the computer account of my new SCCM server to the logins inside Security >> Logins in\u00a0SQL Management Studio.\u00a0 My domain admin account was already there. I just needed to add the new SCCM server’s computer\u00a0account. It has to be manually typed in the following syntax:<\/p>\n
domain_name\\computer_name$<\/pre>\nsdaf<\/p>\n
I am going to try using the existing SQL server instance with SCCM 2012 and see what happens.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
During my testing of SCCM 2012, I determined that it needs a specific configuration of SQL server. This post tells you what needs to be done. I have a SQL server 2008 instance already installed for use with SCCM 2007. I was hoping I could use the same VM for SCCM 2012 testing. This post is in reference to that VM. Check out the official SQL server requirements list. Out of this I am listing my own experiences here: 1. Database collation: My SQL server has SQL_Latin1_General_CP1_CI_AS I also checked a few other DB servers,\u00a0they already\u00a0have the Database collation required by SCCM 2012 installed by default. So I did not have to change anything. 2. SQL Server features I did not check on this. I guess Database Engine Services is already there … Hey the DB works, so gotta be there, right! 3. Windows Authentication I checked the server properties inside SQL server management console. Server authentication was already set to “Windows Authentication Mode” 4. SQL Server instance Now this is something I am having trouble with. Why need a dedicated instance? I searched for some time on the ‘net but could not find any answer. Everyone just says that SCCM2012 needs a dedicated instance……but why does it need a dedicated instance? 5. SQL Server memory Wow 8 GB for SQL server! I don’t have any VM which I can assign 8GB to. This will surely be a problem. I came across this blog post about the same topic as my post here. There are some interesting configurations of SQL Server Communication Ports there. Following that post I change my SQL Server\u00a0to use static ports. I also added the computer account of my new SCCM server to the logins inside Security >> Logins in\u00a0SQL Management Studio.\u00a0 My domain admin account was already there. I just needed to add the new SCCM server’s computer\u00a0account. It has to be manually typed in the following syntax: domain_name\\computer_name$ sdaf I am going to try using the existing SQL server instance with SCCM 2012 and see what happens. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[37,40,29],"class_list":["post-244","post","type-post","status-publish","format-standard","hentry","category-itsys","tag-sccm-2012","tag-sql-server-2008","tag-system-administration"],"_links":{"self":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/comments?post=244"}],"version-history":[{"count":5,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/244\/revisions"}],"predecessor-version":[{"id":299,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/244\/revisions\/299"}],"wp:attachment":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/media?parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/categories?post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/tags?post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}