I am running into problems setting up a database connection in Ignition Gateway. I have a database called “ignition” (lower case) in my SQL Server (Express) running on the same machine as the Gateway. It is visible and accessible from within SQL Management Server. SQL Server and Server browser are both running and listening on port 1433.
I have set “extraConnectionProperties=ignition”.
When I try to setup the database connection, it gets through all the authentication (mixed mode) but gives me the following error “Cannot create PoolableConnectionFactory (Cannot open database “ignition” requested by the login. The login failed.)”
Can anyone tell me where I am going wrong?