- restore database via Import Data Tier Application
- go to the security - Logins
- select the ardis user (or user meant to connect)
- right click Properties
- go to User Mapping
- select the database you just restored, check the database for the user, and check the role to be DB Owner