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 >
Application settings and select MDTools Library.
- Select MS Access.
- Click Ok,
- Now Login to MS SQL Library will
work fine.
Related Articles
How to backup and restore HyDraw CAD Library MS Access version?
The attached PDF outlines the process required to create database backups or restore for HyDraw CAD when utilizing the Microsoft Access Database.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 ...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 ...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 ...HyDraw CAD 2022 License won't apply and throws an Object Reference error
When applying the HyDraw CAD 2022 CLS ID for Single-user License, the program gives the following error: Follow the instructions below to set an exclusion for the HyDraw CAD executable: Go to Start > Settings > Update & Security > Windows Security > ...