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
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) (SQLExecDirectW);
Product
EM version 21.12 or lower
EM version 22.06 or higher
Steps to Reproduce
Download Enterprise Manager 22.06 (or higher) installer package
Install the package
Try to reach EM via web Gui
Log in using known credentials
Expected Results
Logs in successfully and able to see configuration
Actual Results
You will get the crying stickman page
Solution
WORKAROUND: AES 2868
Which contains the workaround and backpatch
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
- exacqVision Client
- exacqVision Enterprise Manager
- exacqVision Integrator Service Portal
- exacqVision Server
- exacqVision Web Service
- LSI Storage Authority
- MegaRAID Storage Manager
- PostgreSQL
- SQL Server
Port List
| Port | Description |
|---|---|
| 25 | Simple Mail Transfer Protocol (SMTP) |
| 80 | exacqVision Web Server/exacqVision Enterprise Manager (HTTP) How to change Web Service ports How to change EM web ports |
| 389 | LDAP (Lightweight Directory Access Protocol) |
| 443 | exacqVision Web Service/exacqVision Enterprise Manager/ exacqVision Relay (HTTPS ) How to change Web Service ports How to change EM web ports |
| 445 | SMB Archiving and Microsoft-DS (Directory Services) |
| 465 | Secure SMTP (Legacy) |
| 587 | SMTP (TLS/SSL) |
| 636 | LDAPS (Lightweight Directory Access Protocol over TLS/SSL) |
| 1433 | exacqVision Enterprise Manager (SQL Server) |
| 2463 | LSI Storage Authority (Webserver) |
| 3071 | MegaRAID Storage Manager |
| 3260 | exacqVision Server S-Series Extended Storage (iSCSI) |
| 3702 | exacqVision Server – Web Services Dynamic Discovery (WS-Discovery) |
| 5432 | exacqVision Enterprise Manager (PostgreSQL) |
| 5571 | MegaRAID Storage Manager |
| 8082 | exacqVision Web Service (Web Socket) – Web Sockets only used in Web Service 7.2 to 9.4 How to change Web Service ports |
| 8083 | exacqVision Web Service (Web Socket Secure) – Web Sockets only used in Web Service 7.2 to 9.4 How to change Web Service ports |
| 8443 | Server connections from exacqVision Mobile 24.09 and above. How to change exacqVision Mobile listening port |
| 8554 | exacqVision RTSP Server |
| 9000 | LSI Storage Authority (LSA Server) |
| 22609 | exacqVision Client How to change exacqVision Server port |
| 22610 | exacqVision Server Interprocess Communication [RESERVED – DO NOT USE] |
| 22717 | exacqVision Web Service NVRG Gateway |
| 28744 | exacqVision Enterprise Manager (Failback – vfba) |
| 35111 | Integrator Service Portal (ExacqCloud Outbound Connections) |
Related Articles
- Exacq Software/Service Connections Diagram
- Accessing exacqVision from Tablets and Phones using the Exacq Mobile 3 App
<br>
Although 3rd party instructions may exist for this process, converting from Postgre to MS SQL is currently not recommended or supported.
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:
- ddladmin
- dbwriter
- dbreader
<br>