https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78962#M30923 Hello,&nbsp;<BR /><BR />Till now I have only seen making use of SQL server installed on a VM (Server ) and we use windows authentication to connect to it, while configuring Blue Prism but I would like to use Azure SQL DB as a service where no windows authentication would be possible. I searched but couldn't find proper documentation on this.&nbsp; Can anyone suggest if there is any extra step to perform? or any helpful documentation?<BR /><BR />Thanks in advance,<BR />Nabin<BR /><BR />------------------------------<BR />Nabin Timalsina<BR />Infrastructure Engineer<BR />------------------------------<BR /> Tue, 30 Mar 2021 08:22:00 GMT NabinTimalsina 2021-03-30T08:22:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78962#M30923 Hello,&nbsp;<BR /><BR />Till now I have only seen making use of SQL server installed on a VM (Server ) and we use windows authentication to connect to it, while configuring Blue Prism but I would like to use Azure SQL DB as a service where no windows authentication would be possible. I searched but couldn't find proper documentation on this.&nbsp; Can anyone suggest if there is any extra step to perform? or any helpful documentation?<BR /><BR />Thanks in advance,<BR />Nabin<BR /><BR />------------------------------<BR />Nabin Timalsina<BR />Infrastructure Engineer<BR />------------------------------<BR /> Tue, 30 Mar 2021 08:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78962#M30923 NabinTimalsina 2021-03-30T08:22:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78963#M30924 <P>Hi Nabin,</P> <P>You can refer page 53 of <A href="https://portal.blueprism.com/system/files/documents/v6.9%20User%20Guide%20-%20Installing%20Enterprise%20Edition_6.pdf" target="_blank" rel="noopener">v6.9 User Guide - Installing Enterprise Edition (blueprism.com)</A></P><BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Tue, 30 Mar 2021 12:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78963#M30924 GopalBhaire 2021-03-30T12:51:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78964#M30925 Great found it thanks much, also now I encounter new error, while making connection to DB I get error message saying "This doesn't appear to be valid Blue Prism database" . I have Standard DB of 10 DTUs. is there a documentation on Azure DB specification as well?&nbsp;<BR /><span class="lia-inline-image-display-wrapper" image-alt="18669.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18820i3B070EC85A28E5A5/image-size/large?v=v2&amp;px=999" role="button" title="18669.png" alt="18669.png" /></span><BR />Thank you,&nbsp;<BR />Nabin<BR /><BR />------------------------------<BR />Nabin Timalsina<BR />Infrastructure Engineer<BR />------------------------------<BR /> Wed, 31 Mar 2021 06:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78964#M30925 NabinTimalsina 2021-03-31T06:48:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78965#M30926 <P>Hi,</P> <P>I think it is because the database you are connecting to is not a Blue Prism database. You can click on Create DB button on BP connection config screen and select drop any existing DB to replace the connected DB as Blue Prism database or give a new name in connection string and create a new Blue Prism DB altogether.&nbsp;</P> <DIV class="ms-editor-squiggler" style="color: initial; font: initial; font-feature-settings: initial; font-kerning: initial; font-optical-sizing: initial; font-variation-settings: initial; forced-color-adjust: initial; text-orientation: initial; text-rendering: initial; -webkit-font-smoothing: initial; -webkit-locale: initial; -webkit-text-orientation: initial; -webkit-writing-mode: initial; writing-mode: initial; zoom: initial; place-content: initial; place-items: initial; place-self: initial; alignment-baseline: initial; animation: initial; appearance: initial; aspect-ratio: initial; backdrop-filter: initial; backface-visibility: initial; background: initial; background-blend-mode: initial; baseline-shift: initial; block-size: initial; border-block: initial; border: initial; border-radius: initial; border-collapse: initial; border-end-end-radius: initial; border-end-start-radius: initial; border-inline: initial; border-start-end-radius: initial; border-start-start-radius: initial; inset: initial; box-shadow: initial; box-sizing: initial; break-after: initial; break-before: initial; break-inside: initial; buffered-rendering: initial; caption-side: initial; caret-color: initial; clear: initial; clip: initial; clip-path: initial; clip-rule: initial; color-interpolation: initial; color-interpolation-filters: initial; color-rendering: initial; color-scheme: initial; columns: initial; column-fill: initial; gap: initial; column-rule: initial; column-span: initial; contain: initial; contain-intrinsic-size: initial; content: initial; content-visibility: initial; counter-increment: initial; counter-reset: initial; counter-set: initial; cursor: initial; cx: initial; cy: initial; d: initial; display: block; dominant-baseline: initial; empty-cells: initial; fill: initial; fill-opacity: initial; fill-rule: initial; filter: initial; flex: initial; flex-flow: initial; float: initial; flood-color: initial; flood-opacity: initial; grid: initial; grid-area: initial; height: 0px; hyphens: initial; image-orientation: initial; image-rendering: initial; inline-size: initial; inset-block: initial; inset-inline: initial; isolation: initial; letter-spacing: initial; lighting-color: initial; line-break: initial; list-style: initial; margin-block: initial; margin: initial; margin-inline: initial; marker: initial; mask: initial; mask-type: initial; max-block-size: initial; max-height: initial; max-inline-size: initial; max-width: initial; min-block-size: initial; min-height: initial; min-inline-size: initial; min-width: initial; mix-blend-mode: initial; object-fit: initial; object-position: initial; offset: initial; opacity: initial; order: initial; origin-trial-test-property: initial; orphans: initial; outline: initial; outline-offset: initial; overflow-anchor: initial; overflow-wrap: initial; overflow: initial; overscroll-behavior-block: initial; overscroll-behavior-inline: initial; overscroll-behavior: initial; padding-block: initial; padding: initial; padding-inline: initial; page: initial; page-orientation: initial; paint-order: initial; perspective: initial; perspective-origin: initial; pointer-events: initial; position: initial; quotes: initial; r: initial; resize: initial; ruby-position: initial; rx: initial; ry: initial; scroll-behavior: initial; scroll-margin-block: initial; scroll-margin: initial; scroll-margin-inline: initial; scroll-padding-block: initial; scroll-padding: initial; scroll-padding-inline: initial; scroll-snap-align: initial; scroll-snap-stop: initial; scroll-snap-type: initial; shape-image-threshold: initial; shape-margin: initial; shape-outside: initial; shape-rendering: initial; size: initial; speak: initial; stop-color: initial; stop-opacity: initial; stroke: initial; stroke-dasharray: initial; stroke-dashoffset: initial; stroke-linecap: initial; stroke-linejoin: initial; stroke-miterlimit: initial; stroke-opacity: initial; stroke-width: initial; tab-size: initial; table-layout: initial; text-align: initial; text-align-last: initial; text-anchor: initial; text-combine-upright: initial; text-decoration: initial; text-decoration-skip-ink: initial; text-indent: initial; text-overflow: initial; text-shadow: initial; text-size-adjust: initial; text-transform: initial; text-underline-offset: initial; text-underline-position: initial; touch-action: initial; transform: initial; transform-box: initial; transform-origin: initial; transform-style: initial; transition: initial; user-select: initial; vector-effect: initial; vertical-align: initial; visibility: initial; -webkit-app-region: initial; border-spacing: initial; -webkit-border-image: initial; -webkit-box-align: initial; -webkit-box-decoration-break: initial; -webkit-box-direction: initial; -webkit-box-flex: initial; -webkit-box-ordinal-group: initial; -webkit-box-orient: initial; -webkit-box-pack: initial; -webkit-box-reflect: initial; -webkit-highlight: initial; -webkit-hyphenate-character: initial; -webkit-line-break: initial; -webkit-line-clamp: initial; -webkit-mask-box-image: initial; -webkit-mask: initial; -webkit-mask-composite: initial; -webkit-perspective-origin-x: initial; -webkit-perspective-origin-y: initial; -webkit-print-color-adjust: initial; -webkit-rtl-ordering: initial; -webkit-ruby-position: initial; -webkit-tap-highlight-color: initial; -webkit-text-combine: initial; -webkit-text-decorations-in-effect: initial; -webkit-text-emphasis: initial; -webkit-text-emphasis-position: initial; -webkit-text-fill-color: initial; -webkit-text-security: initial; -webkit-text-stroke: initial; -webkit-transform-origin-x: initial; -webkit-transform-origin-y: initial; -webkit-transform-origin-z: initial; -webkit-user-drag: initial; -webkit-user-modify: initial; white-space: initial; widows: initial; width: initial; will-change: initial; word-break: initial; word-spacing: initial; x: initial; y: initial; z-index: initial;"></DIV><BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Wed, 31 Mar 2021 07:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78965#M30926 GopalBhaire 2021-03-31T07:03:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78966#M30927 Hello Gopal,&nbsp;<BR /><BR />Yes, I tried but as it's Azure DB as Service, it is not allowing me to drop the DB even the user has db_owner role. I tried just to create a DB but it also gave me this error:&nbsp;<BR /><span class="lia-inline-image-display-wrapper" image-alt="18671.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18824i54DAF2BB5CFFCB4F/image-size/large?v=v2&amp;px=999" role="button" title="18671.png" alt="18671.png" /></span><BR />Is any extra permission required for this? I also gave db_reader and db_writer role as well.&nbsp;<BR /><BR />Thank you,<BR />Nabin<BR /><BR />------------------------------<BR />Nabin Timalsina<BR />Infrastructure Engineer<BR />------------------------------<BR /> Wed, 31 Mar 2021 07:31:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78966#M30927 NabinTimalsina 2021-03-31T07:31:00Z https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78967#M30928 <P>Hi,</P> <P>I am not sure about why you are getting the error (I had dbmanager role when I tried).</P> <P>But you can use Generate Script feature in Blue Prism and generate the script which you can then run in Azure Data Studio or in Query Editor.</P> <DIV class="ms-editor-squiggler" style="color: initial; font: initial; font-feature-settings: initial; font-kerning: initial; font-optical-sizing: initial; font-variation-settings: initial; forced-color-adjust: initial; text-orientation: initial; text-rendering: initial; -webkit-font-smoothing: initial; -webkit-locale: initial; -webkit-text-orientation: initial; -webkit-writing-mode: initial; writing-mode: initial; zoom: initial; place-content: initial; place-items: initial; place-self: initial; alignment-baseline: initial; animation: initial; appearance: initial; aspect-ratio: initial; backdrop-filter: initial; backface-visibility: initial; background: initial; background-blend-mode: initial; baseline-shift: initial; block-size: initial; border-block: initial; border: initial; border-radius: initial; border-collapse: initial; border-end-end-radius: initial; border-end-start-radius: initial; border-inline: initial; border-start-end-radius: initial; border-start-start-radius: initial; inset: initial; box-shadow: initial; box-sizing: initial; break-after: initial; break-before: initial; break-inside: initial; buffered-rendering: initial; caption-side: initial; caret-color: initial; clear: initial; clip: initial; clip-path: initial; clip-rule: initial; color-interpolation: initial; color-interpolation-filters: initial; color-rendering: initial; color-scheme: initial; columns: initial; column-fill: initial; gap: initial; column-rule: initial; column-span: initial; contain: initial; contain-intrinsic-size: initial; content: initial; content-visibility: initial; counter-increment: initial; counter-reset: initial; counter-set: initial; cursor: initial; cx: initial; cy: initial; d: initial; display: block; dominant-baseline: initial; empty-cells: initial; fill: initial; fill-opacity: initial; fill-rule: initial; filter: initial; flex: initial; flex-flow: initial; float: initial; flood-color: initial; flood-opacity: initial; grid: initial; grid-area: initial; height: 0px; hyphens: initial; image-orientation: initial; image-rendering: initial; inline-size: initial; inset-block: initial; inset-inline: initial; isolation: initial; letter-spacing: initial; lighting-color: initial; line-break: initial; list-style: initial; margin-block: initial; margin: initial; margin-inline: initial; marker: initial; mask: initial; mask-type: initial; max-block-size: initial; max-height: initial; max-inline-size: initial; max-width: initial; min-block-size: initial; min-height: initial; min-inline-size: initial; min-width: initial; mix-blend-mode: initial; object-fit: initial; object-position: initial; offset: initial; opacity: initial; order: initial; origin-trial-test-property: initial; orphans: initial; outline: initial; outline-offset: initial; overflow-anchor: initial; overflow-wrap: initial; overflow: initial; overscroll-behavior-block: initial; overscroll-behavior-inline: initial; overscroll-behavior: initial; padding-block: initial; padding: initial; padding-inline: initial; page: initial; page-orientation: initial; paint-order: initial; perspective: initial; perspective-origin: initial; pointer-events: initial; position: initial; quotes: initial; r: initial; resize: initial; ruby-position: initial; rx: initial; ry: initial; scroll-behavior: initial; scroll-margin-block: initial; scroll-margin: initial; scroll-margin-inline: initial; scroll-padding-block: initial; scroll-padding: initial; scroll-padding-inline: initial; scroll-snap-align: initial; scroll-snap-stop: initial; scroll-snap-type: initial; shape-image-threshold: initial; shape-margin: initial; shape-outside: initial; shape-rendering: initial; size: initial; speak: initial; stop-color: initial; stop-opacity: initial; stroke: initial; stroke-dasharray: initial; stroke-dashoffset: initial; stroke-linecap: initial; stroke-linejoin: initial; stroke-miterlimit: initial; stroke-opacity: initial; stroke-width: initial; tab-size: initial; table-layout: initial; text-align: initial; text-align-last: initial; text-anchor: initial; text-combine-upright: initial; text-decoration: initial; text-decoration-skip-ink: initial; text-indent: initial; text-overflow: initial; text-shadow: initial; text-size-adjust: initial; text-transform: initial; text-underline-offset: initial; text-underline-position: initial; touch-action: initial; transform: initial; transform-box: initial; transform-origin: initial; transform-style: initial; transition: initial; user-select: initial; vector-effect: initial; vertical-align: initial; visibility: initial; -webkit-app-region: initial; border-spacing: initial; -webkit-border-image: initial; -webkit-box-align: initial; -webkit-box-decoration-break: initial; -webkit-box-direction: initial; -webkit-box-flex: initial; -webkit-box-ordinal-group: initial; -webkit-box-orient: initial; -webkit-box-pack: initial; -webkit-box-reflect: initial; -webkit-highlight: initial; -webkit-hyphenate-character: initial; -webkit-line-break: initial; -webkit-line-clamp: initial; -webkit-mask-box-image: initial; -webkit-mask: initial; -webkit-mask-composite: initial; -webkit-perspective-origin-x: initial; -webkit-perspective-origin-y: initial; -webkit-print-color-adjust: initial; -webkit-rtl-ordering: initial; -webkit-ruby-position: initial; -webkit-tap-highlight-color: initial; -webkit-text-combine: initial; -webkit-text-decorations-in-effect: initial; -webkit-text-emphasis: initial; -webkit-text-emphasis-position: initial; -webkit-text-fill-color: initial; -webkit-text-security: initial; -webkit-text-stroke: initial; -webkit-transform-origin-x: initial; -webkit-transform-origin-y: initial; -webkit-transform-origin-z: initial; -webkit-user-drag: initial; -webkit-user-modify: initial; white-space: initial; widows: initial; width: initial; will-change: initial; word-break: initial; word-spacing: initial; x: initial; y: initial; z-index: initial;"></DIV><BR /><BR />------------------------------<BR />Gopal Bhaire<BR />Analyst<BR />Accenture<BR />------------------------------<BR /> Wed, 31 Mar 2021 09:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Configuring-Blueprism-with-Azure-DB-as-service/m-p/78967#M30928 GopalBhaire 2021-03-31T09:12:00Z