Right-click the folder in question and go to Properties -> Security, then add permissions for the account running SQL server.
Given that it's trying to create the database in C:\Users, I would recommend changing your SQL server's default database location. Changing it to use a more appropriate directory would likely fix the issue so you wouldn't have to mess with folder permissions. You can do that in SSMS by going into your server properties (
see here).
------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------
Original Message:
Sent: 08-11-2020 15:46
From: Sai Krishna Somisetty
Subject: unable to create database for BP Server
Thank you nicholas for quick reply, how to give permissions to SQL server to access the file
------------------------------
Sai Krishna Somisetty
Original Message:
Sent: 08-11-2020 14:10
From: Nicholas Zejdlik
Subject: unable to create database for BP Server
Sounds like a file permission issue. Does the account that SQL server is running under have access to that directory?
------------------------------
Nicholas Zejdlik
RPA Developer
Original Message:
Sent: 08-11-2020 09:59
From: Sai Krishna Somisetty
Subject: unable to create database for BP Server
Hi Team,
while creating a DB for blue prism server i'm getting error
can anyone help me on this??
Thanks in advance.
------------------------------
Sai Krishna Somisetty
------------------------------