Error connecting to Business Central (SQL Server) Using NAV User Password authentication

Symptom

When attempting to connect to Business Central 24 (SQL Server) (Release 2024 Wave 1) or later using Nav User Password authentication, the following error is displayed:

The provided credentials are not valid for this data source.

Cause

Microsoft has enhanced their security requirements and you will need to switch to an encrypted version of your user’s password.

Resolution

To resolve this error, contact your IT administrator and request an encrypted version of your Business Central user. You can use the encrypted password to establish the connection in Jet Reports. This is available in Jet Reports 24.3.1 release version and newer.

Data base administrators can use this query to get the hashed password for your user. Replace bc_database with your Business Central data base name and username with your current username.

USE [bc_database]
GO
SELECT
dbo.[User Property].Password
FROM
dbo.[User Property]	INNER JOIN	dbo.[User]
ON	dbo.[User Property].[User Security ID] = dbo.[User].[User Security ID]
WHERE
dbo.[User].[User Name] = 'username'

For more information on creating a Business Central (SQL Server) data source, see Create a Business Central (SQL Server) Data Source.