Tridion 2011 SP1 Database Manager error
Solution 1:
Don't worry it's not an error, but a warning. When installing the CMS it will add the right policies to the user, but as the db is created first, this has not been done YET. I know I know, confusing and partly my fault as I noticed it during the 5.0 product when I was still in charge of the installers, yet did not want to delay the release to change the message :) sorry!
To SDL R&D: please change the wording, ow and also the message when closing the TDM, I always think I close it while it's still doing something.
Solution 2:
It was a design requirement of the Tridion Database Manager that it should be capable of running from a completely different machine than the Content Manager, and in principle from a machine with completely different security configuration.
When you enter the account details, it does "best effort" to help you avoid some obvious mistakes, but given the above, it's impossible for this to be more than a warning. What that text actually means is: "We fully understand that you might know more about your environment than this software is able to detect, so please interpret this warning based on your own knowledge."
When you provide your credentials, it attempts to log on "as a batch job". If it fails, then you get a warning.
Solution 3:
I haven't seen that error in a while, so there may be something wrong with it. The worst that can happen if you proceed is that
- you may have to change some permission for the user or
- change the user name in the TRUSTEES table later.
Logon type not granted suggests that the MTSUser account is not allowed to either login as a batch or login interactively (not sure which one the DB manager is trying to use), and it's easy to solve in any case.
If the installer gives you the same trouble, then it's more problematic. All the DB manager does with this info is to add the user to the TRUSTEES table.