AddUsers - Adding Database Users
The AddUsers utility reads users from a PANTHEON database and creates SQL Server logins for the selected users. It can be downloaded from Datalab's FTP site. File is named AddUsers_PAX.exe.
This is handy, for example, when moving PANTHEON's database from one server instance to another, and the new instance has no logins created yet.
In the utility, specify connection parameters: Server and database name, and the sa (SysAdmin) login.
Click Fill users from Users table to read all users from PANTHEON's database.
Select the users for which you want to create SQL Server logins and their roles and click Create Users. A message will inform you when the operation is finished.
On a right click menu there are options for easier selection:
 |
Users that are not selected will not be created as SQL users on the server (no SQL login will be created for them)
The users that are listed are all Pantheon users also inactive ones.
|