AnsweredAssumed Answered

MSSQL NSA - Login failed for user

Question asked by Metier on Nov 27, 2015
Latest reply on Nov 30, 2015 by nick_darlington

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?

Outcomes