Error 18452

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

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

-- Anonymous, January 20, 2004

Answers

Ruben,

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 http://support.microsoft.com/support/kb/articles/q289/6/33.asp

Q247641 - FIX: Trusted TCP/IP Socket Connection May Fail w/ Error 18452 http://support.microsoft.com/support/kb/articles/q247/6/41.asp

Q265808 - INF: Connect to an SQL 2000 Named Inst. w/Prev. Ver. Client Tool http://support.microsoft.com/support/kb/articles/q265/8/08.asp

Hope this helps,

Eric

-- Anonymous, January 28, 2004


Moderation questions? read the FAQ