Installing SQL locally question regarding SPN
Im going to install SCCM and the SQL database locally on the SCCM server. 2 questions here: 1. Is there any gotchas with installing SQL locally with the site server I should know about: (FYI, I queried our Microsoft TAM on this and they stated 98% of SCCM installations are involved with SQL being installed on the site server) 2. What is the proper way to setup the SPN with the database locally? Just want to ensure that I have all the information before I move forward with the total installation. Thanks in advance!jshely
October 25th, 2010 6:40pm

The preferred method for most if to have SQL locally. No SPN is needed if you run the service as the system account. If you run it as a domain user you need a SPN added. Here's the how-to http://technet.microsoft.com/en-us/library/bb735885.aspx John Marcum | http://myitforum.com/cs2/blogs/jmarcum |
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2010 9:22pm

If your SQL Server is local, that's local to all the roles including reporting and the MP also, you don't actually need an SPN.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
October 25th, 2010 10:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics