Installing and Configuring Database Access for MS SQL Server

Installing the SQL Client Tools for Microsoft SQL Server

Windows Systems

To access an Microsoft SQL Server running on a Windows system via the Bridge, you need no database client tools, if the Microsoft SQL Server installation is a single installation -  means if only one Microsoft SQL Server is installed on that machine. However, if several instances - so called "named instances" are installed on that machine, you are not able to connect to that Microsoft SQL Server without having installed the Microsoft SQL client tools or the MDAC (Microsoft Data Access Components). The MDAC tools are included in the Microsoft SQL Server client tools but you can also download them at http://msdn.microsoft.com/data/mdac/downloads.

Linux Systems

Since Bridge 7, the Bridge supports Microsoft SQL Server on Linux systems.

Defining the Microsoft SQL Server Database Preferences on the Bridge

This is relevant only for Linux systems.

In a browser, open the Web-based user interface of the system, on which the Bridge is installed (see Checking the Installation). Enter a user id and password of a user with administration rights (the pre-defined user admin, for instance).
The welcome page is displayed.

In the Navigation, select the xUML Services item of the node instance you want to define the database preferences for and switch to tab Preferences:

Now, you can define the SQL adapter preferences for each database type. Select the DB2, Oracle, MySQL, or MSSQLServer Adapter in the drop down box and the parameters of the selected adapter are displayed.

Select Microsoft SQL Server, enter the following parameter and click Apply.