We want to store clarity test and production environment DB on the same MS SQL db server and same instance.
Is it possible to do it?
Can we use different DB names instead of "niku"?
Its always best to have a separate dedicated DB server for your production database for optimal performance. I guess storing both the Prod and Test DBs in one DB server, in the same instance, can lead to serious performance issues in your production environment.
But technically, this should be possible as you can see from The specified item was not found.
Yes easily "possible", just not normally "recommended".
Simple config in the NSA/CSA - on the database tab you just tell clarity where the relevant database is - clarity does not really care where the database is, just as long as it can find it!
not normally "recommended" relates to one of the instances being prod and that is presumably because of the risk of getting it messed up and down time while restoring. With test and training the effect of the risk is lower. That is not limited to MS SQL, but applies to Oracle as weel.
If you read the installation guide it says something like that you can name the database whatever you want, but the database user name has to be "niku"
If you go ahead and have two instances on the same db server are you going to have one or two app servers? You can have two instances on one app server if you differentiate the with all different ports.
Retrieving data ...