FIX: Remote Backups and xp_loginconfig Fail With Access Denied

ID: Q140332

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 12222 (6.00)

SYMPTOMS

Database dumps to remote devices and the xp_loginconfig extended stored procedure can fail with access denied errors if Microsoft SQL Server is using Per Seat licensing mode.

For database dumps, the client will get a 3201 error and the Windows NT Application log of the computer SQL Server is running on will contain the following event:

Event ID: 17055
Type: Error
Source: MSSQLServer
Category: Kernel
User: could be any user connected to SQL Server
Description: Mesg 18204: dbswritecheck: Backup device '<device path
and file>' failed to open, operating system error=5(Access is denied.)

When running xp_loginconfig, the query will return the message:

Unable to query SQL Server security information.

WORKAROUND

Switch the SQL Server security mode to mixed or integrated security.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 Security Impersonation Delegation dbswritecheck winnt windows nt


Keywords          : kbprg SSrvStProc kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 23, 1999