BP Version 6 Database Connection Error

P

Patnaik14

Member
Hi All,

I have installed .net 4.7, SQL Server express 2014 & BP.
Did the configuration as described in Busy Ping(YouTube Channel).
But at CREATE DATABASE connection section, it's reflecting error as:

"failed to create database - CREATE DATABASE permission denied in database 'master' "
At Stage 'Initialiasing'

Please advise how to resolve.
 
S

Sachin_Kharmale

Active Member
Hi,

The cause to error may be
while configuring Blue Prism connection you are passing
Connection type as - Windows Authentication or SQL Server Authentication

You have configure database but the user of database does not have permision to create database.
Make user have permision to create database it will may be resolved your problem
View attachment 1559895550679.png

Best,
Sachin
 
P

Patnaik14

Member
While installing SQL Server I have given WINDOWS AUTHENTICATION MODE
& While configuring BP Database server I have given as localhost\SQLExpress & connection type as Windows Auth only
 
S

Sachin_Kharmale

Active Member
If you have SSMS (SQL Server Management Studio) then you can resolved issue by following ways,

  1. Go to SQL Server Management Studio and run it as Administrator.
  2. Choose Security -> Then Logins
  3. Choose the usernames or whatever users that will access your database under the Logins and Double Click it.
  4. Give them a Server Roles that will give them credentials to create database. On my case, public was already checked so I checked dbcreator and sysadmin.
  5. Run update-database again on Package Manager Console. Database should now successfully created.
Here is an image so that you can get the bigger picture, I blurred my credentials of course:

I have solved my issue by using above steps i hope it will help you also.

Best,
Sachin
 
You must log in or register to reply here.
Top