Microsoft KB Archive/125325

= 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:

 SQL Admin:

Backup/Restore operation ended in error

 SQL error log:

Login failed- user: sa

 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.