How can we help you today? How can we help you today?

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.
bitshift
0

Comments

1 comment

  • bitshift
    OK, I've found out where I can change the database seetings: SmartAssembly 8 -> Left-hand menu -> Tools -> Options - Database Options.
    bitshift
    0

Add comment

Please sign in to leave a comment.