BUG: SQL Admin Menu Database Dump Fails in Mixed Security

ID: Q125325

The information in this article applies to:
BUG# NT: 10927 (4.2)

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.

Additional query words: 


Keywords          : kbtool SSrvSQL_Admin kbbug4.20 SSrvWinNT 
Version           : 4.2
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 20, 1999