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.

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. Db_owner role is already filled for users that previously had this role (this information is stored in database backup - .bak).

On a right click menu there are options for easier selection:

Note that listed are all PANTHEON users, even inactive ones.