Answered by:
Can not open database using classic ASP

Question
-
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
Business Intelligence
Upto 50% discount on products in different categoriesSunday, April 3, 2011 2:14 PM
Answers
-
Hello,
It seems that you could have problems with Windows 2008 VPS + SQl Server
http://www.888.net/vps_faqs.htm
Please, could you have a look at the questions 6 and 8 ?
You have a timeout problem with named pipes ( not sure with TCP/IP ) but you gave only informations about TCP/IP. I would suggest you to have a look at this link
http://support.microsoft.com/kb/839269/en-us
http://msdn.microsoft.com/en-us/library/ms191260.aspx
http://msdn.microsoft.com/en-us/library/ms189307.aspx
Don't hesitate to post again for more help or explanations
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.- Proposed as answer by Stephanie Lv Tuesday, April 5, 2011 1:40 AM
- Marked as answer by Alex Feng (SQL) Tuesday, April 12, 2011 5:14 AM
Sunday, April 3, 2011 3:34 PM
All replies
-
I have VPS of window 2008 and have installed sql server 2008 express r2 on it. I got following error many times a day “|80004005|Cannot_open_database__sds__requested_by_the_login._The_login_failed.” in my iis log. i am using classic asp for my website and i generated new db user to connect.
After getting above error i modified connectionstring in ASP script to connect database using “sa”. after this modification i was getting “|80004005|Shared_Memory_Provider:_Timeout_error”. I was enabled only Shared Memory Protocol.
After getting above error i was enabled all protocols (Named Pipe and TCP) but still on same. then i disabled Shared Memory Protocol now i’m getting this error. “80004005|Named_Pipes_Provider:_Timeout_error_” as well as “|80004005|Cannot_open_database__sds__requested_by_the_login._The_login_failed.”
Please help me to fix this issue.
Thanks & Regards
Database Performance Optimization
Business Intelligence- Merged by WeiLin Qiao Tuesday, April 5, 2011 1:24 AM duplicated thread
Thursday, March 31, 2011 10:23 PM -
Hi Saqib, Did you create the login on the server? And you added the login as a user to the database ?
Can you please verify if your login is added to the database? please try running these queries under your database
Thanks
select pri.name,pri.type_desc,dpri.name as RoleMembers from sys.database_role_members rm right join sys.database_principals pri on pri.principal_id=rm.role_principal_id left join sys.database_principals dpri on dpri.principal_id=rm.member_principal_id Where pri.name like '%YourLOGIN%' go
SELECT spl.name,spl.type_desc,spl.is_disabled from sys.server_principals spl inner join sys.database_principals dpl on spl.name=dpl.name where dpl.name like '%inte%'
- Edited by SQL_Jay Saturday, April 2, 2011 1:56 AM edited text
Saturday, April 2, 2011 1:55 AM -
Hi,
I'm using 'sa' user to connect database.
Database Performance Optimization
Business Intelligence
Upto 50% discount on products in different categoriesSunday, April 3, 2011 12:36 PM -
Hello,
It seems that you could have problems with Windows 2008 VPS + SQl Server
http://www.888.net/vps_faqs.htm
Please, could you have a look at the questions 6 and 8 ?
You have a timeout problem with named pipes ( not sure with TCP/IP ) but you gave only informations about TCP/IP. I would suggest you to have a look at this link
http://support.microsoft.com/kb/839269/en-us
http://msdn.microsoft.com/en-us/library/ms191260.aspx
http://msdn.microsoft.com/en-us/library/ms189307.aspx
Don't hesitate to post again for more help or explanations
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.- Proposed as answer by Stephanie Lv Tuesday, April 5, 2011 1:40 AM
- Marked as answer by Alex Feng (SQL) Tuesday, April 12, 2011 5:14 AM
Sunday, April 3, 2011 3:34 PM -
Hello ,
Are you sure that this thread is not the same as
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/d45e3d44-3f1b-443a-967b-b233453a878b ?
It is useless to create 2 threads for the same problem.
I think that the both threads will be merged quickly.
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.Sunday, April 3, 2011 3:43 PM