{"id":2639,"date":"2012-01-31T13:37:59","date_gmt":"2012-01-31T21:37:59","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/2639\/how-to-grant-the-permissions-to-sql-server-user\/"},"modified":"2017-03-14T01:56:24","modified_gmt":"2017-03-14T08:56:24","slug":"permissions-required-for-installing-topteam-database-objects-into-an-existing-sql-server-database","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/2639\/permissions-required-for-installing-topteam-database-objects-into-an-existing-sql-server-database\/","title":{"rendered":"Permissions required for installing TopTeam Database Objects into an existing SQL Server Database"},"content":{"rendered":"<p>\t<!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">What is this article about?<\/h3>\n<div class=\"StepInstructions\">\n<p>This article describes which permissions are required to install <i>TopTeam Database Objects<\/i> and how to grant those permissions to <i>SQL Server<\/i> L<i>ogins<\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>Database Administrators<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Prerequisites<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>You must have <i>Administrative <\/i>permissions to grant &#8220;<strong>db_owner<\/strong>&#8221; <i>Database Roles<\/i> to <i>SQL Server Logins<\/i>.<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 1. Run SQL Server Management Studio from Windows App menu<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2017\/03\/wpid32368-SSMS.png\" width=\"343\" height=\"63\" alt=\"wpid32368-SSMS.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 2. Log into SQL Server<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2017\/03\/wpid32366-Login.png\" width=\"412\" height=\"310\" alt=\"wpid32366-Login.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 3. Select the Login who will install TopTeam Database Objects into an existing SQL Server Database<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2017\/03\/wpid32367-LoginProperties.png\" width=\"396\" height=\"590\" alt=\"wpid32367-LoginProperties.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 4. Grant Database Roles on TopTeam Database<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2017\/03\/wpid32369-UserMapping.png\" width=\"800\" height=\"704\" alt=\"wpid32369-UserMapping.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>When <i>TopTeam Database Objects<\/i> are installed, the above permissions are not required for day-to-day working.<br \/>\nFor more details, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/20799\/sql-server-roles-and-permissions-required-for-day-to-day-working-with-topteam\/\" target=\"_blank\">SQL Server Roles and Permissions required for day-to-day working with TopTeam.<\/a><\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">See Also<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/23237\/permissions-required-for-sql-server-logins\/\" target=\"_blank\">Permissions required for SQL Server Logins<\/a><\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: November 24th, 2016<\/p>\n<\/div><\/div>\n<\/p><\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is this article about? This article describes which permissions are required to install TopTeam Database Objects and how to grant those permissions to SQL Server Logins. Who should read this? TopTeam Administrators Database Administrators Prerequisites You must have Administrative permissions to grant &#8220;db_owner&#8221; Database Roles to SQL Server Logins. Step 1. Run SQL Server Management Studio from Windows App menu Step 2. Log into SQL Server Step 3. Select the Login who will install TopTeam Database Objects into an existing SQL Server Database Step 4. Grant Database Roles on TopTeam Database When TopTeam Database Objects are installed, the above <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,280,140,9],"class_list":["post-2639","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-installation","tag-permissions","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Gz","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2639"}],"version-history":[{"count":8,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2639\/revisions"}],"predecessor-version":[{"id":32411,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2639\/revisions\/32411"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2639"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}