- Windows Server 2008 R2
- IIS 7.5
- SQL Server 2008 R2 (Clustered)
We're having an issue connecting to our SQL database through the WP DB Abstraction setup page. We have two test environments that we were able to set this site up on and both of them are working. The only difference between those two test sites and our production set up is that our production database is a SQL cluster and the test ones are stand-alone servers.
The user set up in IIS has full access to write anywhere on our Windows Server and the SQL settings are exactly the same as what we used in the test sites that work.
We did an odbc connection test from the windows server and we were able to connect to the database that we're trying to install on
We also tried defining the port for the database host on the WP DB Abstraction setup page, but that didn't work.
Also, we have a .net site running on that same production windows server and it's able to connect to the same SQL server where we are trying to connect to the WP database.
Does anyone know what else we could be testing?