asp.net - Attached DB Can login but not create user "invalid value for key 'attachdbfilename'" -

-

i have application running on our server (it works fine on computer not matters). windows server 2003, sql express 2008 r2 server.

im using attached db storing users (the asp.net supplied db).

i can login web application no problem when try create user says invalid value key 'attachdbfilename' yellow screen of death.

here have connection string in web.config

<add name="connectionstringaspnetdb.mdf" connectionstring="data source=localhost\sqlexpress_2008;attachdbfilename=|datadirectory|\aspnetdb.mdf;integrated security=true;user instance=true" providername="system.data.sqlclient" />

and membership provider

<add name="daganteckning" type="system.web.security.sqlmembershipprovider, system.web, version=2.0.3600.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a"                 connectionstringname="connectionstringaspnetdb.mdf"                 enablepasswordretrieval="false"                 enablepasswordreset="false"                 requiresquestionandanswer="false"                 applicationname="/"                 requiresuniqueemail="false"                 passwordformat="hashed"                 description="stores , retrieves membership data microsoft sql server database." />

my guess there sort of directory/file security permission must set have no idea user iis/sql uses access database file.

any 1 got idea?

edit: tryed replacing localhost\sqlexpress_2008 .\sqlexpress_2008 , got

unable open physical file "c:\inetpub\wwwroot\medlem_test\app_data\aspnetdb.mdf". operating system error 32: "32(the process cannot access file because being used process.)". attempt attach auto-named database file c:\inetpub\wwwroot\medlem_test\app_data\aspnetdb.mdf failed. database same name exists, or specified file cannot opened, or located on unc share.

check if server's antivirus or other process accessing file.

you try recycling application after making change listed.

also if use asp.net configuration tool attach mdf file , application create error while connected through that.


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more