There is already an object named 'Zero' in the database when creating Policy Store tables

Products

• SITEMINDER

Issue/Introduction

Trying to delete the tables from the ODBC Policy Store database, and the ODBC SQL Server reports:

From running sm_mssql_ps.sql:

Msg 2714, Level 16, State 3, Procedure Zero, Line 11 [Batch Start Line 0]
There is already an object named 'Zero' in the database.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.
Msg 219, Level 16, State 1, Line 14
The type 'dbo.SmBoolean' already exists, or you do not have permission to create it.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.
Msg 219, Level 16, State 1, Line 18
The type 'dbo.SmIpAddressN' already exists, or you do not have permission to create it.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.
Msg 219, Level 16, State 1, Line 21
The type 'dbo.SmLongInt' already exists, or you do not have permission to create it.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.
Msg 219, Level 16, State 1, Line 25
The type 'dbo.SmLongIntOpt' already exists, or you do not have permission to create it.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.
Msg 219, Level 16, State 1, Line 29
The type 'dbo.SmOidOptN' already exists, or you do not have permission to create it.
Warning: User types created via sp_addtype are contained in dbo schema. The @owner parameter if specified is ignored.

Resolution

These objects are already set at another level of the database configuration, then the reason why they show up.

To ensure the script is fully handled, do the following:

1. Drop all the database tables;
2. Edit the sm_mssql_ps.sql to skip the create default zero;
3. Run the SQL statements by applying the above file;

And continue to setup the Policy Store (1).

Additional Information

1. How to Configure a Microsoft SQL Server/Microsoft Azure SQL Database Policy Store