exporting windows and sql logons to another server fails

• Chami Rstnayake

  Old Hand

  Points: 384

  More actions

  June 29, 2004 at 4:54 am

  #162176

  Hi,

  I am trying to export all windows accounts and sql login in my user databases but it fails. I think it is b's of default windows logins.

  how do I exported these accounts and permission to another server?

  have anyone exported accounts without a trouble when you have dbo,builtin/admin group there?

  Thanks in advance

   

  chamindra

• growl

  Hall of Fame

  Points: 3068

  More actions

  July 1, 2004 at 5:21 pm

  #513049

  Check out these links.

  http://www.databasejournal.com/features/mssql/article.php/2228611

  http://support.microsoft.com/default.aspx?scid=kb;en-us;246133#4

  No trouble doing it this way. Remember to check for orphaned users.