Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
Solved
Cant install System Center 2012 R2 Configuration Manager
Posted on 2013-11-26
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:
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:
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
4 Comments
Active 3 days ago
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
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
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..
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.
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..
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction:
Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem. So I resorted to Goo…
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 tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month12 days, 7 hours left to enroll
650 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.