When importing a BillQuick database into your SQL instance, you sometimes encounter the following exception when setting the 'sa' user as the database owner:
Cannot use the special principal 'sa'. Microsoft SQL Server, Error: 15405
To fix this issue, follow these steps:
- Open SQL Management Studio, right-click BillQuick database and select New Query.
- Enter the below queries:
USE <your database name>
exec sp_changedbowner 'sa', 'true' - Click the Execute button. The queries should execute successfully and the issue should be fixed.