Problem Description:
SOI and UIM are sharing the same database server and port, with separate databases. When I attempt to install the UIM connector on the server, UIM connector will not connect to the database. I see the message in the connector log "Error connecting to database: Login failed for user <username>". I can connect to SQL Server Management Studio with this user.
Solution:
Using the same SOI db userid as UIM will cause a conflict. Create a separate db userid for the UIM connector and then retry the UIM connector install.