Microsoft KB Archive/276812

= BizTalk Server Setup Error If SQL Server Authentication Is Set to &quot;Windows only&quot; =

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 &quot;Windows only&quot; authentication.



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

Additional query words: error 0x80004005 18452 42000

Keywords: kbprb kbpending KB276812

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.