In order to register an MS SQL Server, you need to fill out the dialog below, reached via the Enterprise Manager and the Register Server button.
Register an MS SQL Server
Database Workbench needs the following information:
Host |
Hostname or IP address of the machine where the MS SQL Server process is running. |
Alias |
An user-defined alias name for the hostname - this is only used inside Database Workbench. |
Instance |
Optional instance name. |
Authentication type |
Either Windows (NT) build in authentication, or the special MS SQL Server authentication. |
Username |
The username to use for MS SQL Server authentication. This username will be used for any server specific tasks - it's recommended you use the "sa" user here. |
Password |
The password to use for MS SQL Server authentication. |
If you click OK, Database Workbench will test the connection - if this succeeds, the server will be registered and added to the Servers node in the Enterprise Manager.
Database Workbench then connects to your MS SQL Server and will list the available Databases. For using a database with Database Workbench, there are several options available.