Microsoft KB Archive/239759

= PRB: Error 5177 May Be Raised When Creating Databases =

Article ID: 239759

Article Last Modified on 8/12/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q239759



SYMPTOMS
When you create a new database or you start SQL Server, the following error messages may be raised:

Error 5177 "Encountered an unexpected error while checking the sector size for file '%.*ls'. Check the SQL Server error log for more information."

Error 5105, level 16, Device activation error. The physical file name '%.*ls' may be incorrect.



CAUSE
The Microsoft Windows NT account under which the MSSQLServer service starts does not have List Folder permissions on the root drive where the new database data or log files are created.



WORKAROUND
Assuming that the database is to be created in the D:\Data directory and that the MSSQLServer service is running under a Windows NT account called TestDomain\Testuser, you can work around the problem by following these steps:
 * 1) Open Windows Explorer, and then browse to drive D.
 * 2) Right-click drive D, and then click Properties.
 * 3) Click the Security tab, and then click Permissions.
 * 4) Make sure that the user "TestDomain\Testuser" (the MSSQLServer service startup account) is in the list of accounts that have List Folder permissions on the root drive D. If the account is not listed, click Add to add it to the list.

Note The List Folder permissions on the root drive do not have to be inherited by the subfolders.
 * 1) Make sure the MSSQLServer service startup account has Full Control permissions over the D:\Data folder, and then try to create the database.



MORE INFORMATION
If the workaround does not correct the problem, modify the account under which MSSQLServer service starts. Make sure that this account has Full Control permissions to the directory where SQL Server databases are to be created.

Note that 5177 errors can also indicate possible hardware-related problems, especially if the SQL Server errorlogs show other I/O-related errors, such as error 823.

Additional query words: CREATE DATABASE 5177 sector size

Keywords: kbprb KB239759

-

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

© Microsoft Corporation. All rights reserved.