ExacqVision currently doesn’t support NT authentication when validating credentials to a MSSQL database (Enterprise Manager), we require to use SQL server authentication. A feature enhancement ticket has been submitted for NT authentication.
Tag: SQL Server
Invalid column error after updating Enterprise Manager using MSSQL database from 21.12 or lower to 22.06 or higher
Description If you are using mssql database with EM and updating from 21.12 or lower to 22.06 you will get the crying stickman when trying to log into the web gui. When checking the webservice logs you will get invalid column errors such as.. ][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name ‘lastSaveOrUpdate’. (207)… Continue reading Invalid column error after updating Enterprise Manager using MSSQL database from 21.12 or lower to 22.06 or higher
exacqVision Default Ports
Description The following is a list of default port numbers used by exacqVision software. NOTE: Many ports listed below may only used with certain configurations or by optional services and integrations. Products Port List PortDescription25Simple Mail Transfer Protocol (SMTP)80exacqVision Web Server/exacqVision Enterprise Manager (HTTP)How to change Web Service portsHow to change EM web ports389LDAP (Lightweight… Continue reading exacqVision Default Ports
EM Postgre to SQL Database Move
Although 3rd party instructions may exist for this process, converting from Postgre to MS SQL is currently not recommended or supported.
Using ESM with MS SQL Server
For ESM to run successfully with an MS SQL Server database, the user role that ESM is using should, at minimum, have the following permissions: <br>