Skip to main content
Planview Customer Success Center

Importing Changepoint SQL code failed: ERROR: 'sa' is not mapped with dbo schema for Changepoint database!

Reason
The customer installed it as "Windows Authentication mode" and the switch to include "SQL Server and Windows Authentication mode".


Resolution
Setting the database owner to "sa".
Executed the below sproc to correct the issue.

use changepoint
go
sp_changedbowner sa
go

Additional notes
Generally, "sa" is the owner when SQL Server is installed as we recommend, and that is, Server authentication should be "SQL Server and Windows Authentication mode".