?
Solved

Cant install System Center 2012 R2 Configuration Manager

Posted on 2013-11-26
4
Medium Priority
?
1,028 Views
Last Modified: 2014-04-08
I've gone though half the steps to install System Center 2012 R2 Configuration Manager, but I cant get passed the SQL Server settings.

I can connect to the SQL Server in question via ODBC and Windows firewall is off on both servers.  They are also on the same subnet, so no physical firewalls are in between.

Here is the error:

Install Blocker
0
Comment
Question by:FSIFM
  • 3
4 Comments
 
LVL 7

Expert Comment

by:valmatic
ID: 39677889
I had some connectivity issues too. This guide helped me maybe it can get you looking in the right direction. What a vague error. The usual for microsoft i guess.
http://blogs.msdn.com/b/scom_2012_upgrade_process__lessons_learned_during_my_upgrade_process/archive/2012/07/04/configuration-manager-2012-setup-error-_3a00_-setup-is-unable-to-connect-to-sql-server-with-the-connection-information-provided.aspx
0
 
LVL 4

Author Comment

by:FSIFM
ID: 39678066
Unfortunately that's only made things worse for me now.  Since changing all the TCP Dynamic Ports be blank and configuring all the TCP ports in the...

SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for Named_Instance > TCP/IP > IP addresses

...  I now find that the 'SQL Server (Instance Name)' service doesn't start.  At first it complained that the user did not have logon as a service right, so I change the account for 3 related services for the instance name and its now giving the following error in the event log.

'Event ID  7024:
The SQL Server (My Instance Name) service terminated with service-specific error Only one usage of each socket address (protocol/network address/port) is normally permitted..'

Here's how I have configured the TCP settings..

SQL Service TCP Settings
If I change the TCP settings back to the Dynamic values, the services then start, but only if I leave the services accounts with an account that has Logon as a service right.  Changing back to the NT Service\MSSQL$Instance doesn't work now as well.
0
 
LVL 4

Accepted Solution

by:
FSIFM earned 0 total points
ID: 39974780
I gave up in the end.  Too much other stuff on my plate, so I went for good old WSUS.
0
 
LVL 4

Author Closing Comment

by:FSIFM
ID: 39985488
No answer given, so closed call as its become low priority for me.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question