Microsoft KB Archive/943635

= You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005 =

Article ID: 943635

Article Last Modified on 10/31/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition

-



SYMPTOMS
When you run the Setup command from a location that is not the location from which you originally installed an instance of Microsoft SQL Server 2005, you cannot rebuild system databases. Additionally, the following information is logged in the SQL Server Setup log file:

MSI (s) (7C:CC) [16:33:43:350]: File: :\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf; To be installed; Won't patch; No existing file

MSI (s) (7C:CC) [16:33:43:350]: Resolving source.

MSI (s) (7C:CC) [16:33:43:350]: User policy value 'SearchOrder' is 'nmu'

MSI (s) (7C:CC) [16:33:43:350]: User policy value 'DisableMedia' is 0

MSI (s) (7C:CC) [16:33:43:350]: Machine policy value 'AllowLockdownMedia' is 0

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Media enabled only if package is safe.

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Looking for sourcelist for product { }

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Adding { }; to potential sourcelist list (pcode;disk;relpath).

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Now checking product { }

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Media is enabled for product.

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Attempting to use LastUsedSource from source list.

MSI (s) (7C:CC) [16:33:43:350]: SOURCEMGMT: Trying source \Servers\Setup\.

MSI (s) (7C:CC) [16:33:43:960]: Note: 1: 2303 2: 21 3:

MSI (s) (7C:CC) [16:33:43:991]: Note: 1: 2303 2: 21 3:

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 2303 2: 21 3:

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1325 2: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1706 2: -2147483647 3: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: SOURCEMGMT: Processing net source list.

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1706 2: -2147483647 3: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: SOURCEMGMT: Processing media source list.

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 2203 2: 3: -2147287037

MSI (s) (7C:CC) [16:33:44:007]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1706 2: -2147483647 3: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: SOURCEMGMT: Processing URL source list.

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1402 2: UNKNOWN\URL 3: 2

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1706 2: -2147483647 3: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: Note: 1: 1706 2: 3: SqlRun_SQL.msi

MSI (s) (7C:CC) [16:33:44:007]: SOURCEMGMT: Failed to resolve source

MSI (s) (7C:CC) [16:33:44:007]: Transforming table Error.

Notes
 * The location from which you originally installed the instance can be a CD drive, a DVD drive, or the UNC path of a network share.
 * The SQL Server Setup log file is generated when the Setup command cannot rebuild the system databases.



CAUSE
This problem occurs because the installation media for SQL Server 2005 does not exist in the location from which you originally installed the instance of SQL Server 2005.

The location from which you installed the instance of SQL Server 2005 is saved in the value of the following registry entry:

Note  represents the SQL Server 2005 Database Engine product code.



WORKAROUND
To work around this problem, use one of the following methods.

Method 1: Use the location from which you installed the instance of SQL Server 2005 to run the Setup command
 Make sure that the SQL Server 2005 installation media exists in the location from which you originally installed the instance of SQL Server 2005. Click Start, click Run, type cmd, and then click OK.  Run the following command to rebuild the system databases: start /wait Original_Location\setup.exe /qn INSTANCENAME=Instance_Name REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword Note  represents the location from which you originally installed the instance of SQL Server 2005. 

Method 2: Update the location that is saved in the value of the LastUsedSource registry entry
 Click Start, click Run, type regedit, and then click OK. Locate the following registry entry:

Note  represents the registry subkey that contains the ProductName registry entry whose value is Microsoft SQL Server 2005. Update the location that is saved in the value of the LastUsedSource registry entry to the location from which you want execute the Setup command.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="references_section">