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
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...