quote:

---

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E4D (Login failed for user 'sa'.). (Copy Database Wizard)
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.FolderExistsOnSqlServer(String strFolderName, String strServerName, String strServerUserName, String strServerPassword)
at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.EnsurePackageFolderExist(String folderName, Application app, String serverName, String loginName, String password)
at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()
While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E4D (Login failed for user 'sa'.).

---

• Run SS2008 as an Administrator user (same error)


• Checked firewall is open on ports 1433 and 1434 (same error)


• Logged into SQL2008 (destination machine) as SA (Create package succeeds, but then after a long pause a new error is thrown in the Execute SQL Server Agent Job step:
  

  quote:

  ---

  The job failed. Check the event log on the destination server for details.

  ---

  
  The event log shows:
  

  quote:

  ---

  Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

  ---

  
  


• Created a new Windows Administrator user, then re-installed SS2008 to only use that account (same error)


• Create a proxy account within SS2008 and used that instead of SQL Server Agent (same error)


• Used Backup/Restore via T-SQL. This works, but introduces a security risk getting the backup file onto my destination machine, so would rather not use it if possible.

errorCode=-1073548784 
description=
Executing the query "sys.sp_addrolemember @rolename = N'LearnerRole'..." 
failed with the following error: "The role 'LearnerRole' does not exist in the current 
database.". Possible failure reasons: Problems with the query "ResultSet" property not 
set correctly parameters not set correctly or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}
StackTrace:
   at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
 Operator: NT AUTHORITY\SYSTEM
 Source Name: CDW_108159-APP1_DELL1530_4
 Source ID: {854A153F-9903-4541-A1BA-29F334EFCF3C}
 Execution ID: {665C6225-466C-4FAD-AC75-09D656F19CCD}