Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. BizTalk Server Setup Error If SQL Server Authentication Is Set to "Windows only"

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

View products that this article applies to.

This article was previously published under Q276812

↑ Back to the top

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB276812, kbprb, kbpending

↑ Back to the top

Article Info
Article ID : 276812
Revision : 4
Created on : 11/7/2003
Published on : 11/7/2003
Exists online : False
Views : 319