Error 18452 : LUSENET : SQL Server Database Administration : One Thread

How can i create a user to not giveme the error 18452.

-- Anonymous, January 20, 2004



This error usually indicates you are trying to connect to SQL Server using a "trusted" connection but SQL Server is not accepting the connection. Is it from an ASP page? What are the connection parameters for the ASP page? Is your ASP page being hosted on an IIS internet server? If it is, you may have IIS trying connect with a proxy account.

Can you connect using other tools like Query Analyzer? What net library are you using to connect?

Below are some Knowledge Base article which you may find helpful: They discuss your particular error message.

Q289633 - Err Msg: Server: Msg 18452, Level 16, State 1

Q247641 - FIX: Trusted TCP/IP Socket Connection May Fail w/ Error 18452

Q265808 - INF: Connect to an SQL 2000 Named Inst. w/Prev. Ver. Client Tool

Hope this helps,


-- Anonymous, January 28, 2004

Moderation questions? read the FAQ