SQL Server Configuration

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.