Hi I have a weird behavior from newly copied Clarity environment.
The environment consists of a restored VHD with Clarity 12.1.0 on. A Clarity 12.1.0 database which have been restored to both a MSSQL 2008 and 2012 for testing purposes.
However when i try to connect Clarity though the NSA to the DB i get the following errors in nsa-niku log.
[http-8090-4] niku.nsa (sa:znPNZINfPartKfTNOxkhWSi93fahAnAJJTl7vhNDkT0=:nsa.properties.database.save) Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured.
[http-8090-4] union.persistence (sa:znPNZINfPartKfTNOxkhWSi93fahAnAJJTl7vhNDkT0=:nsa.properties.database) Database not available (java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Login failed for user 'niku'.)
The DB user niku, is fully working, owns the scheme and has db_owner access. I can login in to the database with SQL Management so the user should work.
Any ideas what can cause this behavior?