Each of our clients has their own database, so I am using DTS to create a new database that is an exact copy of an exisitng one. I am also creating a VB DTS file so we can make a programatic solution that creates the database and all related programs, reports and so on.
My problem is that when I tell DTS to create the database, I end up user errors. I've tried evey option I can think of and as a result, have a variety of errors. I've had:
User does not exist
User already exists
There is no such user or group
If I manually create the database and assign the users, then transfer the objects with DTS, it seems to work. But the goal is to do it all programatically.
I think the problem goes back to when we upgraded our server hardware. I don't think the users were transferred properly.
Any ideas would be appreciated.
My problem is that when I tell DTS to create the database, I end up user errors. I've tried evey option I can think of and as a result, have a variety of errors. I've had:
User does not exist
User already exists
There is no such user or group
If I manually create the database and assign the users, then transfer the objects with DTS, it seems to work. But the goal is to do it all programatically.
I think the problem goes back to when we upgraded our server hardware. I don't think the users were transferred properly.
Any ideas would be appreciated.