How do I create a DSN for GroupWare
Posted by - NA -, Last modified by Said Khammar on 10 June 2014 06:06 AM

OS: Windows; IceWarp Server Version: 11

Introduction

If you are using Microsoft SQL Server, you will need to setup a ODBC DSN (Data Source Name) manually. It will store the information  to connect to the database server.

Creating the ODBC link

On the machine hosting your IceWarp server. You MUST configure it twice in the exact same way for 32 and 64 bits.

Path for the 32 bits versions : C:\Windows\System32\odbcad32.exe

Path for the 64 bits version : C:\Windows\SysWOW64\odbcad32.exe

Run them as Administrator.

 

Choose the System DSN tab and click Add.

 

 

 

 

Select SQL Server

Click the Finish button.

 

 

 

Enter a name in the Name box (you will need to remember this for the configuration of Icewarp)

Type the server name or IP address in the Server box, then click Next

 

 

Then select With SQL Server authentication using a login ID and password entered by the user.

Enter your Login ID and the associated password

 

 

 

Then click on Client configuration...

Untick the box Dynamically determine port and make sure the port is 1433. Make sure this port is opened in your FireWall.

 

 

 

Click OK then Next

Tick the box Change the default database to and select the database you want to use, then click Next

 

 

 

On next screen click on Finish

Now time to Test the connection, so click on Test Data Source...

You should get the following screen :

 

 

 

Click on OK then OK

Reminder : those steps should be done twice

Configuring Groupware database settings

Go to the Administration console. Groupware > General and click on DB Settings...

 

 

  • In Driver, select ODBC
  • in Syntax select Microsoft SQL
  • In Primary connection, enter your database server IP or name, username, password and select the database then test the connection by clicking on Test Connection to make sure it will work fine.
  • Click on Create Tables then OK.