Knowledge Base |

# BUG: SQL Admin Menu Database Dump Fails in Mixed Security

Article ID: 125325

Article Last Modified on 7/30/2000

APPLIES TO

- Microsoft SQL Server 4.21a Standard Edition

This article was previously published under Q125325

## SYMPTOMS

Performing a database dump using the SQL Admin menu bar under the following conditions will cause the dump to fail to a tape or diskette dump device:

1. sa password is not null.
2. Mixed security is set with default domain = local machinename.
3. Local user logged on to NT, user has sa privileges in SQL.
4. Local user logged in to SQL Admin.

The dump will cause the following errors:

1. SQL Admin:

   Backup/Restore operation ended in error

2. SQL error log:

   Login failed- user: sa

3. SQL Monitor (via event viewer):

   Cant log on to ., user: sa

## WORKAROUND

Dump the database using a query window and the DUMP DATABASE command along with CONSOLE.EXE.

## STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: KB125325