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 click Create Users. A message will inform you when the operation is finished.

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