Symptom
When running Database Setup, an error occurs:
Description: Database error: The specified schema name "LENEL" either does not exist or you do not have permission to use it. Details: Database error executing a statement. (CREATE TABLE LENEL.CCTVDEVICE_CONNECTION ( CCTVDEVICEID SMALLINT NOT NULL, PANELID SMALLINT NOT NULL, RTP_PROTOCOL INTEGER DEFAULT -2 NOT NULL, RTSP_PORT INTEGER DEFAULT 0 NOT NULL ) ) on line 1, error number=2760, state=1, source=.Net SqlClient Data Provider on MATTS-VM SQL error [0]: The specified schema name "LENEL" either does not exist or you do not have permission to use it. on line 1, class=16, error number=2760, state=1, source=.Net SqlClient Data Provider on
Resolution
Open the configuration utility used for editing the application.config file and make sure the schema owner is set to dbo instead of lenel.
Applies To
OnGuard (All versions)