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 |
With multiple SQL Server instances running on the same machine, specify an instance name here.
|
Protocol |
Database Workbench supports the TCP/IP and Named Pipes protocol to connect to SQL Server, by default SQL Express supports Named Pipes only.
|
TCP/IP Port |
If you're not running SQL Server Browser at the server, you can enter a (custom) port number here, leave it to [autodetect] otherwise.
|
Pipe Name |
If you're not running SQL Server Browser at the server, you can enter a (custom) pipe name here, leave it to [autodetect] otherwise.
|
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. At first, Database Workbench will try to use SQL Server Native Client to connect, if you don't have this installed, it will use MDAC.
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.
Note:
| • | If you're trying to connect to SQL Server Express, make sure you either enable TCP/IP in the SQL Server Configuration Manager as it is disabled by default, or use the Named Pipes protocol, set it to the proper pipe name. In the case of Named Pipes, also make sure the service is running under valid credentials in order to set up a named pipe connection. For information about connection errors involving Named Pipes, see blogs.msdn.com or blogs.msdn.com. |
| • | For more information on the SQL Server Browser service, see msdn.microsoft.com |