(new related group 1)

Oracle

Voriges Thema

Nächstes Thema

Microsoft SQL Server

To connect the Microsoft SQL Server, proceed as follows:

  1. Open the SQL Console of the SQL Server by selecting New Query.
  2. Use the following script as a template, change it as necessary and then execute it.

    To avoid problems when enabling the data source, ensure that LOGIN, USER and SCHEMA are the same.

    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. Set up a new SQL Server type data source in the UMS Administrator.
  4. Ensure that the server port of the SQL Server is configured correctly in the data source. The default value is 1433.

    The Microsoft SQL Server should allow Windows and SQL authentication.