What are the challenges you face when working across database platforms? Take the survey

SmartAssembly 8 Error accessing SQLExpress database

I need to run Smartassembly inside our automated CI builds. We are using Jenkins. The Jenkins slave runs as LOCAL SERVICE on the build machine. I have set up SmartAssembly 8 as a local user on the machine.

I can build the project from a command prompt fine, it will obfuscate correctly.
But when the build slave build it, it gets these errors:
SmartAssembly has encountered an error while running your project.
  Failed: SmartAssembly.InformationException: Unable to connect to the SQL database:
  'Cannot open database "SmartAssembly" requested by the login. The login failed.
  Login failed for user 'WORKGROUP\<computername>$'.'
A search in the forums has told me that SmartAssembly should be able to use a sqlite database instead of an SQLExpress database, but how can I configure that? There is no option to choose a database in SmartAssembly 8.
Connection string:
  Server=localhost\SQLExpress;Integrated security=SSPI;database=SmartAssembly; ---> System.Data.SqlClient.SqlException: Cannot open database "SmartAssembly" requested by the login. The login failed.


Sign In or Register to comment.