I have trying to stand up a standalone installation of blackpearl with my K2 databases on a seperate server (so it is not exactly a standalone installation). I need to inform my DBA of the roles and permissions needed to install blackpearl correctly. Using the sa account is not an option.
I am using SQL authentication to attach to the K2 databases.
Thanks for your help.
Mike Trouard
For running a k2 environment your accounts will need both db_DataReader and db_DataWriter rights on the SQL databases that are used for K2. The Execute right is also need for stored procedures in this database.
For install purposes you will need additional rights so that the databases can be created. Obviously the right of DBcreator is going to be neccessary.
I believe that should be it....Can anyone correct me?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.