| Panel | ||
|---|---|---|
| ||
|
| Note | ||
|---|---|---|
| ||
Please stop all the callcenter activities before starting the MSSQL odbc driver installation. It may cause server downtime. |
1 Prerequisites and minimum requirements
| Note | ||||
|---|---|---|---|---|
| ||||
The minimum working and supported configuration is: MSSQL Server 2008 R2 Express installed on Windows 2008 R2 SP1 |
2 Download the Microsoft SQL ODBC drivers
| Code Block | ||
|---|---|---|
| ||
[root@localhost ~]# cd /usr/src
[root@localhost src]# curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
193 193 193 193 0 0 566 0 --:--:-- --:--:-- --:--:-- 5216 |
3 Backup the current odbc configuration
| Code Block | ||
|---|---|---|
| ||
[root@localhost src]# mv /etc/odbc.ini /etc/odbc.ini.bck |
4 Install the MSSQL ODBC drivers and the dependencies
| Info | ||
|---|---|---|
| ||
Please note the odbc driver release may change, check the current driver release here |
| Code Block | ||
|---|---|---|
| ||
[root@localhost src]# yum remove unixODBC [root@localhost src]# sudo ACCEPT_EULA=Y yum install msodbcsql mssql-tools --nogpgcheck [root@localhost src]# sudo yum install unixODBC-devel freetds freetds-devel mysql-connector-odbc |
5 Restore the original odbc configuration
| Code Block | ||
|---|---|---|
| ||
[root@localhost src]# mv /etc/odbc.ini.bck /etc/odbc.ini mv: overwrite `/etc/odbc.ini'? y |
6 Configure the MSSQL ODBC source into the Motion GUI
Add a new ODBC source and insert the MSSQL connection string (check and copy the correct driver name into /etc/odbc.ini or /etc/odbcinst.ini eg. [ODBC Driver 13 for SQL Server]):
| Code Block |
|---|
DRIVER=ODBC Driver 13 for SQL Server;SERVER=<SERVER IP>;UID=<USER>;PWD=<PASSWORD>;DATABASE=<DBNAME> Example using standard port 1433 (port can be omitted): DRIVER=ODBC Driver 13 for SQL Server;SERVER=192.168.2.148;UID=xcally;PWD=xcally;DATABASE=XCALLY Example using non standard port (eg. 11433) DRIVER=ODBC Driver 13 for SQL Server;SERVER=192.168.2.148,11433;UID=xcally;PWD=xcally;DATABASE=XCALLY |
| Note | ||
|---|---|---|
| ||
| Don't forget to write the port after IP address separated by comma if you are using a port different than default 1433 |
If everything is ok, the connection should be verified clicking TEST ODBC in the ODBC specific drop-down menu and as the result should be appear a popup on right top corner saying "ODBC properly tested! Connection Succeded"
If something wrong (popup with error message) than check Server IP, port, UID and password. If you are sure they are correct go on reading this wiki.
| Note | ||
|---|---|---|
| ||
ATTENTION: Port used by default is 1433. Make sure in SQL Server Configuration Manager that network protocol TCP/IP is enabled and that you disabled "TCP dynamic ports" (leave field empty) and write port 1433 (or other port if using a different port) in "TCP port" field (IPAll section) After modify don't forget to restart SQL service |
7 Use the MSSQL database in the CallySquare project
| Page Properties | ||
|---|---|---|
| ||
|