I’m trying to run my Yii app on a Live 3rd party server. The issue I have is that I’m using MSSQL on a completely different server. Currently I’m getting the error “CDbConnection failed to open the DB connection: could not find driver”. The MSSQL database is using Windows Plesk (also 3rd party), the website is using Linux.
My Questions are
What are the missing drivers?
Where (Server/Folder) and How do I install them (if necessary)?
By the error message "Could not find server" I would say that the problem is in the connection settings or the database server setup… not in the missing drivers…
Instead of the domain try with the IP address of the server, also check if you can connect to that server with some management tool to see if the server is configured right for remote connection.
I’m able to connect to my DB via Microsoft Data Link .udl, however my problem still persists. I tried using the IP address but the error is still the same.