WEBfactory 2010

Using a Different SQL Login in WEBfactoryStudio

When the WEBfactory 2010 solution is used in an already active environment, chances are that the default sa SQL login/user is already used by a different application connected to the SQL database. In this situation, a new SQL login/user can be created and used for logging in WEBfactoryStudio and creating the DSN connection.

Creating the new SQL Login

The following steps will guide you through the creation of a new SQL Login for the SQL Server, with the appropriate roles and user mappings.

  1. In Microsoft SQL Server Management Studio, expand the database server on which the WEBfactory database is running.

  2. Right-click on the Security folder and select New > Login.

    Capture4349.jpg
  3. In the General section of the Login - New window, provide a name for the new Login. Select SQL Server authentication and provide the password. Make sure to disable Enforce password expiration so that WEBfactoryStudio can stay connected to the database and set the Default language to English.

    Capture4355.jpg
  4. In the Server Roles section, select the dbcreator and public server roles. This will allow the new login to create new databases when used from WEBfactoryStudio.

    Capture4351.jpg
  5. In the User Mapping section, the new login can be mapped to existing databases. This is required only if the new login will be used with already existing databases in WEBfactoryStudio. In this case, the login must be mapped to all related databases, including the AlarmLog, Events and Logs databases associated with the main project database. The Default Schema for each mapping must be dbo and the Database role membership must be set to db_owner.

The database user will be automatically created when mapping the new login to an existing database.

If creating a new database using the new SQL login in WEBfactoryStudio, the login will be automatically mapped to the dbo user of the new database.

Capture4357.jpg

The new SQL login can now be used in WEBfactoryStudio.

Capture4358.jpg