Hi All,
I was trying to
install System Center 2012 SP1 Configuration Manager on Server 2008 R2 OS. During
the installation i encountered an issue with SQL Server connectivity. I was
quite surprised to see this error because I installed the SQL on same server
where I was installing the SCCM2012. I followed all the steps that were given
in document. To find out what was wrong I started checking the reasons that
were suspected On the Database Information wizard screen.
Setup is unable to
connect to SQL Server with the connection information provided. Verify
the following:
1. The SQL
Server and instance names are entered correctly
2. The
specified SQL Server instance is not configured to use dynamic ports
3. If a
firewall is enabled on the SQL Server, inbound rules exist to allow connections
to the correct ports
4. The
account used to run Setup has permissions to connect to the specified SQL
Server instance
As you can see it has
given me few details to check with. And then I started checking everything 1 by
1.
For the first issue, I
was sure that it could not be the issue because I used the default instance and
not the custom one, so now one down…
For the second issue,
SQL Server instance is not configured to use dynamic ports 
what that means!! Lol This was the
issue…. I will talk about in next step
what that means!! Lol This was the
issue…. I will talk about in next step
For the third issue I
have manually created Firewall Port exception. Also SQL Server was the same
server on which I was installing sccm 2012 so big no to this point.
For the last issue I
have used the default system account that SQL Server 2012 configured so this
was also ruled out.
Now, let’s come back
to Point 2 i.e. The specified SQL Server instance is not configured to
use dynamic ports. In this example, this is the reason we are getting the
error when using the Named Instance. Also “Named pipes” was disabled I enabled it as well. J to avoid further MP communication issue J
Here is the Resolution :
1. Open
the SQL Server Configuration Manager console
3. In SQL
Server Configuration Manager, expand SQL Server Network
Configuration. Click on Protocols for SCCM(SCCM is your Named
Instance)
In the right side pane, right click on the TCP/IP
(Status Enabled) and click on Properties
5. In that
click on IP Addresses tab. Scroll down to the bottom &
make a change to IPALL. TCP Dynamic Ports -> Blank. TCP Port -> 1433 (as
this is our default port for SQL Server Database Connection). Click on Apply.
6. And
notice that you need to restart SQL Server (SCCM) Service..
7. To
restart a service. Click on SQL Server Service. Right click on
Instance Name: SQL Server (SCCM) and click on Restart.
Wait for few seconds.
After that setup SCCM 2012 installed and I was happy to see the 2012 console. J
Hope This Will Help!!!
Amarpal Singh
