Connecting Microsoft SQL Server Cluster

  1. Open the SQL console of the SQL server (New Query) in SQL Server Management Studio.
  2. Use the following script as a template, customize it (password) and execute it.

    To avoid problems when activating the data source, ensure that Login, User and Schema have the same name.

    CREATE DATABASE rmdb

    GO

    USE rmdb

    GO

    CREATE LOGIN igelums with PASSWORD = 'setyourpasswordhere',

    DEFAULT_DATABASE=rmdb

    GO

    CREATE USER igelums with DEFAULT_SCHEMA = igelums

    GO

    CREATE SCHEMA igelums AUTHORIZATION igelums GRANT CONTROL to igelums

    GO

  3. Use the UMS Administrator to set up a new SQL server type data source for each server.
  4. For each server, ensure that the port of the SQL server in the data source is configured correctly. The default value is 1433.

    The Microsoft SQL Server should allow Windows and SQL authentication.