How to setup the MS SQL Database

Few commands to :

Check the setup in /etc/fstab, the connection mount on the aceriso.

Check the domain mapping to IP address: vi /etc/hosts

1)     Need to edit these 3 files with correct setting host and server IP:

Host: window IP is run MS SQL

Server: window IP that run MS SQL

---/usr/local/etc/freetds.conf ---

[mssqlserver]

               host=10.10.2.200

               port=1433

               tds version =7.0

---/etc/unixODBC/odbcinst.ini ---

[FreeTDS]

Description = v0.63 with protocol v8.0

Driver    =/usr/local/lib64/libtdsodbc.so

UsageCount        =2

---/etc/unixODBC/odbc.ini ---

[mssqlserver]

Driver    =FreeTDS

Description         =usbduplicator database

Trace     =No

Server    = 10.10.2.200

Port       =1433

Database             =usbduplicator

Username           =Postgres

Password             =POSTGRES

2)     Run these commands to setup unixodbc driver:

CD /etc/unixODBC/

odbcinst -i -d -f /etc/unixODBC/odbcinst.ini

odbcinst -I -s -l -f /etc/unixODBC/odbc.ini

odbcinst -j

3)     Run these commands to test your connection, make sure MS SQL already setup

With database, user login, and open port for MS SQL and firewall on the window machine.

Isql MSSQLServer Postgres POSTGRES