{"id":20799,"date":"2015-11-24T01:51:52","date_gmt":"2015-11-24T09:51:52","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=20799"},"modified":"2017-03-14T02:52:57","modified_gmt":"2017-03-14T09:52:57","slug":"sql-server-roles-and-permissions-required-for-day-to-day-working-with-topteam","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/20799\/sql-server-roles-and-permissions-required-for-day-to-day-working-with-topteam\/","title":{"rendered":"SQL Server Roles and Permissions required for day-to-day working with TopTeam"},"content":{"rendered":"<p>\t\t<!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Overview<\/h3>\n<div class=\"StepInstructions\">\n<p spacebelow=\"10\">In this document, you will learn which <i>SQL Server Roles and Permissions<\/i> are required in the <i>TopTeam SQL Server<\/i> database for day-to-day working with <i>TopTeam<\/i>.<\/p>\n<p spacebelow=\"10\">\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<p>You must have <i>Administrative<\/i> permissions to grant <i>SQL Server Roles and Permissions<\/i> to <i>SQL Server Logins<\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 1. Configure SQL Server Login<\/h3>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 1.1. Create SQL Server Login<\/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\/wpid28424-media_1478600575451.png\" width=\"393\" height=\"442\" alt=\"wpid28424-media_1478600575451.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\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\/wpid28419-media_1478600087715.png\" width=\"626\" height=\"559\" alt=\"wpid28419-media_1478600087715.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p><strong>NOTE<\/strong>: You can also use an existing <i>Login<\/i>. <\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 2. Configuring Database Roles for Login<\/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\/wpid28420-media_1478600125559.png\" width=\"623\" height=\"560\" alt=\"wpid28420-media_1478600125559.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 3. Configuring Permissions for TopTeam Database Schema<\/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\/wpid28421-media_1478600152311.png\" width=\"431\" height=\"355\" alt=\"wpid28421-media_1478600152311.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\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\/wpid28422-media_1478600195728.png\" width=\"643\" height=\"576\" alt=\"wpid28422-media_1478600195728.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Use this <i>SQL Server Login<\/i> in <i>TopTeam Application Server<\/i> or <i>TopTeam Web Server<\/i> to connect to the <i>TopTeam SQL Server<\/i> database.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\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\/wpid28423-media_1478600259958.png\" width=\"427\" height=\"207\" alt=\"wpid28423-media_1478600259958.png\" \/>\n<\/div>\n<\/p><\/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\/2639\/permissions-required-for-installing-topteam-database-objects-into-an-existing-sql-server-database\/\" target=\"_blank\">Permissions required for installing TopTeam Database Objects into an existing SQL Server Database<\/a><br \/>\n<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>Overview In this document, you will learn which SQL Server Roles and Permissions are required in the TopTeam SQL Server database for day-to-day working with TopTeam. Who should read this? TopTeam Administrators Database Administrators Prerequisites You must have Administrative permissions to grant SQL Server Roles and Permissions to SQL Server Logins. Step 1. Configure SQL Server Login Step 1.1. Create SQL Server Login NOTE: You can also use an existing Login. Step 2. Configuring Database Roles for Login Step 3. Configuring Permissions for TopTeam Database Schema Use this SQL Server Login in TopTeam Application Server or TopTeam Web Server to <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,140,139,9],"class_list":["post-20799","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-permissions","tag-roles","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-5pt","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/20799","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\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=20799"}],"version-history":[{"count":14,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/20799\/revisions"}],"predecessor-version":[{"id":32441,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/20799\/revisions\/32441"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=20799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=20799"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=20799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}