I am trying to install SCCM 2012 in my lab so I can test the upgrade from SCCM 2007. My server is Windows 2008 x64 R2 with SP1, and I've installed SQL 2008 x64 R2 Standard with SP1 and CU6 and configured a named instance.
When I run the system assessment, I get the following errors/warnings:
1. SQL Server service running account.
2. Verify site server permissions to publish to Active Directory
3. Required SQL Server Collation
4. SQL Server sysadmin rights
I think these are all bogus. My SQL services are using an AD user account, I have verified that my server account has full control of the System Management container AND descendent objects (that one has burned me more than once), I am using the SQL _Latin1_General_CP1_CI_AS collation, and Iam using my account to install SCCM and I know that I am a sysadmin. I fiddled around with these for a while and then assumed it was because I was using a named instance, so the assessment tool didn't know where to connect to test SQL.
I mention this all because when the SCCM installation tried to connect to SQL, it fails.
I receive an error stating "Setup is unable to connect to SQL Server with the connection information provided.
I have verified that I have entered the information correctly I ahve verified that my instance is not using dynamic ports. It's using 1433. I don't have a firewall, and I know that my account has sufficient permissions within SQL. I opened the SQL Management Studio and created a database just to make sure.
I CAN use a named instance with SCCM 2012, can't I? Or am I way off base with thinking it's my named instance?