locked
Can not open database using classic ASP RRS feed

  • 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 categories
    Sunday, April 3, 2011 2:14 PM

Answers

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
  • 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