You are here: Getting Started > Configuring the Milan Server > Connection Strings

Connection Strings

Milan connects to WorkSite, Milan, and billing databases through the use of connection strings. A typical connection string, like the one below, specifies a database server and connection method.

Data Source=SQLServer;User Id=sa;Password=password;Initial Catalog=milan;Integrated Security=false;MultipleActiveResultSets=True

As can be seen in the above example, when using SQL authentication (Integrated Security = false), the user id and password are passed as clear text and visible to any Milan user with access to the Application Configuration page in Milan. For greater security, you can instead connect to any database with Windows authentication (Integrated Security = true), which uses the credentials of the account running the Milan application pool to authenticate with the SQL server.

Note: Connection strings are stored in encrypted form in the Milan.AppSettings table.

While most connections strings used by Milan can be configured during the initial web-based setup, it is possible to add or edit connection strings at any time through the web client by opening Administration → Application Configuration → Connection Strings.

Note: If you will be using Billing To Milan, you must configure the required connection strings on the Connections Strings tab before attempting to run the program. Refer to Configuring Billing To Milan for more information.

Connection String Types

As far as Milan is concerned, there are only two kinds of connection strings: WorkSite connection strings and non-WorkSite connection strings. WorkSite connection strings point to WorkSite libraries, while non-WorkSite connection strings point to everything else, including the Milan database, Billing To Milan, and SQL-based billing systems.

ClosedNon-WorkSite Connection Strings
ClosedMilan Database

The two connection strings used by Milan to connect to its own database, adminSiteAudit and milanlog, are created during the initial web setup. Although it is possible to edit either connection string, neither can be deleted.

By default, the milanlog connection string points to the primary Milan database, i.e. the adminSiteAudit database. Milan uses two tables within this database, Milan.EventLog and Milan.Audit, to store provisioning service events and audit events, respectively.

If you would prefer to store Milan's logs in a separate database dedicated to event logging, you must make a copy of the Milan database, keeping the full schema intact, and configure the milanlog connection string.

To configure a separate database for event logging:

  1. Open Administration → Application Configuration→ Connection Strings.
  2. Click the Value column for the milanlog connection string.
  3. Change the following values to match the new Milan log database configuration:
    SettingDescription
    Data SourceName of the SQL server hosting the Milan log database
    User ID

    An SQL account with db_owner access to the Milan log database

    PasswordPassword for the SQL user account specified in User ID
    Initial Catalog Name of the Milan log database
    Integrated Security
    ValueDescription
    TrueUse trusted authentication to connect to the Milan log database
    FalseUse SQL authentication to connect to the Milan log database
ClosedBilling To Milan

Billing To Milan recognizes three specific connection string names, which correspond to its three modes of operation. By default, these string names are billing, archive, and security.

Refer to Configuring Billing To Milan for more information on how to specify different connection strings for each type of operation.

ClosedAdding a New Non-WorkSite Connection String

To add a non-WorkSite connection string:

  1. Go to Administration → Application Configuration → Connection Strings.
  2. Click Add New Connection String.
  3. Fill in the following fields in the Add Connection dialog.
  4. Field Name Description
    Connection String Name Name of the connection string
    SQL Server Name Name of the SQL server
    SQL Database Name Name of the target database in SQL Server
    Trusted / Integrated Login?
    Value Description
    Yes Use trusted authentication to connect to the target database
    No Use SQL authentication to connect to the target database
    SQL User Name Name of user with access to target SQL database

    Note: This and the following field should only be filled in when using SQL authentication.
    SQL Password Password for user account specified above
ClosedWorkSite Connection Strings

During the initial web setup, you can only specify one WorkSite database for Milan to manage. However, Milan can be configured to manage as many WorkSite libraries as you require.

To add a WorkSite connection string to Milan:

  1. Open Administration → Application Configuration → Connection Strings.
  2. Click Add New WorkSite Connection String.
  3. Enter the appropriate information into the following fields:
    Field NameDescription
    DMS NameName of the WorkSite server or server cluster
    Database (Library) NameName of the WorkSite database
    SQL Server NameName of the SQL server hosting the WorkSite database
    SQL Database Name Name of the WorkSite database on the SQL server
    Trusted/Integrated Login
    ValueDescription
    YesUse trusted authentication to connect to the WorkSite database
    NoUse SQL authentication to connect to the WorkSite database

    Note: When using Trusted Login, the service used by the Milan application pool must have db_owner access to the Milan database.

    SQL User NameA user on the SQL server with db_owner access to the WorkSite database.

    Note: This and the following field should only be filled in when using SQL authentication.

    SQL PasswordPassword for the user account specified above
  4. Click Save. Milan automatically generates a name for the connection string in the format ias_<DMS Name>_<ODBC Name>, where DMS Name is the name of the WorkSite server and ODBC Name is the name of the ODBC connection to the WorkSite library.

Managing Connection Strings

Both WorkSite and non-WorkSite connection strings can be edited and deleted in the same fashion.

ClosedEditing Connection Strings

To edit an existing database connection string:

  1. Go to Administration → Application Configuration → Connection Strings.
  2. Click the Value column for a connection string and modify the connection string parameters. Click outside the Value field after modifying the connection string to confirm the changes in the field.
  3. Click Save.
ClosedDeleting Connection Strings

To delete an existing database connection string from the Milan web client:

  1. Navigate to Administration → Application Configuration → Connection Strings
  2. Click the delete icon in the Delete column for a connection string.
  3. Click Yes to confirm the connection string deletion.
  4. Click OK.
  5. Click Save.

Note: The adminSiteAudit and milanlog connection strings cannot be deleted.

 

ClosedSUPPORT INFORMATION

Phone | +1 312 462 3800 (Weekdays, 9:00 AM - 5:00 PM CST)

Email | support@prosperoware.com

Web |   http://support.prosperoware.com/
ClosedCOMPANY INFORMATION

Prosperoware, LLC

11 Bala Avenue

Bala Cynwyd, PA 19004

+1 484 895 1900

http://www.prosperoware.com/

 
ClosedPRODUCT INFORMATION

Milan 3.3 P2

Copyright © 2014 Prosperoware, LLC

Open topic with navigation