export data problem

[maanton]

Hi!
I am running a database on my remote host and I try to get a copy to my local machine.
I use SQL Server Enterprise Manager and I use the export data wizard through the remote db.
This gets so far - looks like it is working, but then stops with an error - it says Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server and (when I click on the Executing Package/Status) "[Microsoft][ODBC SQL Server Driver][SQL Server] The login 'myusernameforsqlserver' does not exist"

But it does - my username is what I use to connect to/write/update etc info in the database.

Looking at my local server, it is creating the tables and SPs, but seems to fail on the data transfer.

What is going on? Any help is really appreciated because I have no other way of getting a backup

 

[mpipolo]

Have you tried to backup first and restore on your local PC?
This works for sure...You get that error because login in source DB is not present in target DB.

I hope this help.

Cheers, Massimo