DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 239759 - Last Review: August 12, 2003 - Revision: 3.2

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.
  5. 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.

APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbprb KB239759
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support