Connecting to Databases and Data Sources » Creating DSNs for specific data sources » MicroStrategy ODBC Driver for Microsoft SQL Server for Windows and UNIX/Linux

MicroStrategy ODBC Driver for Microsoft SQL Server for Windows and Linux

The following information is required for setting up the driver connection for the MicroStrategy-branded version of the Microsoft SQL Server driver:

Data Source Name: A name to identify the Microsoft SQL Server data source configuration in MicroStrategy. For example, Personnel or SQLServer-1 can serve to identify the connection.
Host Name: Enter the name of a SQL Server on your network. For example, if your network supports named servers, you can specify an address such as SQLServer-1. You can also specify the IP address such as 123.45.678.998. Contact your system administrator for the server name or IP address.

Additionally, if you use named instances to distinguish SQL Server databases, you can include the named instance along with either the server name or IP address using the format ServerName\NamedInstance or IPAddress\NamedInstance. The following are examples of providing the server name for your SQL Server database:

SQLServer-1\Instance1
123.45.678.998\Instance1
Port Number: The port number for the connection. The default port number for SQL Server is usually 1433. Check with your database administrator for the correct number.
Database Name: The name of the database to connect to by default. The database administrator assigns the database name.
Use Windows NT Authentication for login ID: This option is available if you are configuring your connection on Windows. Select this check box to use Windows NT authentication to pass a user’s credentials on the Windows machine to execute against a SQL Server database.

If you use Windows NT authentication with SQL Server, you must enter the Windows NT account user name and password in the Service Manager. For information on the Service Manager, see the System Administration Guide.

Inserting date data into SQL Server 2000 tables can cause errors if the system’s Regional Settings are not set properly. Ensure that the date format is defined to be in an English format.

Enable SQL Database (Azure) support: Defines whether the DSN is created to support SQL Azure. Select this check box if the DSN is used to access a SQL Azure data source.
Enable SSL encryption:
Windows: Open the DSN in the ODBC Administrator and edit the Security tab so that Encryption Method is set to 'SSL' and the Validate Server Certificate is unchecked as shown below.

Linux: Edit the odbc.ini file and set the following values in the DSN:
EncryptionMethod=1
ValidateServerCertificate=0