Microsoft KB Archive/276812

Knowledge Base

BizTalk Server Setup Error If SQL Server Authentication Is Set to "Windows only"

Article ID: 276812

Article Last Modified on 11/7/2003

---

APPLIES TO

• Microsoft BizTalk Server 2000 Standard Edition

---

This article was previously published under Q276812

SYMPTOMS

During the BizTalk Messaging Management Database portion of BizTalk Server Setup, you may receive the following error message:

An error occurred while attempting to create the BizTalk Messaging Management database. The specified SQL server might not be running or the server name might be incorrect.

Hresult: 0x80004005
Description: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
SQL Error 18452: 42000

Source: Microsoft OLE DB Provider for SQL Server

CAUSE

This error occurs because the SQL Server that BizTalk Server Setup tries to use is configured to use "Windows only" authentication.

RESOLUTION

On the SQL Server Security tab, configure SQL Server to use "SQL Server and Windows" authentication. Then stop and restart SQL Server Services, and continue BizTalk Server Setup.

Additional query words: error 0x80004005 18452 42000

Keywords: kbprb kbpending KB276812

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.