Microsoft KB Archive/260388

= PRB: SQL Server 7.0 Setup Fails at Configuration Phase Because of Insufficient Permissions =

Article ID: 260388

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.



To Add Permissions on Computers Running Windows NT 4.0
 Right-click the drive or the partition to which you are installing SQL Server 7.0, and then choose Properties. Click the Security tab, and then click Permissions. In the Directory Permissions dialog box, click Add, and then below Add names type SYSTEM. For Type of Access, select FULL CONTROL. 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.</li></ul>

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.</li></ol>

To Add Permissions on Computers Running Windows 2000
<ol> Right-click the drive or the partition to which you are installing SQL Server 7.0, and then choose Properties.</li> Click the Security tab.</li> 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.</li> Remove the current installation of SQL Server 7.0. To do so, either: <ul> Go to Control Panel, start the Add/Remove Programs utility, and remove SQL Server 7.0. -or-

</li> Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Uninstall SQL Server 7.0.</li></ul>

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.</li></ol>

<div class="moreinformation_section">

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

<pre class="fixed_text">SQlstp.log: -- 19:13:20 d:\MSSQL7\binn\cnfgsvr.exe -Silent 2 -No3sampleDB 0 -SQLPath &quot;d:\MSSQL7\&quot; -SQLDataPath &quot;d:\MSSQL7\&quot; -SortID 52 -LCIDCompStyle &quot;1033-196609&quot; -HWND 11272336 -User -Pwd 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.

<pre class="fixed_text">Cnfgsvr.out ---

Starting Service ...

Connecting to Server ...

driver={sql server};server=.;UID= ;PWD= ;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.

Keywords: kbprb KB260388

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.