Blue Prism Product

last person joined: yesterday 

Chat about Blue Prism products
Expand all | Collapse all

unable to create database for BP Server

Jump to Best Answer
  • 1.  unable to create database for BP Server

    Posted 08-11-2020 04:59
    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
    ------------------------------


  • 2.  RE: unable to create database for BP Server

    Posted 08-11-2020 09:10
    Sounds like a file permission issue. Does the account that SQL server is running under have access to that directory?

    ------------------------------
    Nicholas Zejdlik
    RPA Developer
    ------------------------------



  • 3.  RE: unable to create database for BP Server

    Posted 08-11-2020 10:46
    Thank you nicholas for quick reply, how to give permissions to SQL server to access the file

    ------------------------------
    Sai Krishna Somisetty
    ------------------------------



  • 4.  RE: unable to create database for BP Server
    Best Answer

    Posted 08-11-2020 11:01
    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
    ------------------------------



Share