Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

new database user problems

Status
Not open for further replies.

deepsheep

Programmer
Sep 13, 2002
154
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top