business central communicate and SQL server communication

Question

business central communicate and SQL server communication

Kyle Krul 1

Can business central communicate with a SQL server communication basis?

YufeiShao-msft 7,146 Reputation points

2022-11-18T01:57:01.6+00:00

Hi @Kyle Krul ，

Could you please validate all the answers so far and provide any update?

Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thank you for understanding!

1 answer

Your answer

YufeiShao-msft 7,146 Reputation points

2022-11-18T01:57:01.6+00:00

Hi @Kyle Krul ，

Could you please validate all the answers so far and provide any update?

Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thank you for understanding!

Answer 1

YufeiShao-msft 7,146

Hi @Kyle Krul ，

The SQL Server version should be at lease SQL 2016, for a business central server instance to connect to and access a database in SQL Server, the server instance must be authenticated by the database, and it supports Windows Authentication and SQL Server Authentication

Please refer to this doc:
Configuring the Business Central Database

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

YufeiShao-msft 7,146 Reputation points

2022-11-14T01:12:56.68+00:00

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

Regards

Share via

business central communicate and SQL server communication

1 answer

Your answer