# Connecting to MS SQL2014 with Nav2017 development environment

**URL:** <https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321>\
**Category:** Developers Forum\
**Created:** [May 4, 2017, 9:27am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321 "2017-05-04T09:27:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayinde01](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@Ayinde01](https://www.dynamicsuser.net/u/Ayinde01)\
**Post date:** [May 4, 2017, 9:27am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321/1 "2017-05-04T09:27:33Z")

</div>

The following SQL server error or errors occurred:  
18456,“28000”, [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘sa’

I checked my system Services, to be sure its running, they are working properly.

But it working using window authenticate, Please I need you, thanks

---

<div class="post-metadata">

**Author:** ![Sudarshan\_Nav](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@Sudarshan\_Nav](https://www.dynamicsuser.net/u/Sudarshan_Nav)\
**Post date:** [May 5, 2017, 6:07am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321/2 "2017-05-05T06:07:59Z")

</div>

Hi Ayinde01  
Check your credentials Password and User ID.

---

<div class="post-metadata">

**Author:** ![Ayinde01](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@Ayinde01](https://www.dynamicsuser.net/u/Ayinde01)\
**Post date:** [May 5, 2017, 9:30am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321/3 "2017-05-05T09:30:57Z")

</div>

Both Password and User ID are corrected, I used the same Password and User ID to login into MS SQL but not working in MS Nav development environment and I don’t know why. Thanks

---

<div class="post-metadata">

**Author:** ![craazzz](https://avatars.discourse-cdn.com/v4/letter/c/3ec8ea/32.png) [@craazzz](https://www.dynamicsuser.net/u/craazzz)\
**Post date:** [May 5, 2017, 10:55am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321/4 "2017-05-05T10:55:42Z")

</div>

Hi Ayinde01  
Please the link below. It will be of help:  
[blog.sqlauthority.com/…/](https://blog.sqlauthority.com/2016/02/13/sql-server-fix-error-18456-severity-14-state-58-login-failed-for-user/)

---

<div class="post-metadata">

**Author:** ![Ayinde01](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@Ayinde01](https://www.dynamicsuser.net/u/Ayinde01)\
**Post date:** [May 5, 2017, 11:29am UTC](https://www.dynamicsuser.net/t/connecting-to-ms-sql2014-with-nav2017-development-environment/63321/5 "2017-05-05T11:29:50Z")

</div>

Wow!!! Its working fine. Thanks