PRB: SQL Server 7.0 Setup Fails at Configuration Phase Because of Insufficient Permissions (260388)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q260388

SYMPTOMS

SQL Server 7.0 Setup may fail during the configuration phase if there are insufficient permissions established.

CAUSE

If the drive or the partition to which you are installing SQL Server 7.0 does not have the SYSTEM account with full control permission, Setup will fail during the configuration phase.

WORKAROUND

To Add Permissions on Computers Running Windows NT 4.0

  1. Right-click the drive or the partition to which you are installing SQL Server 7.0, and then choose Properties.
  2. Click the Security tab, and then click Permissions.
  3. In the Directory Permissions dialog box, click Add, and then below Add names type SYSTEM. For Type of Access, select FULL CONTROL.
  4. Remove the current installation of SQL Server 7.0. To do so, either:
    • Go to Control Panel, start the Add/Remove Programs utility, and remove SQL Server 7.0. -or-

    • Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Uninstall SQL Server 7.0.
    You must also delete the root SQL Server installation folder and any database files with .mdf, .ldf, or .ndf extensions that exist on the drive or partition before you restart the computer and reinstall SQL Server 7.0.

To Add Permissions on Computers Running Windows 2000

  1. Right-click the drive or the partition to which you are installing SQL Server 7.0, and then choose Properties.
  2. Click the Security tab.
  3. Click Add, and then select the computer's name in the Look in drop-down list. Select the SYSTEM account, and then click Add. Next, click ok. Under Permissions, for Full Control, select Allow.
  4. Remove the current installation of SQL Server 7.0. To do so, either:
    • Go to Control Panel, start the Add/Remove Programs utility, and remove SQL Server 7.0. -or-

    • Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Uninstall SQL Server 7.0.
    You must also delete the root SQL Server installation folder and any database files with .mdf, .ldf, or .ndf extensions that exist on the drive or partition before you restart the computer and reinstall SQL Server 7.0.

MORE INFORMATION

After Setup fails, Sqlstp.log and Cnfgsvr.out may contain entries similar to the following:

SQlstp.log:
----------
19:13:20 d:\MSSQL7\binn\cnfgsvr.exe  -Silent 2 -No3sampleDB 0 -SQLPath
"d:\MSSQL7\" -SQLDataPath "d:\MSSQL7\" -SortID 52 -LCIDCompStyle
"1033-196609" -HWND 11272336 -User <username> -Pwd <strong password>
19:15:19 Process Exit Code: (-1)
19:15:20 Setup failed to configure the server. Refer to the server error
logs and cnfgsvr.out for more information.
					
NOTE: Only the relevant section from the log is included here for the sake of brevity.


Cnfgsvr.out
-----------

Starting Service ...

Connecting to Server ...

driver={sql server};server=.;UID=<username>;PWD=<strong password>;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).

SQL Server configuration failed.
					


Modification Type:MajorLast Reviewed:10/30/2003
Keywords:kbprb KB260388