Registering a MS SQL Server
|Previous Index Next How To Use|
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:
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.
•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