Sql error 18452:42000

[Dzeromas]

Hello!
When I tried to install Biztalk Server 2000 I've got an error message on Configure a BizTalk Messaging Management Database page:
SQL error 18452:42000 :Login failed for user '%ls'. Reason: Not associated with a trusted SQL Server connection.

 

[SenseiC]

Dzeromas,

MS KB 276812 (

http://support.microsoft.com/default.aspx?scid=kb;

[LN];276812):

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

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

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.

SenseiC

NACSC Middleware Support
HP

 

[Dzeromas]

Thank you for the help SenseiC.