Jump to content


nguil

Established Members
  • Posts

    5
  • Joined

  • Last visited

nguil's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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 ?
  2. 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.
  3. 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.
  4. I forgot to mention that TCP dynamic ports are disabled on sql and I had fixed TCP port 1433. Thanks,
  5. 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,
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.