# Unable to connect to SQL Server database

**URL:** <https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-database/11709>\
**Category:** General Discussion\
**Created:** [May 23, 2016, 10:58pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-database/11709 "2016-05-23T22:58:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve\_Ihnen](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@Steve\_Ihnen](https://forum.inductiveautomation.com/u/Steve_Ihnen)\
**Post date:** [May 23, 2016, 10:58pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-database/11709/1 "2016-05-23T22:58:09Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [May 24, 2016, 9:14pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-database/11709/2 "2016-05-24T21:14:37Z")

</div>

Did you grant connect permission to the login you created?