How to change OnSemble Database new login or password.

First you will need to create a new user in SQL Manager. Once the user is created you have to setup the new SQL Server authentication login name and password. Please ensure that the password does not expire or must be changed.

-Connect to SQL Manager and click Security>Logins. Right click Logins to create a “New Login”.

Set Server Role to dbcreator for the new account.

Under User Mapping map the new users role to db_owner for all the Databases listed.

Edit Connection String within Portaladmin Side:

Editing configuration paths:

Under server modules, example (inetpub\wwwroot\Alex H\Modules):

The connectionString code will need to be edited with the new information.