RS Warrior Forum banner

1 - 3 of 3 Posts

·
Registered
Joined
·
579 Posts
Discussion Starter #1
I get this error only on the Warrior General forum for weeks now.


Microsoft OLE DB Provider for SQL Server error '80004005'

Warning: Fatal error 1203 occurred at Dec 17 2002 3:55PM

/forums/forum.asp, line 331
 

·
Registered
Joined
·
717 Posts
quote:Originally posted by programmergeek

I get this error only on the Warrior General forum for weeks now.

Microsoft OLE DB Provider for SQL Server error '80004005'
Warning: Fatal error 1203 occurred at Dec 17 2002 3:55PM
/forums/forum.asp, line 331

That is interesting because when this error occurs, everyone should get it. What is your OS and which Browser do you use?

See below for the error description ...

ODBC 80004005 Error, If the connection scheme for accessing SQL Server is not set correctly, users viewing your database application may receive an ODBC 80004005 error message. To correct this situation, try using a local named pipe connection instead of a network named pipe connection if SQL Server is running on the same computer as IIS. Windows XP security rules will not be enforced because the pipe is a local connection rather than a network connection, which can be impersonated by the anonymous user account. Also, in the SQL Server connection string (either in the Global.asa file or in a page-level script), change the parameter SERVER=server name to SERVER=(local). The keyword (local) is a special parameter recognized by the SQL Server ODBC driver. If this solution does not work, then try to use a non-authenticated protocol between IIS and SQL Server, such as TCP/IP sockets. This protocol will work when SQL Server is running locally or on remote computer.
 

·
Registered
Joined
·
4,864 Posts
Calling all MSCE's, MCP, etc...
I am open for suggestions on this one. It doenst happen for everyone, nor does it happen all the time!

SQL Server is not running on the same machine as the web site so the above tech note does not apply.

Check/Post here for further info:
http://www.rswarrior.com/forums/topic.asp?TOPIC_ID=1543

CarKnee

PS, This should have been posted in the same thread as the original.
 
1 - 3 of 3 Posts
Top