Article ID: 252519
Article Last Modified on 10/17/2003
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q252519
BUG #: 57439 (SQLBUG_70)
SYMPTOMS
If you run the Transfer Manager to transfer objects and users or roles between databases, the process may fail when an you define an application role. The Transfer Manager fails with the following error message:
After you press OK and double-click the error in the Executing DTS Package dialog box, the following error displays:
CAUSE
There is a conflict between two of the steps that the Transfer Manager performs. In the first step, the Transfer Manager sets the password to NULL when creating scripts from the source database. The following informational message is found in the file of the following type:
SourceServer.SourceDatabase.Log file (the file is in the script directory selected in the wizard).
This warning indicates that the application role password was set to NULL when scripted out.
The second step occurs during the transfer into the destination database. As the first error message suggests, the transfer requires that the password for the application role, on the destination database, not be null. The following error is found in the file of the following type:
DestinationServer.DestinationDatabase.Log file.
WORKAROUND
To work around this problem, use one of these alternatives:
- To transfer the application roles:
- Using the Generate SQL Scripts Utility, script the roles and drop the application roles from the source database.NOTE: Remember that at least one object needs to be scripted in order for users or roles to be scripted.
- Using the Generate SQL Scripts Utility, script the roles and drop the application roles from the source database.NOTE: Remember that at least one object needs to be scripted in order for users or roles to be scripted.
- Perform the transfer.
- Re-create the application roles on both the source and destination servers from the scripts generated earlier.
- Do not transfer any users and roles:
- Clear the Use Default Options check box in the wizard.
- Clear the Transfer database users and database roles check box.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Additional query words: transfer manager applicaton role
Keywords: kbbug kbpending KB252519