{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Service accounts contain passwords that do not expire. They are domain accounts used to connect to sql server data and files. On Premise gateway connections will be configured with windows security to access sql databases and files. Password for the accounts are stored in ","type":"text"},{"text":"secret serve","type":"text","marks":[{"type":"link","attrs":{"href":"https://ps.sa.ucsb.edu/"}}]},{"text":"r.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Instructions","type":"text"}]},{"type":"paragraph","content":[{"type":"placeholder","attrs":{"text":"Create a step-by-step guide:"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure that the ID used in the gateway connection has sql server access to view or execute SQL data objects.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"USE [master]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"},{"type":"hardBreak"},{"text":"CREATE LOGIN [sa\\IUSR_Bi_ISISTest] FROM WINDOWS WITH DEFAULT_DATABASE=[master]","type":"text"},{"type":"hardBreak"},{"text":"GO","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"add user to the database CREATE USER [] FOR LOGIN []","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"add user to an db role","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"grant access to the role for the required dataset or data flow.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Configure Gateway connection to the data source. ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the user id based on the database and environment. Password for the accounts are stored in ","type":"text"},{"text":"secret serve","type":"text","marks":[{"type":"link","attrs":{"href":"https://ps.sa.ucsb.edu/"}}]},{"text":"r.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The authentication should be windows","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set ","type":"text"},{"text":"the Privacy Level to Organizational ","type":"text","marks":[{"type":"link","attrs":{"href":"https://powerbi.microsoft.com/en-us/blog/privacy-levels-for-cloud-data-sources/"}}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":581,"id":"b938c7dd-2ff9-4d27-9dd7-183fa0125e19","collection":"contentId-1076003532","type":"file","height":681}}]},{"type":"paragraph"}]}]}]}]},{"type":"paragraph","content":[{"text":" 3. Use the following slack command to create new service accounts","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"a. sysbot serviceaccount create - Request New Service Account","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is an example : ","type":"text"},{"text":"sysbot serviceaccount create IUSR_Bi_ISIS owners=SSIS sa \"Service account for Power BI Account application\"","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Users accounts must be 15 chars or less not including the environment. The sysbot command creates an account for dev, test and prod. ","type":"text"}]},{"type":"paragraph","content":[{"text":"More information on sysbot for service accounts and permissions.","type":"text"}]},{"type":"paragraph","content":[{"text":"To get a list of all sys bot commands @sysbot help","type":"text"}]},{"type":"paragraph","content":[{"text":"sysbot ","type":"text"},{"text":"db create “[notes]”","type":"text","marks":[{"type":"strong"}]},{"text":" - Request New Database","type":"text"},{"type":"hardBreak"},{"text":"sysbot ","type":"text"},{"text":"db guidelines","type":"text","marks":[{"type":"strong"}]},{"text":" - Info about Service Accounts","type":"text"}]},{"type":"paragraph","content":[{"text":"sysbot ","type":"text"},{"text":"serviceaccount create ","type":"text","marks":[{"type":"strong"}]},{"text":" - Request New Service Account","type":"text"}]},{"type":"paragraph","content":[{"text":"for example to create a service account for identitystaging","type":"text"}]},{"type":"paragraph","content":[{"text":"@sysbot serviceaccount create IUSR_Bi_IdStg owners=DATA sa \"Service account for PBI identitystaging","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"sysbot ","type":"text"},{"text":"db permission create ","type":"text","marks":[{"type":"strong"}]},{"text":" - Request New Database Permission","type":"text"}]},{"type":"paragraph","content":[{"text":"Please note that within the domainaccount name {env} should not be set to a value. It should either be omitted our used as the literal value of ‘{env}’.","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"table","attrs":{"layout":"default","localId":"e3568735-9d97-46df-b99b-b3d6e4a49b06"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Database","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Environment","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"User ID","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"IdentityStaging","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_IdStgTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_IdStg","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"ProSam","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Test (GradDiv)","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod (GradDiv)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_ProSmTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSmTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_ProSm","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSm","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"ISIS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod (GradDiv Finance Ops)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_ISISTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_ISIS","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\ISVC_GradRpt","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"CAPS-Custom","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_CAPSCTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_CAPSC","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"SHS-Custom","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_SHSCTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\IUSR_Bi_SHSC","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"GradDiv","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test (GradDiv Finance Ops)","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod (GradDiv Finance Ops)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSmTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSm","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Graddiv_Services","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod (GradDiv Finance Ops)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSmTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSm","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"SADW","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Test","type":"text"}]},{"type":"paragraph","content":[{"text":"Test (GradDiv Finance Ops)","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod","type":"text"}]},{"type":"paragraph","content":[{"text":"Prod (GradDiv Finance Ops)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"sa\\","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSmTest","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\","type":"text"}]},{"type":"paragraph","content":[{"text":"sa\\SQLReportingPrSm","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Create ReportingRole and assign the system account","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"ecfd615f-693e-4240-8c48-34183ceebeb6"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph","content":[{"text":"database","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph","content":[{"text":"sysbot","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph","content":[{"text":"ISIS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph","content":[{"text":"sysbot db permission create ISIS IUSR_Bi_ISIS ReportingRole createrole=true","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph","content":[{"text":"ProSam","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph","content":[{"text":"sysbot db permission create ProSam IUSR_Bi_ProSm ReportingRole createrole=true","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[179.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[671.0]},"content":[{"type":"paragraph"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Related articles","type":"text"}]},{"type":"paragraph","content":[{"type":"placeholder","attrs":{"text":"The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon."}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"contentbylabel","parameters":{"macroParams":{"showLabels":{"value":"false"},"max":{"value":"5"},"spaces":{"value":"com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@9f2"},"sort":{"value":"modified"},"showSpace":{"value":"false"},"reverse":{"value":"true"},"type":{"value":"page"},"cql":{"value":"label = \"kb-how-to-article\" and type = \"page\" and space = \"PB\""},"labels":{"value":"kb-how-to-article"}},"macroMetadata":{"macroId":{"value":"d8ee74a8-57f3-4771-8dfb-65a6fd1ccb74"},"schemaVersion":{"value":"4"},"title":"Content by Label"}},"localId":"f1c59067-c338-4a0e-acd4-32579fd348e6"}},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"details","parameters":{"macroParams":{"hidden":{"value":"true"}},"macroMetadata":{"macroId":{"value":"fad6609b-dadb-460a-8f15-94e2f051e37f"},"schemaVersion":{"value":"1"},"title":"Page Properties"}},"localId":"6ebeb178-6ebf-48ad-a9bc-976da0267679"},"content":[{"type":"table","attrs":{"layout":"default","localId":"973361c9-03ea-4753-860c-5a21153a8cd6"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[541.0]},"content":[{"type":"paragraph","content":[{"text":"Related issues","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[275.0]},"content":[{"type":"paragraph"}]}]}]}]}],"version":1}