Hi,
We are trying to setup continua CI on virtual machine and our SQL database is on azure server. But we are facing problem while building connection string during continua CI server setup.
we are unable to test provided connection string even after passing correct credentials. So Is it due do to permission issue or Are there any other steps we need to follow to connect azure SQL database.
Thanks,
PRavin
Hi Pravin,
We have not tested Continua with Azure SQL Database and therefore it is not supported at the moment.
The installer uses the SQLOLEDB provider to test the database connection and I understand that Azure SQL does not support this, which is the likely reason for your issue.
You could try installing with a local database string then editing the connection.connection_string property in Continua.Server.Service.exe.config (under hibernate-configuration/session-factory) to point to your Azure database. We cannot say whether the server willl run without error as Azure SQL does not include all the features of SQL Server.
We do plan to investigate supporting Azure SQL Database in the future.
It’s been over a year since this was posted. Is Azure SQL supported yet or no?
Hi Mike
We do still hope to add azure sql support eventually, unfortunately the drivers we need to use (for nhibernate) require .net 4.5, and we are still supporting Server 2003(which is not supported by .net 4.5). For 2.0 we will be dropping server 2003 support so will make the jump to 4.6.1.
We have a branch in dev that has been converted to .net 4.6.1 and are working through some breaking issues (like wcf certificate support being broken), and we have yet to complete the planned 2.0 features so I don’t have a timeframe. As soon as we have a usable 2.0 installer we’ll get into azure testing. We also do not know what sql features we might be using that may not be supported on azure, so it’s not guaranteed to work without change.