Error 18452greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
How can i create a user to not giveme the error 18452.
-- Anonymous, January 20, 2004
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