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


The information in this article applies to:

  • Microsoft BizTalk Server 2000
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.
Modification Type:MajorLast Reviewed:11/7/2003
Keywords:kbpending kbprb KB276812
©2003 Microsoft Corporation. All rights reserved.