![]() 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. Use Windows NT Authentication for login ID: This option is available if you are configuring your connection on Windows. The database administrator assigns the database name. Check with your database administrator for the correct number.ĭatabase Name: The name of the database to connect to by default. The default port number for SQL Server is usually 1433. Port Number: The port number for the connection. The following are examples of providing the server name for your SQL Server database: ▫ Contact your system administrator for the server name or IP address.Īdditionally, 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. You can also specify the IP address such as 123.45.678.998. For example, if your network supports named servers, you can specify an address such as SQLServer-1. Host Name: Enter the name of a SQL Server on your network. For example, Personnel or SQLServer-1 can serve to identify the connection. ![]() ĭata Source Name: A name to identify the Microsoft SQL Server data source configuration in MicroStrategy. ![]() The following information is required for setting up the driver connection for the MicroStrategy-branded version of the Microsoft SQL Server driver: 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |