question

devUser-6951 avatar image
0 Votes"
devUser-6951 asked niklase answered

Microsoft BizTalk Server 2020 Configuration Error

Hello experts,

Need your help, I am trying to configure biztalk server 20 but getting errors, please help me to resolve this issue,

BizTalk Server cannot access SQL server. This could be due to one of the following reasons:
1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.
2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.
3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.
4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

Internal error from OLEDB provider: "Login failed for user 'BizTalkUser'."

biztalk-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KamleshKumar avatar image
1 Vote"
KamleshKumar answered devUser-6951 commented

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

As error clearly indicates, you have an issue in connectivity, please check the below points,

  • Do you have BizTalk and SQL on same server or different servers?

  • If you have different servers then please check the connectivity between both the servers.

  • Please check the MSDTC configuration for both the servers, refer:

https://docs.microsoft.com/en-us/biztalk/core/troubleshooting-problems-with-msdtc?redirectedfrom=MSDN
https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sql/configure-msdtc-on-sql-server-and-adapter-client

Regards,
Kamlesh Kumar
BizTalk Techie

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you for reply, yes my biztalk and database servers are in different box.

0 Votes 0 ·
niklase avatar image
1 Vote"
niklase answered

Please check this "Before you begin" section for details on SQL SysAdm and local admin on SQL server.
https://docs.microsoft.com/en-us/biztalk/install-and-config-guides/configure-biztalk-server

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.