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 ( Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured.

[http-8090-4] union.persistence ( 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?