Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »


Configuration of your Microsoft SQL Server installation is required.
If you are not already logged on to the server that has SQL installed on it, do so now.
Find the Workbench directory the Workbench\Setup\Server Setup you have created with all the files that you have downloaded.

Check that the following settings are turned on for SQL Server:
From the start menu open the SQL Server Configuration Manager

Expand the Server tree select the relevant SQL server, in this case MSSQLSERVER

Make sure that both Named Pipes and TCP/IP are enabled.
Close SQL Server Configuration Manager.
Now you need to make sure that SQL Server will allow both Windows connections and SQL connections.
From the start menu open SQL Server Management Studio

Select the Server name you wish to connect to,( in this case SQL is the Server Name) and click Connect



Right mouse click on the Server root and select Properties

Select the Security option


Make sure that the 'SQL Server and Windows Authentication mode' is selected.

Minimise the SQL Server Management studio window.



  • No labels