Post reply

SQL Server DTS Export Issue

  • July 31, 2005 at 5:28 am

    #165562

    I am having several issues with sql server on my network regarding logins, users, and sql server or windows domain authentication. Does anyone know of a REALLY GOOD source for identifying just exactly how that all works, or can someone explain it to me.

    Here is the problem: I have sql server on 3 machines on my network (all XP Pro) and I use DTS to export data AND OBJECTS periodically. If I create a login (and give that log in administrative user rights to the dbs that it needs) when I try to use DTS I get an error message that says something to the effect that "this user already has a login under a different user name." It will allow me to use DTS to copy the data but not the data and objects.

    What might be causing that?

    Thanks!

  • August 3, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • August 3, 2005 at 2:39 pm

    #579362

    Are you using the 'Copy SQL Server Objects' task?  If so, are you using the default option to import database users and roles?  Try unchecking that option and see if the DTS works. 

    If you already have the logins and users on the destination server, DTS won't replace them.  It'll give you an error instead.

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply