1. Create a windows user, add administrator role
  2. Create a login in SSMS
  3. Modify User Mapping, default schema dbo.
Advertisements