Skip to content

SCCM 2012 Site Database on SQL Cluster

Featured Replies

I have installed two node clustered SQL Server 2008 R2 with SP1 & CU4 updates on Windows Server 2008 R2.

I have used SQLAdmin domain user (i know i should have installed with SCCMAdmin but our requirement is that I cannot use other than SQL service account).

Per Part 1 document I have set firewall settings for TCP 1433 and 4022 via GPO.

 

I have SCCMAdmin domain user trying to install SCCM 2012. Log shows:

"creating sql connectionn to database sqlinstance\master on SQLclustername.mydomain.loc"

 

and get a popup msg as "Setup is unable to connect to SQL Server with the connection information provided. Verify the following:"

 

I have added SCCMSvrs (group which has all sccm computer accounts) and sccmadmins (group) to Local Administrators group in SQL nodes. Also, I have added SCCMAdmin account in SQL Instance as sysadmin. Still no go.

 

Please help.

 

Thanks

  • Author

Interesting … leaving blank on instance name textbox ...took to next screen. But that's not default instance? So what does default stands ONLY ONE instance?

  • Author

post-12861-0-45584000-1334252804_thumb.png

 

ConfigMgrPrereq.log

 

What am I missing?

 

Initially AD permission didn't show up but second run showed AD issue. Why? I did delegate again for system mgmt. container but this warning remains.

  • Author

resolved:

You do need to provide instance but in order for it to work you need to remove dynamic ports. restart sql service. entry see below:

 

post-12861-0-76696200-1334258426_thumb.png

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.