SCCM 2012 sp1 setup issue with sql 2008 R2

[nguil]

Hi all,

 

I have an error with the required version of sql server when I install SCCM 2012 SP1.

see attach files.

 

But the version of the sql server is 2008 R2 64bits SP1 CU 6.

 

The account which I use to install sccm 2012 is local administrator of sccm server and sql server.

And this account is sysadmin in sql.

 

Here is the ConfigMgrSetup.log :

 

CWmiRegistry::GetStr: Failed to get string value MSSQLSERVER $$<Configuration Manager Setup><03-21-2013 22:31:20.007-60><thread=2192 (0x890)>

Failed to retrieve SQL Server instance name[MSSQLSERVER]. $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

WARNING: failed to retrieve port number for 20ssql.xxxxx.com . $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

WARNING: failed to retrieve port number for 20ssql.xxxxx.com . $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

INFO: Registered type 20SSQL.XXXXX.COM MASTER for 20SSQL.XXXXX.COM master $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

INFO: Registered type SMS Master for 20SSQL.XXXXX.COM master $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

INFO: Registered type 20SSQL.XXXXX.COM SCCM for 20SSQL.XXXXX.COM SCCM $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

INFO: Registered type SMS ACCESS for 20SSQL.XXXXX.COM SCCM $$<Configuration Manager Setup><03-21-2013 22:31:20.060-60><thread=2192 (0x890)>

*** [08001][14][Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. $$<Configuration Manager Setup><03-21-2013 22:32:29.153-60><thread=2192 (0x890)>

*** [01000][14][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()). $$<Configuration Manager Setup><03-21-2013 22:32:29.153-60><thread=2192 (0x890)>

*** Failed to connect to the SQL Server, connection type: 20SSQL.XXXXX.COM MASTER. $$<Configuration Manager Setup><03-21-2013 22:32:29.153-60><thread=2192 (0x890)>

*** [08001][14][Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. $$<Configuration Manager Setup><03-21-2013 22:33:39.185-60><thread=2192 (0x890)>

*** [01000][14][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()). $$<Configuration Manager Setup><03-21-2013 22:33:39.185-60><thread=2192 (0x890)>

*** Failed to connect to the SQL Server, connection type: 20SSQL.XXXXX.COM MASTER. $$<Configuration Manager Setup><03-21-2013 22:33:39.185-60><thread=2192 (0x890)>

 

 

sccm server : win 2008 R2 std SP1

sql server : win 2008 R2 std SP1

 

I tryed to install on sql 2008 R2 SP2 with the same result.

 

I installed the management studio on the sccm server and I connect to the remote sql with no problem.

 

Have you an idea where is the trouble ?

 

Thanks,

[nguil]

I forgot to mention that TCP dynamic ports are disabled on sql and I had fixed TCP port 1433.

 

Thanks,

[Oneone]

SP2 with CU9 tryed that?

[nguil]

For sql 2008 R2 SP2, I think the upper is CU 5.

I already tryed with sql 2008 R2 SP2 CU4, without success.

Another detail is my sccm server is a primary site which join existing hierarchy.

[anyweb]

is SQL on the primary or remote, is it using the default instance or another one ?

[nguil]

Hi anyweb,

the SQL is remote and I've use the default instance which I've rename.

I've add sysadmin the SCCM server on sql security, but with the same result.

Thanks for your help.

[anyweb]

and how are you specifying the remote SQL server and instance in the dialog ?

[nguil]

I've put the SQL server name (FQDN) : 20ssql.domain.com, and I didn't put Instance name because I've used the default instance.

I enter a name for the database, and I keep the port 4022 for Service Broker Port.

Is it correct ?