What DB Roles should I have to use SQL with HyDraw CAD and how do I change these roles?

What DB Roles should I have to use SQL with HyDraw CAD and how do I change these roles?

Within the SQL Database, users should have the dbcreator role assigned to their login credentials in order to read and write from the database.
To change a user's role within the SQL database do the following steps:

1.     Open SQL Server Management Studio. Select the username from Logins and right-click select Properties.

                        
               2. Login Properties dialog pops up. Select the Server Roles and select “dbcreator” (public is by default selected and can’t be selected).

            

See also:

    • Related Articles

    • How to create new user logins for a SQL Database

      For SQL Server Management Studio 2018 follow the below steps: 1.      Go to Security > Logins, right click and select New Login. 2.      Login New dialog pops up. Enter the Login Name, select SQL server authentication, Provide Password. Click Ok. See ...

    • How to assign the correct SQL database permissions?

      To assign adequate SQL database permissions within SQL Server Management Studio, follow the below steps: 1. Select User mapping and select the Database Name and assign Database roles as “db_datareader” and “db_datawriter” (public is by default ...

    • Setting up MS SQL Library in HyDraw CAD 2022 gives Login failed error

      While trying to Login MS SQL Library in HyDraw CAD 2022 gives Login failed error. The error is coming possibly because of MDTools Library selected as MS SQL in HyDraw Options, and the database is missing in SQL server. Solution: Go to HyDraw Options ...

    • How can I use a Cloud Storage system with my HyDraw Library?

      Standard Microsoft Access library does not work well with cloud storage. The reason is that with cloud storage the files are replicated locally/online and this creates conflict copies of databases. If you want to use library in cloud, you must: 1. ...

    • Access Database Engine 2016 and MS OLE DB Driver fails to Install with HyDraw Library Manager

      When installing HyDraw Library Manager, the system fails to install Access Database Engine 2016 and MS OLE DB Driver and displays the error shown below. While the exact root cause is unknown, it appears that CMD.exe may not be able to extract the ...