In the Login Properties window, select User Mapping from the left menu.
In the Users mapped to this login section, check the box next to:
Copy
Ask AI
PADS4FIDS
In the Database role membership for: PADS4FIDS, check the role:
Copy
Ask AI
db_owner
Click OK to save changes.
The PADS4FIDS database is now configured and ready for use. Let me know if you’d like to proceed with similar instructions for setup via SQL scripts or PowerShell.