I am receiving the following error when cruisecontrol executes my database build scripts:
Unexpected error: The database <dbName> is not linked to SQL Source Control
The scripts work perfectly when I execute them from the build server, but when cruisecontrol executes them we receive that error. While configuring this build process I was logged into the build terminal as myself and linked the database to SVN with SQL Source Control therefore it runs perfectly under my account. The issue seems to be that the cruisecontrol service runs under a service account and the db is not linked to SVN under that service account. Is there a way to make this work regardless of the account the service runs under. For example, is it possible to link a database to SVN for all users of a terminal?
A few things to note:
- It is not practical to run the cruisecontrol service under a non-service account for security reasons.
It is not practical to logon to a machine under a service account in order to link the databases to SVN.
Any feedback on this matter is greatly appreciated.