I have installed sql server 2008 express r2 on window 2008 VPS. I got following error many times a day “80004005|Named_Pipes_Provider:_Timeout_error_” as well as “|80004005|Cannot_open_database__xxxx__requested_by_the_login._The_login_failed.”
in my iis log. i am using classic asp for my website.
Shared Memory is disabled and Named Pipe and TCP protocols are enable to connect database and also modified registry with following entries.
path: HKEY_LOCAL_MACHINE\System\CurrentControlSet\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Please help me to fix this error.
Thanks & Regards
Database Performance Optimization
Go to the complete details ...