I have been pounding my head against the wall on this for a while, and I am about ready to give up.
I have been tasked with installing Drupal 7.27 on a Red Hat Enterprise Linux 5 server, and use a MS SQL 2008 R2 database.
I have installed freetds, and was able to successfully create a test php file that connected to the database and returned information. I was also able to connect to the database using:
tsql -H hostname -p port -U username
I am using the dlib module for Drupal, and when I go through the steps to install I get all the way to selecting the database type and entering in the username and password. MS SQL Database is listed as an option, and I have verified all neccessary information (database, username, password, etc.). When I click save and continue I recieve this error:
SQLSTATE[HY000] Unknown host machine name (severity 2)
Has anyone been able to successfully install Drupal on a Linux server with MS SQL as the database?
Any advice would be greatly appreciated.
Drupal is connecting to the database, and creating all of the neccessary tables, but cancels the setup process saying that the tables are already created... Well duh! It created the tables! So We are a little further along, but still not quite there.