via DSN-less (Driver)

DSN-less connections to SQL Server are supported via MicroStrategy Developer, and Data Import for Web and Workstation. DSN-less connection supports both ODBC and JDBC drivers.

JDBC drivers can only use DSN-less connection.

Configure DSN-less connection via Developer

1. Create a new Database Instance.

   

2. Add a new Database connection, and do not choose any Local System ODBC data sources.
3. Select the Advanced tab.
4. Under Additional connection parameters, enter your connection string . The connection string can be an ODBC string or JDBC string.

   

5. Configure and store credentials for the login.

Configure DSN-less connection via Data Import in MicroStrategy Web or Workstation