Introduction

To view, update or create users select the settings Icon and choose users:

By default, you will have a Super Admin, Admin, and User which correlate with the internal roles that come standard with Conductor4SQL.

When adding or editing users you set their username, password, and role. By default, the internal User role, which is a view-only role, will be assigned to newly created users if you do not assign them a custom role. You can create roles as long as you have AdminRoleUpdate permission.

Setup LDAP (Active Directory)

Instead of having to create local users for each person wishing to interact with SQLPro it's often easier to use Microsoft's Active Directory. This way users do not have to remember another password for another system, and it's also more secure than using local logins.

SQLPro supports LDAP which Microsoft uses Active Directory.

First thing you'll need to do is find out where your AD server is located. So open the Command Prompt line on your central server hosting SQLPro and run the following command

set l | find /i "LOGONSERVER=\\"

In our example the AD server name is TEST-AD1, take note of your AD server location.

Next in SQLPro, you'll need to go to the Administration >> Users screen and select the Edit Configuration button.

Fill in the LDAP Host field with your AD server location and in most cases keep LDAP Port as 389 and click on Save.

When adding a new User, make sure you select LDAP User for Authentication Type. Also include your domain name in the Username field.

Now you should be able to log in as this user using normal AD credentials (remember to include your domain name in your username)

Setup and Enable Azure AD Integration

SQLPro also supports Azure Active Directory

In order to use Azure AD logins the first step is to log into Azure Portal and navigate to the Azure Active Directory screen https://portal.azure.com/#view/Microsoft_AAD_IAM/ActiveDirectoryMenuBlade/~/Overview.

Next select App Registrations

Select New registration

Fill in the Name field and click on the Register button.

Now open your newly registered app, select the Authentication menu item and click on Add a platform. Fill in the https address that you are using for SQLPro. in this example I'm using our UAT server https://sqlprouat:8084. So under Redirect URIs, in my example I put down the uri https://sqlprouat:8084/login/auth-callback and I also ticked ID tokens (used for implicit and hybrid flows). Then finally click on the Configure button. Note, that you can only use https, and you'll need to adjust the URIs to work with your environment.

Now go to the Overview section in your newly registered app and take note of the Application (client) ID and Directory (tenant) ID for the app as you'll need this information next.

Next in SQLPro, you'll need to go to the Administration >> Users screen and select the Edit Configuration button. Paste in the Azure Tenant ID and the Azure Client ID and Save.

Restart the ConductorSQLPro Windows service.

Now when adding new users select the Azure User option.

If all went well you'll have a Login With Azure AD option, and you'll be able to log in via this method.