12-03-2013
06:24 AM
- last edited on
03-25-2019
09:10 PM
by
ciscomoderator
Hi,
We are looking to upgrade TMS 12.6.2 (running TMS agents) to version TMS 13.2 + TMSPE 1.0. The tmsng db is currenty pointing to an external SQL server and as per the deployment guides, I am looking to install the tmspe db in the same way.
My question is based around the db permission of the tmspe, Would this need to have DB-owner privledges as per the deployment guides? Or can I assign sys-admin rights to this and face no issues with doing this?
Solved! Go to Solution.
12-03-2013 06:52 AM
Hi,
I always had dbowner rights on the tmspe db and that worked fine, but isn't sysadmin a much higher privilege level which allows you to do everything? If so, this will work well altough I would not recommend to leave it with that high privilege due to security reasons.
Best regards,
Alex
12-03-2013 06:52 AM
Hi,
I always had dbowner rights on the tmspe db and that worked fine, but isn't sysadmin a much higher privilege level which allows you to do everything? If so, this will work well altough I would not recommend to leave it with that high privilege due to security reasons.
Best regards,
Alex
12-03-2013 10:01 AM
As long as its just an upgrade and not a "create" as in a new installation it should be sufficient with db_owner. It will fail doing the upgrade if the permissions is insufficient and nothing is done with the database. Increase the permissions and try again. Always make backups
/Magnus
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide