Microsoft SQL Server

  1. On the destination database server, add the SQL logins needed (generally only one) for the views database.
  2. Use SQL database Detach/Attach or Backup/Restore procedures to move the views database from one server to another, copying the files for the source views database to the destination database server.
  3. Synchronize the database users with the stored procedure, sp_change_users_login.
  4. Ensure that the default database for the users is the views database. You can verify this in Microsoft SQL Server Management Studio.