BUG: SQL Admin Menu Database Dump Fails in Mixed Security (125325)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
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.
Modification Type:MajorLast Reviewed:7/30/2000
Keywords:KB125325
©2002 Microsoft Corporation. All rights reserved.