Dime.Scheduler

Dime.Scheduler

  • Overview
  • User
  • Administrator
  • Setup
  • Plugins
  • Back Office
  • Developer
  • Guides
  • News
  • Languages iconEnglish
    • Deutsch

›Troubleshooting

Overview

  • Quick start
  • Introduction
  • Download package
  • Activate license

Requirements

  • Server
  • Security
  • Client
  • Back office

Installer

  • All-in-one installer
  • Prerequisites
  • Azure
  • Installation
  • Configuration

Hosting

  • Hyper-V environment
  • Dime.Scheduler on Azure
  • Scaling

Legacy Exchange Connector

  • Overview
  • Installation
  • License
  • Configuration
  • Office 365 Connector Installation

NAV Connector

  • Overview
  • Installation
  • FastTrack

Business Central Connector

  • Overview
  • Installation
  • FastTrack

CRM Connector

  • Overview
  • Setup

Troubleshooting

  • Troubleshooting
  • Installer
  • Exchange connector
  • Planning application
  • Service bus
  • Back office
  • Microsoft Dynamics 365 Business Central
  • Azure
  • Database
  • FAQ

Database Troubleshooting

Updating a database that was transferred from a different database server

In the output file of the installer, you may encounter the following error message when you attempt to update a database that used to be on a different database sever:

Error SQL72014: .Net SqlClient Data Provider: Msg 33009, Level 16, State 2, Line 1 The database owner SID recorded in the master database differs from the database owner SID recorded in database 'Dime.Scheduler'. You should correct this situation by resetting the owner of database 'Dime.Scheduler' using the ALTER AUTHORIZATION statement.

This can be resolved by running the following query. Make sure to replace to <<DatabaseName>> and <<LoginName>> placeholders with the actual values of the database and login name.

DECLARE @Command VARCHAR(MAX) = 'ALTER AUTHORIZATION ON DATABASE::[<<DatabaseName>>] TO 
[<<LoginName>>]' 

SELECT @Command = REPLACE(REPLACE(@Command 
            , '<<DatabaseName>>', SD.Name)
            , '<<LoginName>>', SL.Name)
FROM master..sysdatabases SD 
JOIN master..syslogins SL ON  SD.SID = SL.SID
WHERE  SD.Name = DB_NAME()

PRINT @Command
EXEC(@Command)
Last updated on 12/17/2020 by Hendrik Bulens
← AzureFAQ →
  • Updating a database that was transferred from a different database server
Dime.Scheduler
Manuals
  • User Manual
  • Administration
  • Installation
  • Guides
Essential links
  • Getting Started
  • FAQ
  • Get support
  • Privacy Statement
Useful resources
  • Dime.Scheduler
  • Company website
  • GitHub
Community
  • LinkedIn
  • Youtube
  • Facebook
  • Twitter

Copyright © 2021 Dimenics