Export Users from SQL Server to Another

roshandilruk

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

DenSter

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.

kine

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.

thaug

Easy. Look here:
http://support.microsoft.com/kb/246133

kriki

[Topic moved from Navision forum to SQL General forum]