Export Data/Login Problem
To warn you, I'm a complete newbie to programming. :) I inherited a Coldfusion application at work (development was outsourced to external developers) and I'm trying to install a login function. I'm running into problems trying to first backup the database of the application. My web host doesn't allow direct access to our database, and they recommended that I use the DTS "Export Data" function through SQL Enterprise Manager. When I run the Wizard, I get an error message saying:
"[Microsoft][ODBC SQL Server Driver][SQL Server]The login 'database owner' does not exist."
My login details are all correct (I checked with my web-host - I can login via SQL Enterprise Manager to view the database, I only run into problems when trying to export the data.) I Googled the message, and I found someone who solved the issue on another message board. Their post said:
Again, I am a complete noob. How can I fix this problem, or is there any way I can circumvent it to backup my database?
A few objects that other developers had added didn't have all the correct user details in them which caused problems. (ie not referencing them all by user.object).
Thanks for any help. :)