How to create a database in blue prism

[Keerthana]

Hello all,

To sign in to blue prism,when i try establish SQL connection,,"it shows database doesn't exist"..so if i try create database through file-->create database..
i get the following error "
Failed to create database - CREATE DATABASE permission denied in database 'master'.

At stage 'Creating'

i have included screenshot for reference..
Any suggestions or solutions to this issue??

 

[anisjolly]

Hi @Keerthana

I believe you need to setup the correct security permissions within your SQL / AD environment before you can look at creating databases amongst your SQL infrastructure.

 

[VJR]

Hi Keerthana,

Can you also try this -
In the Connection configuration, make sure in the Connection Type you are selecting 'SQL Server Windows Authentication'.

 

[Keerthana]

Thank you @anisjolly & @VJR

 

[VJR]

Hi Keerthana,

Do post back how does your issue gets resolved.

 

[Keerthana]

In SQL server installation, when i changed the permission from admin to everyone the issue got resolved and the database has been created.
before the permission was only to admin so it restricted me to create a database..

 

[suryadss]

Thanks for the useful info @Keerthana