Connecting to MS SQL2014 with Nav2017 development environment

Business Central/NAV Developers Forum
1

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

2

Hi Ayinde01
Check your credentials Password and User ID.

3

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

4

Hi Ayinde01
Please the link below. It will be of help:
blog.sqlauthority.com/…/

5

Wow!!! Its working fine. Thanks