Export Users from SQL Server to Another

roshandilruk
roshandilruk Member Posts: 51
edited 2007-05-17 in SQL General
Hi All,

Is it possible to export all the user from one SQL server and import to another. I'm installing a new database for my client and I need to take the same users from the pervious server.

Is this possible ??

Thanx

Comments

  • DenSter
    DenSter Member Posts: 8,307
    If you're running windows authentication, I think all you need to do is run a full synchronization and that will take care of everything.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kine
    kine Member Posts: 12,562
    In case you are using DB users and you have SQL 2005, you can use special component for user transfer in Integration services. Else you need to find or create some script for that and this will be not so easy.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • thaug
    thaug Member Posts: 106
    Easy. Look here:
    http://support.microsoft.com/kb/246133
    There is no data, only bool!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories