February 9, 2006 at 11:11 am
Being a neophyte with SQL Server, I'm still trying to figure out some basic stuff, including the proper way to set up and run DTS packages as scheduled jobs. Basically, what I'm doing here is setting up a job that is supposed to copy the current production tables into the development environment every night. It's not really a back-up, just a way to make sure the dev data looks the same as the production data.
As far as I can tell, the two databases should be identical. The job actually runs, but it ends with the following error.
What should I be looking at as a solution? Thanks.
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]SETUSER permission denied in database 'XXXX_DEV'.
Step Error code: 80040106
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
George
February 9, 2006 at 5:14 pm
I think I resolved this problem.
I had created user logins in both databases using the same name. But of course, to SQL Server, they are NOT the same user. Some of the tables were owned by that user, and they seem to be the ones causing the error. Giving ownership of all tables back to the dbo resolved it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply