Microsoft BizTalk Server 2020 Configuration Error

XML User 121 Reputation points
2022-05-10T18:28:55.447+00:00

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'."

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
342 questions
0 comments No comments
{count} votes

Accepted answer
  1. Kamlesh Kumar 3,861 Reputation points
    2022-05-10T18:41:27.293+00:00

    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://learn.microsoft.com/en-us/biztalk/core/troubleshooting-problems-with-msdtc?redirectedfrom=MSDN
    https://learn.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 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Niklas Engfelt 21 Reputation points Microsoft Employee
    2022-05-12T09:36:11.89+00:00

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

    1 person found this answer helpful.
    0 comments No comments