RE: sql server error

From: Uttam Parui[MS] (uttamkp@online.microsoft.com)
Date: 10/26/02 

From: uttamkp@online.microsoft.com (Uttam Parui[MS])
Date: Sat, 26 Oct 2002 12:59:56 GMT

Sateesh,

Error 18452 can have different reasons.

One of them being that the autentication mode of your SQL Server is set to
"Windows only". If this is the case, then you will get Error 18452 when you
use a SQL login to connect to SQL Server. If this is not the case then see
the links in the "Additional Info" section below.

To change the authentication mode from Windows (only) to Mixed Mode, use
the following steps:

1. Open the Enterprise Manager.

2. Click to expand the server group.

3. Right-click the server name, and then click Properties.

4. Click the Security tab.

5. Under Authentication, click the SQL Server and Windows option button.

Additional Information
=====================
INF: Windows Authentication is the Default Security Mode After a SQL Server
2000 Typical Installation
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q269587

INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q265808

FIX: Trusted TCP/IP Socket Connection May Fail with Error Message 18452
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q247641

Hope this helps.

Regards,

Uttam Kumar Parui
SQL Server Support Engineer, MCDBA, MCSE, MCT
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.