kris00l Posted April 11, 2012 Report post Posted April 11, 2012 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 Quote Share this post Link to post Share on other sites More sharing options...
kris00l Posted April 11, 2012 Report post Posted April 11, 2012 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? Quote Share this post Link to post Share on other sites More sharing options...
kris00l Posted April 12, 2012 Report post Posted April 12, 2012 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. Quote Share this post Link to post Share on other sites More sharing options...
kris00l Posted April 12, 2012 Report post Posted April 12, 2012 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: Quote Share this post Link to post Share on other sites More sharing options...
