We're trying to install the beta to a new virtual machine having SQL Server Express 2012 installed. The installation is otherwise basically default, except that the instance name is MSSQLSERVER instead of the default SQLEXPRESS.
Unfortunately we cannot get the connection to work at all when trying to use the SQL Server Express 2008 option.
If the (default) instance name is omitted the Test Connection -option gives an error
--------------------------- Setup --------------------------- Failed to connect.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. --------------------------- OK ---------------------------
When the instance name is included in the connection string the error is:
--------------------------- Setup --------------------------- Failed to connect.
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection. --------------------------- OK ---------------------------
What steps should we take to get the product to connect to the database?
I was able to continue with the installation, and got the product to install. However the database connection string was missing from the configuration file (C:\Program Files\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config).
When a connection string was manually entered (Server=localhost;Database=ContinuaCI;Trusted_Connection=True
Hmmm… I believe the hg issues should be fixed in the build we just uploaded, will check with the team tomorrow. We’ll be testing with 2012 tomorrow and update the installer to support it.
Ok, I’ll get Ben to look at that tomorrow. The way it is supposed to work is to check the path first, and then use the version we install… not sure why it’s not finding it.
I was able to work around the issue by adding the path to the installed hg.exe to the system path and restarting the service. Obviously something that needs to be addressed, but at least it’s working now for us.