Connecting to SQL Server using DBeaver / Eclipse

1. Open Eclipse, either using the start menu or desktop shortcut.

2. Make sure your in the DBeaver perspective

   1. Window → Perspective → Open Perspective → Other
      
      

      Open

      

   2. Pick DBeaver from the list and click open.
      
      

      Open

      

3. Make sure you have a project in your workspace, these appear in the projects pane on the left hand side. Only if you don't already have a project, create one:

   1. File → New → Project
      
      

      Open

      

   2. Pick a type of 'Project' under 'General', click next
      
      

      Open

      

   3. Give it a name, and click next.
      
      

      Open

      

4. Create a connection

   1. Expand your project using the arrow to the left of its name, right click on the connections heading and pick 'Create a new connection'
      
      

      Open

      

   2. Expand MS SQL Server and Pick 'Microsoft Driver' from the list of connection types and then click next.
      
      

      Open

      

   3. Enter the host and database names, also check the Windows Authenticaiton box. Click Finish.
      The host and database should be set to:
      Host: hirusql3
      Database: ukserpdsb
      
      

      Open

      

   4. You may be asked to download the drivers, If so first click the blue text "Download Configuration"
       

      Open

      

      
      Set the proxy host and port, then Apply and Close
      Host: 192.168.10.15
      Port: 8080
      
      

      Open

      

      
      Now click Download.

5. Run a query against the data
   
   

   1. Either open an existing SQL file from your existing project or create a new one by right clicking within your project and choosing 'Create SQL script'.
      
      

      Open

      

   2. Use the yellow arrow to the left hand side of the SQL editor to run your query. The results will show in the pane at the bottom of the screen.
      
      

      Open

      

.