Link to home
Create AccountLog in
Avatar of rdefino
rdefinoFlag for United States of America

asked on

SQL 2012 "TESTDBUPGRADE " is failing

I'm trying to test my sccm 2012 DB upgrade and in the log I getting a conntection failure.

I built a new test server 2012 R2 running sql 2012. Same version as my sccm server.
I copied the DB over and atteched it to the test sql.
then I ran "setup.exe /TESTDBUPGRADE cm_sjc"

Now I see the following in the C:\ConfigMgrSetup.log

~~===================== << Starting Configuration Manager 2012 Setup >> =====================  $$<Configuration Manager Setup><10-16-2015 10:21:29.059+420><thread=2864 (0xB30)>
INFO: ConfigMgr2012 Setup was started by GLOBAL\rdefino-a.  $$<Configuration Manager Setup><10-16-2015 10:21:29.060+420><thread=2864 (0xB30)>
INFO: Command line specified was: "SetupWpf.exe"  /TESTDBUPGRADE cm_sjc  $$<Configuration Manager Setup><10-16-2015 10:21:29.060+420><thread=2864 (0xB30)>
~FQDN for server SCCM-SQL-TEST is sccm-sql-test.global.<domain_name>.com  $$<Configuration Manager Setup><10-16-2015 10:21:29.062+420><thread=2864 (0xB30)>
INFO: Target computer is a 64 bit operating system.  $$<Configuration Manager Setup><10-16-2015 10:21:29.166+420><thread=2864 (0xB30)>
INFO: Checking for existing setup information.  $$<Configuration Manager Setup><10-16-2015 10:21:29.166+420><thread=2864 (0xB30)>
INFO: Checking for existing SQL information.  $$<Configuration Manager Setup><10-16-2015 10:21:29.166+420><thread=2864 (0xB30)>
INFO: Verifying the registry entry for Asset Intelligence installation  $$<Configuration Manager Setup><10-16-2015 10:21:29.167+420><thread=2864 (0xB30)>
INFO: Setting the default CSV folder path  $$<Configuration Manager Setup><10-16-2015 10:21:29.167+420><thread=2864 (0xB30)>
INFO: No language packs detected.  $$<Configuration Manager Setup><10-16-2015 10:21:29.168+420><thread=2864 (0xB30)>
INFO: Configuration Manager Build Number = 7958  $$<Configuration Manager Setup><10-16-2015 10:21:29.215+420><thread=2864 (0xB30)>
INFO: Configuration Manager Version = 5.0  $$<Configuration Manager Setup><10-16-2015 10:21:29.215+420><thread=2864 (0xB30)>
INFO: Configuration Manager Minimum Build Number = 800  $$<Configuration Manager Setup><10-16-2015 10:21:29.215+420><thread=2864 (0xB30)>
INFO: Verifying Configuration Manager Active Directory Schema Extensions.  $$<Configuration Manager Setup><10-16-2015 10:21:29.215+420><thread=2864 (0xB30)>
INFO: Found DS Root:CN=Schema,CN=Configuration,DC=dr,DC=<domain_name>,DC=com~  $$<Configuration Manager Setup><10-16-2015 10:21:29.228+420><thread=2864 (0xB30)>
INFO: Verifying Configuration Manager Active Directory Schema Extensions.  $$<Configuration Manager Setup><10-16-2015 10:21:29.230+420><thread=2864 (0xB30)>
INFO: Found DS Root:CN=Schema,CN=Configuration,DC=dr,DC=<domain_name>,DC=com~  $$<Configuration Manager Setup><10-16-2015 10:21:29.234+420><thread=2864 (0xB30)>
INFO: Command line options being used are /TESTDBUPGRADE CM_SJC   $$<Configuration Manager Setup><10-16-2015 10:21:29.236+420><thread=2864 (0xB30)>
INFO: the install path is set to temp folder: C:\Users\RDEFIN~1\AppData\Local\Temp\SCCM.  $$<Configuration Manager Setup><10-16-2015 10:21:29.236+420><thread=2864 (0xB30)>
INFO: SqlInstName = Default Instance  $$<Configuration Manager Setup><10-16-2015 10:21:29.236+420><thread=2864 (0xB30)>
Failed to connect HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL registry key for reading on SQL Server [sccm-sql-test.global.<domain_name>.com].  $$<Configuration Manager Setup><10-16-2015 10:21:29.529+420><thread=2864 (0xB30)>
WARNING: failed to retrieve port number for sccm-sql-test.global.<domain_name>.com.  $$<Configuration Manager Setup><10-16-2015 10:21:29.529+420><thread=2864 (0xB30)>
WARNING: failed to retrieve port number for sccm-sql-test.global.<domain_name>.com.  $$<Configuration Manager Setup><10-16-2015 10:21:29.530+420><thread=2864 (0xB30)>
INFO: Registered type SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER for sccm-sql-test.global.<domain_name>.com master  $$<Configuration Manager Setup><10-16-2015 10:21:29.556+420><thread=2864 (0xB30)>
INFO: Registered type SMS Master for sccm-sql-test.global.<domain_name>.com master  $$<Configuration Manager Setup><10-16-2015 10:21:29.556+420><thread=2864 (0xB30)>
INFO: Registered type SCCM-SQL-TEST.GLOBAL.<domain_name>.COM CM_SJC for sccm-sql-test.global.<domain_name>.com cm_sjc  $$<Configuration Manager Setup><10-16-2015 10:21:29.556+420><thread=2864 (0xB30)>
INFO: Registered type SMS ACCESS for sccm-sql-test.global.<domain_name>.com cm_sjc  $$<Configuration Manager Setup><10-16-2015 10:21:29.556+420><thread=2864 (0xB30)>
INFO: Testing SQL Server database upgrade on cm_sjc database, on the sccm-sql-test.global.<domain_name>.com server.  $$<Configuration Manager Setup><10-16-2015 10:21:29.556+420><thread=2864 (0xB30)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><10-16-2015 10:22:32.982+420><thread=2864 (0xB30)>
*** [01000][2][Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><10-16-2015 10:22:33.002+420><thread=2864 (0xB30)>
*** Failed to connect to the SQL Server, connection type: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER.  $$<Configuration Manager Setup><10-16-2015 10:22:33.002+420><thread=2864 (0xB30)>
INFO: SQL Connection failed. Connection: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER, Type: Unsecure  $$<Configuration Manager Setup><10-16-2015 10:22:33.002+420><thread=2864 (0xB30)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><10-16-2015 10:23:38.530+420><thread=2864 (0xB30)>
*** [01000][2][Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><10-16-2015 10:23:38.530+420><thread=2864 (0xB30)>
*** Failed to connect to the SQL Server, connection type: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER.  $$<Configuration Manager Setup><10-16-2015 10:23:38.530+420><thread=2864 (0xB30)>
INFO: SQL Connection failed. Connection: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER, Type: Unsecure  $$<Configuration Manager Setup><10-16-2015 10:23:38.530+420><thread=2864 (0xB30)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><10-16-2015 10:24:44.057+420><thread=2864 (0xB30)>
*** [01000][2][Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><10-16-2015 10:24:44.057+420><thread=2864 (0xB30)>
*** Failed to connect to the SQL Server, connection type: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER.  $$<Configuration Manager Setup><10-16-2015 10:24:44.057+420><thread=2864 (0xB30)>
INFO: SQL Connection failed. Connection: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER, Type: Unsecure  $$<Configuration Manager Setup><10-16-2015 10:24:44.058+420><thread=2864 (0xB30)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><10-16-2015 10:25:49.613+420><thread=2864 (0xB30)>
*** [01000][2][Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><10-16-2015 10:25:49.613+420><thread=2864 (0xB30)>
*** Failed to connect to the SQL Server, connection type: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER.  $$<Configuration Manager Setup><10-16-2015 10:25:49.613+420><thread=2864 (0xB30)>
INFO: SQL Connection failed. Connection: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER, Type: Unsecure  $$<Configuration Manager Setup><10-16-2015 10:25:49.614+420><thread=2864 (0xB30)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><10-16-2015 10:26:55.140+420><thread=2864 (0xB30)>
*** [01000][2][Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><10-16-2015 10:26:55.140+420><thread=2864 (0xB30)>
*** Failed to connect to the SQL Server, connection type: SCCM-SQL-TEST.GLOBAL.<domain_name>.COM MASTER.  $$<Configuration Manager Setup><10-16-2015 10:26:55.140+420><thread=2864 (0xB30)>
Avatar of lcohan
lcohan
Flag of Canada image

Looks like old or maybe wrong connection values were provided in the connection strings and they need to be fixed for this process to work OR you did not execute the command with sufficient rights - like "Run as administrator"?

...
Failed to connect HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL registry key for reading on SQL Server [sccm-sql-test.global.<domain_name>.com].  $$<Configuration Manager Setup><10-16-2015 10:21:29.529+420><thread=2864 (0xB30)>
WARNING: failed to retrieve port number for sccm-sql-test.global.<domain_name>.com.  $$<Configuration Manager Setup><10-16-2015 10:21:29.529+420><thread=2864 (0xB30)>
WARNING: failed to retrieve port number for sccm-sql-test.global.<domain_name>.com.  $$<Configuration Manager Setup><10-16-2015 10:21:29.530+420><thread=2864 (0xB30)>
...
Avatar of rdefino

ASKER

I'm running the command in an elevated command prompt and I;m and admin on the system.

What do you mean by "wrong connection values were provided in the connection strings". How do I fixed the connection string values.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rdefino

ASKER

Worked!!! Thanks