By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

URGENT & TRICKY: code for membership/profile fails when published to webserver

P: n/a
I would appreciate your assistance on this ASP.NET 2.0 site....

This is the wierd problem: While accessing the built in .NET functions for
'profiling' or 'membership' an error is generated (see following 2
examples):

---- EXAMPLE 1 --------
OK --> Dim p As New ProfileCommon
OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
FAILS --> Me.lblDebug.Text = p.FirstName.ToString

---- EXAMPLE 2 --------
OK --> Dim u As MembershipUser
FAILS --> u =
System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)

These lines work perfectly locally. They fail after my site is published to
the webserver. I really feel this is a server related issue. Perhaps these
"libraries" are not installed correctly or something? Any ideas?

The error message is misleading and says this:

error received:
----------------------------------
server error in '/' application.
--------------------------------------------------------------------------------

an attempt to attach an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.
des_crip_tion: an unhandled exception occurred during the execution of the
current web request. please review the stack trace for more information
about the error and where it originated in the code.

exception details: system.data.sqlclient.sqlexception: an attempt to attach
an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.

source error:

an unhandled exception was generated during the execution of the current web
request. information regarding the origin and location of the exception can
be identified using the exception stack trace below.

stack trace:
[sqlexception (0x80131904): an attempt to attach an auto-named database for
file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.]
system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception exception,
boolean breakconnection) +734995
system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
stateobj) +188
system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand
cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
bulkcopyhandler, tdsparserstateobject stateobj) +1838
system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
enlistok) +33
system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
owningobject, sqlconnectionstring connectionoptions, string newpassword,
boolean redirecteduserinstance) +628
system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
identity, sqlconnectionstring connectionoptions, object providerinfo, string
newpassword, sqlconnection owningobject, boolean redirecteduserinstance)
+170
system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
options, object poolgroupproviderinfo, dbconnectionpool pool, dbconnection
owningconnection) +359
system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
owningconnection, dbconnectionpool pool, dbconnectionoptions options) +28
system.data.providerbase.dbconnectionpool.createob ject(dbconnection
owningobject) +424
system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
owningobject) +66
system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
owningobject) +496
system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
owningconnection) +82
system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
outerconnection, dbconnectionfactory connectionfactory) +105
system.data.sqlclient.sqlconnection.open() +111
system.web.dataaccess.sqlconnectionholder.open(htt pcontext context, boolean
revertimpersonate) +84
system.web.dataaccess.sqlconnectionhelper.getconne ction(string
connectionstring, boolean revertimpersonation) +197
system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
username, boolean updatelastloginactivitydate, int32& status, string&
password, int32& passwordformat, string& passwordsalt, int32&
failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
boolean& isapproved, datetime& lastlogindate, datetime& lastactivitydate)
+1121
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved, string& salt, int32& passwordformat) +105
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved) +42
system.web.security.sqlmembershipprovider.validate user(string username,
string password) +83
system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs e) +160
system.web.ui.webcontrols.login.attemptlogin() +105
system.web.ui.webcontrols.login.onbubbleevent(obje ct source, eventargs e)
+99
system.web.ui.control.raisebubbleevent(object source, eventargs args) +35
system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
system.web.ui.webcontrols.button.raisepostbackeven t(string eventargument)
+163
system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
eventargument) +7
system.web.ui.page.raisepostbackevent(ipostbackeve nthandler sourcecontrol,
string eventargument) +11
system.web.ui.page.raisepostbackevent(namevaluecol lection postdata) +33
system.web.ui.page.processrequestmain(boolean includestagesbeforeasyncpoint,
boolean includestagesafterasyncpoint) +5102

--------------------------------------------------------------------------------
version information: microsoft .net framework version:2.0.50727.42; asp.net
version:2.0.50727.42

Jan 28 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
VB Programmer:
What this means is that your hoster or site already has this database
attached (probably their default one). You'll need to either rename your
database and make the appropriate config changes, or work out the details
with them.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I would appreciate your assistance on this ASP.NET 2.0 site....

This is the wierd problem: While accessing the built in .NET functions for
'profiling' or 'membership' an error is generated (see following 2
examples):

---- EXAMPLE 1 --------
OK --> Dim p As New ProfileCommon
OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
FAILS --> Me.lblDebug.Text = p.FirstName.ToString

---- EXAMPLE 2 --------
OK --> Dim u As MembershipUser
FAILS --> u =
System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)

These lines work perfectly locally. They fail after my site is published to
the webserver. I really feel this is a server related issue. Perhaps these
"libraries" are not installed correctly or something? Any ideas?

The error message is misleading and says this:

error received:
----------------------------------
server error in '/' application.
--------------------------------------------------------------------------------

an attempt to attach an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.
des_crip_tion: an unhandled exception occurred during the execution of the
current web request. please review the stack trace for more information
about the error and where it originated in the code.

exception details: system.data.sqlclient.sqlexception: an attempt to attach
an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.

source error:

an unhandled exception was generated during the execution of the current web
request. information regarding the origin and location of the exception can
be identified using the exception stack trace below.

stack trace:
[sqlexception (0x80131904): an attempt to attach an auto-named database for
file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.]
system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception exception,
boolean breakconnection) +734995
system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
stateobj) +188
system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand
cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
bulkcopyhandler, tdsparserstateobject stateobj) +1838
system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
enlistok) +33
system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
owningobject, sqlconnectionstring connectionoptions, string newpassword,
boolean redirecteduserinstance) +628
system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
identity, sqlconnectionstring connectionoptions, object providerinfo, string
newpassword, sqlconnection owningobject, boolean redirecteduserinstance)
+170
system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
options, object poolgroupproviderinfo, dbconnectionpool pool, dbconnection
owningconnection) +359
system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
owningconnection, dbconnectionpool pool, dbconnectionoptions options) +28
system.data.providerbase.dbconnectionpool.createob ject(dbconnection
owningobject) +424
system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
owningobject) +66
system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
owningobject) +496
system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
owningconnection) +82
system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
outerconnection, dbconnectionfactory connectionfactory) +105
system.data.sqlclient.sqlconnection.open() +111
system.web.dataaccess.sqlconnectionholder.open(htt pcontext context, boolean
revertimpersonate) +84
system.web.dataaccess.sqlconnectionhelper.getconne ction(string
connectionstring, boolean revertimpersonation) +197
system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
username, boolean updatelastloginactivitydate, int32& status, string&
password, int32& passwordformat, string& passwordsalt, int32&
failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
boolean& isapproved, datetime& lastlogindate, datetime& lastactivitydate)
+1121
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved, string& salt, int32& passwordformat) +105
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved) +42
system.web.security.sqlmembershipprovider.validate user(string username,
string password) +83
system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs e) +160
system.web.ui.webcontrols.login.attemptlogin() +105
system.web.ui.webcontrols.login.onbubbleevent(obje ct source, eventargs e)
+99
system.web.ui.control.raisebubbleevent(object source, eventargs args) +35
system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
system.web.ui.webcontrols.button.raisepostbackeven t(string eventargument)
+163
system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
eventargument) +7
system.web.ui.page.raisepostbackevent(ipostbackeve nthandler sourcecontrol,
string eventargument) +11
system.web.ui.page.raisepostbackevent(namevaluecol lection postdata) +33
system.web.ui.page.processrequestmain(boolean includestagesbeforeasyncpoint,
boolean includestagesafterasyncpoint) +5102

--------------------------------------------------------------------------------
version information: microsoft .net framework version:2.0.50727.42; asp.net
version:2.0.50727.42

Jan 29 '06 #2

P: n/a
But the wierd thing is I can access the data on other pages with no problem.
As a test I made a simple gridview shoping aspnet_users and aspnet_profile
and it showed up fine. It was only when I tried to access the membership or
profile stuff via code that it gave me this error. There are dropdownlists
that are showing the data fine.

Still think it's the db name? I'll give it a try....

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F2**********************************@microsof t.com...
VB Programmer:
What this means is that your hoster or site already has this database
attached (probably their default one). You'll need to either rename your
database and make the appropriate config changes, or work out the details
with them.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I would appreciate your assistance on this ASP.NET 2.0 site....

This is the wierd problem: While accessing the built in .NET functions
for
'profiling' or 'membership' an error is generated (see following 2
examples):

---- EXAMPLE 1 --------
OK --> Dim p As New ProfileCommon
OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
FAILS --> Me.lblDebug.Text = p.FirstName.ToString

---- EXAMPLE 2 --------
OK --> Dim u As MembershipUser
FAILS --> u =
System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)

These lines work perfectly locally. They fail after my site is published
to
the webserver. I really feel this is a server related issue. Perhaps
these
"libraries" are not installed correctly or something? Any ideas?

The error message is misleading and says this:

error received:
----------------------------------
server error in '/' application.
--------------------------------------------------------------------------------

an attempt to attach an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.
des_crip_tion: an unhandled exception occurred during the execution of
the
current web request. please review the stack trace for more information
about the error and where it originated in the code.

exception details: system.data.sqlclient.sqlexception: an attempt to
attach
an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.

source error:

an unhandled exception was generated during the execution of the current
web
request. information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

stack trace:
[sqlexception (0x80131904): an attempt to attach an auto-named database
for
file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot be
opened, or it is located on unc share.]
system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception
exception,
boolean breakconnection) +734995
system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
stateobj) +188
system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand
cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
bulkcopyhandler, tdsparserstateobject stateobj) +1838
system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
enlistok) +33
system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
owningobject, sqlconnectionstring connectionoptions, string newpassword,
boolean redirecteduserinstance) +628
system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
identity, sqlconnectionstring connectionoptions, object providerinfo,
string
newpassword, sqlconnection owningobject, boolean redirecteduserinstance)
+170
system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
options, object poolgroupproviderinfo, dbconnectionpool pool,
dbconnection
owningconnection) +359
system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
owningconnection, dbconnectionpool pool, dbconnectionoptions options) +28
system.data.providerbase.dbconnectionpool.createob ject(dbconnection
owningobject) +424
system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
owningobject) +66
system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
owningobject) +496
system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
owningconnection) +82
system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
outerconnection, dbconnectionfactory connectionfactory) +105
system.data.sqlclient.sqlconnection.open() +111
system.web.dataaccess.sqlconnectionholder.open(htt pcontext context,
boolean
revertimpersonate) +84
system.web.dataaccess.sqlconnectionhelper.getconne ction(string
connectionstring, boolean revertimpersonation) +197
system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
username, boolean updatelastloginactivitydate, int32& status, string&
password, int32& passwordformat, string& passwordsalt, int32&
failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
boolean& isapproved, datetime& lastlogindate, datetime& lastactivitydate)
+1121
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved, string& salt, int32& passwordformat) +105
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved) +42
system.web.security.sqlmembershipprovider.validate user(string username,
string password) +83
system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs e)
+160
system.web.ui.webcontrols.login.attemptlogin() +105
system.web.ui.webcontrols.login.onbubbleevent(obje ct source, eventargs e)
+99
system.web.ui.control.raisebubbleevent(object source, eventargs args) +35
system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
system.web.ui.webcontrols.button.raisepostbackeven t(string eventargument)
+163
system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
eventargument) +7
system.web.ui.page.raisepostbackevent(ipostbackeve nthandler
sourcecontrol,
string eventargument) +11
system.web.ui.page.raisepostbackevent(namevaluecol lection postdata) +33
system.web.ui.page.processrequestmain(boolean
includestagesbeforeasyncpoint,
boolean includestagesafterasyncpoint) +5102

--------------------------------------------------------------------------------
version information: microsoft .net framework version:2.0.50727.42;
asp.net
version:2.0.50727.42

Jan 29 '06 #3

P: n/a
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.

Any more ideas?

Thanks.

"VB Programmer" <do**@emailme.com> wrote in message
news:e9**************@TK2MSFTNGP14.phx.gbl...
But the wierd thing is I can access the data on other pages with no
problem. As a test I made a simple gridview shoping aspnet_users and
aspnet_profile and it showed up fine. It was only when I tried to access
the membership or profile stuff via code that it gave me this error.
There are dropdownlists that are showing the data fine.

Still think it's the db name? I'll give it a try....

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F2**********************************@microsof t.com...
VB Programmer:
What this means is that your hoster or site already has this database
attached (probably their default one). You'll need to either rename your
database and make the appropriate config changes, or work out the details
with them.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I would appreciate your assistance on this ASP.NET 2.0 site....

This is the wierd problem: While accessing the built in .NET functions
for
'profiling' or 'membership' an error is generated (see following 2
examples):

---- EXAMPLE 1 --------
OK --> Dim p As New ProfileCommon
OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
FAILS --> Me.lblDebug.Text = p.FirstName.ToString

---- EXAMPLE 2 --------
OK --> Dim u As MembershipUser
FAILS --> u =
System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)

These lines work perfectly locally. They fail after my site is published
to
the webserver. I really feel this is a server related issue. Perhaps
these
"libraries" are not installed correctly or something? Any ideas?

The error message is misleading and says this:

error received:
----------------------------------
server error in '/' application.
--------------------------------------------------------------------------------

an attempt to attach an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.
des_crip_tion: an unhandled exception occurred during the execution of
the
current web request. please review the stack trace for more information
about the error and where it originated in the code.

exception details: system.data.sqlclient.sqlexception: an attempt to
attach
an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.

source error:

an unhandled exception was generated during the execution of the current
web
request. information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

stack trace:
[sqlexception (0x80131904): an attempt to attach an auto-named database
for
file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.]
system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception
exception,
boolean breakconnection) +734995
system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
stateobj) +188
system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand
cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
bulkcopyhandler, tdsparserstateobject stateobj) +1838
system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
enlistok) +33
system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
owningobject, sqlconnectionstring connectionoptions, string newpassword,
boolean redirecteduserinstance) +628
system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
identity, sqlconnectionstring connectionoptions, object providerinfo,
string
newpassword, sqlconnection owningobject, boolean redirecteduserinstance)
+170
system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
options, object poolgroupproviderinfo, dbconnectionpool pool,
dbconnection
owningconnection) +359
system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
owningconnection, dbconnectionpool pool, dbconnectionoptions options)
+28
system.data.providerbase.dbconnectionpool.createob ject(dbconnection
owningobject) +424
system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
owningobject) +66
system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
owningobject) +496
system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
owningconnection) +82
system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
outerconnection, dbconnectionfactory connectionfactory) +105
system.data.sqlclient.sqlconnection.open() +111
system.web.dataaccess.sqlconnectionholder.open(htt pcontext context,
boolean
revertimpersonate) +84
system.web.dataaccess.sqlconnectionhelper.getconne ction(string
connectionstring, boolean revertimpersonation) +197
system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
username, boolean updatelastloginactivitydate, int32& status, string&
password, int32& passwordformat, string& passwordsalt, int32&
failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
boolean& isapproved, datetime& lastlogindate, datetime&
lastactivitydate)
+1121
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved, string& salt, int32& passwordformat) +105
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved) +42
system.web.security.sqlmembershipprovider.validate user(string username,
string password) +83
system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs e)
+160
system.web.ui.webcontrols.login.attemptlogin() +105
system.web.ui.webcontrols.login.onbubbleevent(obje ct source, eventargs
e)
+99
system.web.ui.control.raisebubbleevent(object source, eventargs args)
+35
system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
system.web.ui.webcontrols.button.raisepostbackeven t(string
eventargument)
+163
system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
eventargument) +7
system.web.ui.page.raisepostbackevent(ipostbackeve nthandler
sourcecontrol,
string eventargument) +11
system.web.ui.page.raisepostbackevent(namevaluecol lection postdata) +33
system.web.ui.page.processrequestmain(boolean
includestagesbeforeasyncpoint,
boolean includestagesafterasyncpoint) +5102

--------------------------------------------------------------------------------
version information: microsoft .net framework version:2.0.50727.42;
asp.net
version:2.0.50727.42


Jan 29 '06 #4

P: n/a
Yes, renaming to "whatever.mdf" is half the equation; the configuration entry
that specifies it must be changed to match as well. I'd consult with
"WebHost4Life" - whoever they are.

If the guys are any good at all they should be ready, willing and able to
help you sort it out, assuming they expect to earn their monthly fee or
whatever it is.

Here's a blog entry that may provide some insight:

http://petesbloggerama.blogspot.com/...spnet-web.html

Peter
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.

Any more ideas?

Thanks.

"VB Programmer" <do**@emailme.com> wrote in message
news:e9**************@TK2MSFTNGP14.phx.gbl...
But the wierd thing is I can access the data on other pages with no
problem. As a test I made a simple gridview shoping aspnet_users and
aspnet_profile and it showed up fine. It was only when I tried to access
the membership or profile stuff via code that it gave me this error.
There are dropdownlists that are showing the data fine.

Still think it's the db name? I'll give it a try....

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:F2**********************************@microsof t.com...
VB Programmer:
What this means is that your hoster or site already has this database
attached (probably their default one). You'll need to either rename your
database and make the appropriate config changes, or work out the details
with them.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:

I would appreciate your assistance on this ASP.NET 2.0 site....

This is the wierd problem: While accessing the built in .NET functions
for
'profiling' or 'membership' an error is generated (see following 2
examples):

---- EXAMPLE 1 --------
OK --> Dim p As New ProfileCommon
OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
FAILS --> Me.lblDebug.Text = p.FirstName.ToString

---- EXAMPLE 2 --------
OK --> Dim u As MembershipUser
FAILS --> u =
System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)

These lines work perfectly locally. They fail after my site is published
to
the webserver. I really feel this is a server related issue. Perhaps
these
"libraries" are not installed correctly or something? Any ideas?

The error message is misleading and says this:

error received:
----------------------------------
server error in '/' application.
--------------------------------------------------------------------------------

an attempt to attach an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.
des_crip_tion: an unhandled exception occurred during the execution of
the
current web request. please review the stack trace for more information
about the error and where it originated in the code.

exception details: system.data.sqlclient.sqlexception: an attempt to
attach
an auto-named database for file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.

source error:

an unhandled exception was generated during the execution of the current
web
request. information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

stack trace:
[sqlexception (0x80131904): an attempt to attach an auto-named database
for
file
c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
failed. a database with the same name exists, or specified file cannot
be
opened, or it is located on unc share.]
system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception
exception,
boolean breakconnection) +734995
system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
stateobj) +188
system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand
cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
bulkcopyhandler, tdsparserstateobject stateobj) +1838
system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
enlistok) +33
system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
owningobject, sqlconnectionstring connectionoptions, string newpassword,
boolean redirecteduserinstance) +628
system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
identity, sqlconnectionstring connectionoptions, object providerinfo,
string
newpassword, sqlconnection owningobject, boolean redirecteduserinstance)
+170
system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
options, object poolgroupproviderinfo, dbconnectionpool pool,
dbconnection
owningconnection) +359
system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
owningconnection, dbconnectionpool pool, dbconnectionoptions options)
+28
system.data.providerbase.dbconnectionpool.createob ject(dbconnection
owningobject) +424
system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
owningobject) +66
system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
owningobject) +496
system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
owningconnection) +82
system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
outerconnection, dbconnectionfactory connectionfactory) +105
system.data.sqlclient.sqlconnection.open() +111
system.web.dataaccess.sqlconnectionholder.open(htt pcontext context,
boolean
revertimpersonate) +84
system.web.dataaccess.sqlconnectionhelper.getconne ction(string
connectionstring, boolean revertimpersonation) +197
system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
username, boolean updatelastloginactivitydate, int32& status, string&
password, int32& passwordformat, string& passwordsalt, int32&
failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
boolean& isapproved, datetime& lastlogindate, datetime&
lastactivitydate)
+1121
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved, string& salt, int32& passwordformat) +105
system.web.security.sqlmembershipprovider.checkpas sword(string username,
string password, boolean updatelastloginactivitydate, boolean
failifnotapproved) +42
system.web.security.sqlmembershipprovider.validate user(string username,
string password) +83
system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs e)
+160
system.web.ui.webcontrols.login.attemptlogin() +105
system.web.ui.webcontrols.login.onbubbleevent(obje ct source, eventargs
e)
+99
system.web.ui.control.raisebubbleevent(object source, eventargs args)
+35
system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
system.web.ui.webcontrols.button.raisepostbackeven t(string
eventargument)
+163
system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
eventargument) +7
system.web.ui.page.raisepostbackevent(ipostbackeve nthandler
sourcecontrol,
string eventargument) +11
system.web.ui.page.raisepostbackevent(namevaluecol lection postdata) +33
system.web.ui.page.processrequestmain(boolean
includestagesbeforeasyncpoint,
boolean includestagesafterasyncpoint) +5102

--------------------------------------------------------------------------------
version information: microsoft .net framework version:2.0.50727.42;
asp.net
version:2.0.50727.42



Jan 29 '06 #5

P: n/a
VB Programmer wrote:
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.


If the error you receive is still the one about an already attached DB of the same name, how have you modified the web.config file? It needs to have a <connectionStrings></connectionStrings> section and in that section you need the following tags (in order):
<remove name="LocalSqlServer" />
<add name="LocalSqlServer"
connectionString="data source=YourServerandInstance;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Your AppDB.mdf;User Instance=true"
providerName="System.Data.SqlClient" />

Obviously, you'll need to modify the server/instance and mdf values. The key is that ASPNET uses the "LocalSqlServer" connection string to do its authorization, etc.
--
Take care,
Ken
(to reply directly, remove the cool car. <sigh>)
Jan 29 '06 #6

P: n/a
Thanks Peter. I've been consulting with them for a week and they finally
now "support sqlexpress". But, they haven't been able to assist yet.

I haven't been able to find a good reference on how to change the default
ASPNETDB.MDF name. I believe I need to create a new SQLExpress provider
with the new name, etc... but haven't been able to find the info pertaining
to this. Of course, I don't have access to their machine.config so
everything would go in the web.config I believe.

Let me know if you have any other suggestions...

Thanks!
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:10**********************************@microsof t.com...
Yes, renaming to "whatever.mdf" is half the equation; the configuration
entry
that specifies it must be changed to match as well. I'd consult with
"WebHost4Life" - whoever they are.

If the guys are any good at all they should be ready, willing and able to
help you sort it out, assuming they expect to earn their monthly fee or
whatever it is.

Here's a blog entry that may provide some insight:

http://petesbloggerama.blogspot.com/...spnet-web.html

Peter
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.

Any more ideas?

Thanks.

"VB Programmer" <do**@emailme.com> wrote in message
news:e9**************@TK2MSFTNGP14.phx.gbl...
> But the wierd thing is I can access the data on other pages with no
> problem. As a test I made a simple gridview shoping aspnet_users and
> aspnet_profile and it showed up fine. It was only when I tried to
> access
> the membership or profile stuff via code that it gave me this error.
> There are dropdownlists that are showing the data fine.
>
> Still think it's the db name? I'll give it a try....
>
> "Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
> message
> news:F2**********************************@microsof t.com...
>> VB Programmer:
>> What this means is that your hoster or site already has this database
>> attached (probably their default one). You'll need to either rename
>> your
>> database and make the appropriate config changes, or work out the
>> details
>> with them.
>> Peter
>>
>> --
>> Co-founder, Eggheadcafe.com developer portal:
>> http://www.eggheadcafe.com
>> UnBlog:
>> http://petesbloggerama.blogspot.com
>>
>>
>>
>>
>> "VB Programmer" wrote:
>>
>>> I would appreciate your assistance on this ASP.NET 2.0 site....
>>>
>>> This is the wierd problem: While accessing the built in .NET
>>> functions
>>> for
>>> 'profiling' or 'membership' an error is generated (see following 2
>>> examples):
>>>
>>> ---- EXAMPLE 1 --------
>>> OK --> Dim p As New ProfileCommon
>>> OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
>>> FAILS --> Me.lblDebug.Text = p.FirstName.ToString
>>>
>>> ---- EXAMPLE 2 --------
>>> OK --> Dim u As MembershipUser
>>> FAILS --> u =
>>> System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)
>>>
>>> These lines work perfectly locally. They fail after my site is
>>> published
>>> to
>>> the webserver. I really feel this is a server related issue.
>>> Perhaps
>>> these
>>> "libraries" are not installed correctly or something? Any ideas?
>>>
>>> The error message is misleading and says this:
>>>
>>> error received:
>>> ----------------------------------
>>> server error in '/' application.
>>> --------------------------------------------------------------------------------
>>>
>>> an attempt to attach an auto-named database for file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.
>>> des_crip_tion: an unhandled exception occurred during the execution
>>> of
>>> the
>>> current web request. please review the stack trace for more
>>> information
>>> about the error and where it originated in the code.
>>>
>>> exception details: system.data.sqlclient.sqlexception: an attempt to
>>> attach
>>> an auto-named database for file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.
>>>
>>> source error:
>>>
>>> an unhandled exception was generated during the execution of the
>>> current
>>> web
>>> request. information regarding the origin and location of the
>>> exception
>>> can
>>> be identified using the exception stack trace below.
>>>
>>> stack trace:
>>>
>>>
>>> [sqlexception (0x80131904): an attempt to attach an auto-named
>>> database
>>> for
>>> file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.]
>>> system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception
>>> exception,
>>> boolean breakconnection) +734995
>>> system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
>>> stateobj) +188
>>> system.data.sqlclient.tdsparser.run(runbehavior runbehavior,
>>> sqlcommand
>>> cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
>>> bulkcopyhandler, tdsparserstateobject stateobj) +1838
>>> system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
>>> enlistok) +33
>>> system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
>>> owningobject, sqlconnectionstring connectionoptions, string
>>> newpassword,
>>> boolean redirecteduserinstance) +628
>>> system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
>>> identity, sqlconnectionstring connectionoptions, object providerinfo,
>>> string
>>> newpassword, sqlconnection owningobject, boolean
>>> redirecteduserinstance)
>>> +170
>>> system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
>>> options, object poolgroupproviderinfo, dbconnectionpool pool,
>>> dbconnection
>>> owningconnection) +359
>>> system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
>>> owningconnection, dbconnectionpool pool, dbconnectionoptions options)
>>> +28
>>> system.data.providerbase.dbconnectionpool.createob ject(dbconnection
>>> owningobject) +424
>>> system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
>>> owningobject) +66
>>> system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
>>> owningobject) +496
>>> system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
>>> owningconnection) +82
>>> system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
>>> outerconnection, dbconnectionfactory connectionfactory) +105
>>> system.data.sqlclient.sqlconnection.open() +111
>>> system.web.dataaccess.sqlconnectionholder.open(htt pcontext context,
>>> boolean
>>> revertimpersonate) +84
>>> system.web.dataaccess.sqlconnectionhelper.getconne ction(string
>>> connectionstring, boolean revertimpersonation) +197
>>> system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
>>> username, boolean updatelastloginactivitydate, int32& status, string&
>>> password, int32& passwordformat, string& passwordsalt, int32&
>>> failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
>>> boolean& isapproved, datetime& lastlogindate, datetime&
>>> lastactivitydate)
>>> +1121
>>> system.web.security.sqlmembershipprovider.checkpas sword(string
>>> username,
>>> string password, boolean updatelastloginactivitydate, boolean
>>> failifnotapproved, string& salt, int32& passwordformat) +105
>>> system.web.security.sqlmembershipprovider.checkpas sword(string
>>> username,
>>> string password, boolean updatelastloginactivitydate, boolean
>>> failifnotapproved) +42
>>> system.web.security.sqlmembershipprovider.validate user(string
>>> username,
>>> string password) +83
>>> system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs
>>> e)
>>> +160
>>> system.web.ui.webcontrols.login.attemptlogin() +105
>>> system.web.ui.webcontrols.login.onbubbleevent(obje ct source,
>>> eventargs
>>> e)
>>> +99
>>> system.web.ui.control.raisebubbleevent(object source, eventargs args)
>>> +35
>>> system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
>>> system.web.ui.webcontrols.button.raisepostbackeven t(string
>>> eventargument)
>>> +163
>>> system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
>>> eventargument) +7
>>> system.web.ui.page.raisepostbackevent(ipostbackeve nthandler
>>> sourcecontrol,
>>> string eventargument) +11
>>> system.web.ui.page.raisepostbackevent(namevaluecol lection postdata)
>>> +33
>>> system.web.ui.page.processrequestmain(boolean
>>> includestagesbeforeasyncpoint,
>>> boolean includestagesafterasyncpoint) +5102
>>>
>>> --------------------------------------------------------------------------------
>>> version information: microsoft .net framework version:2.0.50727.42;
>>> asp.net
>>> version:2.0.50727.42
>>>
>>>
>>>
>>>
>
>


Jan 29 '06 #7

P: n/a
THAT WORKED KEN!!!!

I followed what you said, uploaded the precompiled site, then REMOVED "User
Instance=true" and it works now.

Thanks again!

"Ken Arway" <ka****@jaguar.att.net> wrote in message
news:OI**************@TK2MSFTNGP09.phx.gbl...
VB Programmer wrote:
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.


If the error you receive is still the one about an already attached DB of
the same name, how have you modified the web.config file? It needs to
have a <connectionStrings></connectionStrings> section and in that section
you need the following tags (in order):
<remove name="LocalSqlServer" />
<add name="LocalSqlServer"
connectionString="data source=YourServerandInstance;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|Your AppDB.mdf;User
Instance=true"
providerName="System.Data.SqlClient" />

Obviously, you'll need to modify the server/instance and mdf values. The
key is that ASPNET uses the "LocalSqlServer" connection string to do its
authorization, etc.
--
Take care,
Ken
(to reply directly, remove the cool car. <sigh>)

Jan 29 '06 #8

P: n/a
Ha, this is a hoot Peter.

I think *you* better check with *your* server administrator "whoever that
is" because I selected the URL to read the article you referred to and the
URL was not found by blogger's server.

You know, if their guys are any good at all they should be ready, willing
and able to help you sort it out, assuming they expect to earn their monthly
fee or whatever it is.
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:10**********************************@microsof t.com...
Yes, renaming to "whatever.mdf" is half the equation; the configuration
entry
that specifies it must be changed to match as well. I'd consult with
"WebHost4Life" - whoever they are.

If the guys are any good at all they should be ready, willing and able to
help you sort it out, assuming they expect to earn their monthly fee or
whatever it is.

Here's a blog entry that may provide some insight:

http://petesbloggerama.blogspot.com/...spnet-web.html

Peter
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"VB Programmer" wrote:
I renamed the db to something VERY unique, changed the web.config, etc...

After I published the site I got the same error.

Any more ideas?

Thanks.

"VB Programmer" <do**@emailme.com> wrote in message
news:e9**************@TK2MSFTNGP14.phx.gbl...
> But the wierd thing is I can access the data on other pages with no
> problem. As a test I made a simple gridview shoping aspnet_users and
> aspnet_profile and it showed up fine. It was only when I tried to
> access
> the membership or profile stuff via code that it gave me this error.
> There are dropdownlists that are showing the data fine.
>
> Still think it's the db name? I'll give it a try....
>
> "Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in
> message
> news:F2**********************************@microsof t.com...
>> VB Programmer:
>> What this means is that your hoster or site already has this database
>> attached (probably their default one). You'll need to either rename
>> your
>> database and make the appropriate config changes, or work out the
>> details
>> with them.
>> Peter
>>
>> --
>> Co-founder, Eggheadcafe.com developer portal:
>> http://www.eggheadcafe.com
>> UnBlog:
>> http://petesbloggerama.blogspot.com
>>
>>
>>
>>
>> "VB Programmer" wrote:
>>
>>> I would appreciate your assistance on this ASP.NET 2.0 site....
>>>
>>> This is the wierd problem: While accessing the built in .NET
>>> functions
>>> for
>>> 'profiling' or 'membership' an error is generated (see following 2
>>> examples):
>>>
>>> ---- EXAMPLE 1 --------
>>> OK --> Dim p As New ProfileCommon
>>> OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)
>>> FAILS --> Me.lblDebug.Text = p.FirstName.ToString
>>>
>>> ---- EXAMPLE 2 --------
>>> OK --> Dim u As MembershipUser
>>> FAILS --> u =
>>> System.Web.Security.Membership.GetUser(Me.ddlRacer .SelectedItem.Text)
>>>
>>> These lines work perfectly locally. They fail after my site is
>>> published
>>> to
>>> the webserver. I really feel this is a server related issue.
>>> Perhaps
>>> these
>>> "libraries" are not installed correctly or something? Any ideas?
>>>
>>> The error message is misleading and says this:
>>>
>>> error received:
>>> ----------------------------------
>>> server error in '/' application.
>>> --------------------------------------------------------------------------------
>>>
>>> an attempt to attach an auto-named database for file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.
>>> des_crip_tion: an unhandled exception occurred during the execution
>>> of
>>> the
>>> current web request. please review the stack trace for more
>>> information
>>> about the error and where it originated in the code.
>>>
>>> exception details: system.data.sqlclient.sqlexception: an attempt to
>>> attach
>>> an auto-named database for file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.
>>>
>>> source error:
>>>
>>> an unhandled exception was generated during the execution of the
>>> current
>>> web
>>> request. information regarding the origin and location of the
>>> exception
>>> can
>>> be identified using the exception stack trace below.
>>>
>>> stack trace:
>>>
>>>
>>> [sqlexception (0x80131904): an attempt to attach an auto-named
>>> database
>>> for
>>> file
>>> c:\hosting\webhost4life\member\robertnzana\custome rdomains\1320stompers\app_data\aspnetdb.mdf
>>> failed. a database with the same name exists, or specified file
>>> cannot
>>> be
>>> opened, or it is located on unc share.]
>>> system.data.sqlclient.sqlinternalconnection.onerro r(sqlexception
>>> exception,
>>> boolean breakconnection) +734995
>>> system.data.sqlclient.tdsparser.throwexceptionandw arning(tdsparserstateobject
>>> stateobj) +188
>>> system.data.sqlclient.tdsparser.run(runbehavior runbehavior,
>>> sqlcommand
>>> cmdhandler, sqldatareader datastream, bulkcopysimpleresultset
>>> bulkcopyhandler, tdsparserstateobject stateobj) +1838
>>> system.data.sqlclient.sqlinternalconnectiontds.com pletelogin(boolean
>>> enlistok) +33
>>> system.data.sqlclient.sqlinternalconnectiontds.ope nloginenlist(sqlconnection
>>> owningobject, sqlconnectionstring connectionoptions, string
>>> newpassword,
>>> boolean redirecteduserinstance) +628
>>> system.data.sqlclient.sqlinternalconnectiontds..ct or(dbconnectionpoolidentity
>>> identity, sqlconnectionstring connectionoptions, object providerinfo,
>>> string
>>> newpassword, sqlconnection owningobject, boolean
>>> redirecteduserinstance)
>>> +170
>>> system.data.sqlclient.sqlconnectionfactory.createc onnection(dbconnectionoptions
>>> options, object poolgroupproviderinfo, dbconnectionpool pool,
>>> dbconnection
>>> owningconnection) +359
>>> system.data.providerbase.dbconnectionfactory.creat epooledconnection(dbconnection
>>> owningconnection, dbconnectionpool pool, dbconnectionoptions options)
>>> +28
>>> system.data.providerbase.dbconnectionpool.createob ject(dbconnection
>>> owningobject) +424
>>> system.data.providerbase.dbconnectionpool.usercrea terequest(dbconnection
>>> owningobject) +66
>>> system.data.providerbase.dbconnectionpool.getconne ction(dbconnection
>>> owningobject) +496
>>> system.data.providerbase.dbconnectionfactory.getco nnection(dbconnection
>>> owningconnection) +82
>>> system.data.providerbase.dbconnectionclosed.openco nnection(dbconnection
>>> outerconnection, dbconnectionfactory connectionfactory) +105
>>> system.data.sqlclient.sqlconnection.open() +111
>>> system.web.dataaccess.sqlconnectionholder.open(htt pcontext context,
>>> boolean
>>> revertimpersonate) +84
>>> system.web.dataaccess.sqlconnectionhelper.getconne ction(string
>>> connectionstring, boolean revertimpersonation) +197
>>> system.web.security.sqlmembershipprovider.getpassw ordwithformat(string
>>> username, boolean updatelastloginactivitydate, int32& status, string&
>>> password, int32& passwordformat, string& passwordsalt, int32&
>>> failedpasswordattemptcount, int32& failedpasswordanswerattemptcount,
>>> boolean& isapproved, datetime& lastlogindate, datetime&
>>> lastactivitydate)
>>> +1121
>>> system.web.security.sqlmembershipprovider.checkpas sword(string
>>> username,
>>> string password, boolean updatelastloginactivitydate, boolean
>>> failifnotapproved, string& salt, int32& passwordformat) +105
>>> system.web.security.sqlmembershipprovider.checkpas sword(string
>>> username,
>>> string password, boolean updatelastloginactivitydate, boolean
>>> failifnotapproved) +42
>>> system.web.security.sqlmembershipprovider.validate user(string
>>> username,
>>> string password) +83
>>> system.web.ui.webcontrols.login.onauthenticate(aut henticateeventargs
>>> e)
>>> +160
>>> system.web.ui.webcontrols.login.attemptlogin() +105
>>> system.web.ui.webcontrols.login.onbubbleevent(obje ct source,
>>> eventargs
>>> e)
>>> +99
>>> system.web.ui.control.raisebubbleevent(object source, eventargs args)
>>> +35
>>> system.web.ui.webcontrols.button.oncommand(command eventargs e) +115
>>> system.web.ui.webcontrols.button.raisepostbackeven t(string
>>> eventargument)
>>> +163
>>> system.web.ui.webcontrols.button.system.web.ui.ipo stbackeventhandler.raisepostbackevent(string
>>> eventargument) +7
>>> system.web.ui.page.raisepostbackevent(ipostbackeve nthandler
>>> sourcecontrol,
>>> string eventargument) +11
>>> system.web.ui.page.raisepostbackevent(namevaluecol lection postdata)
>>> +33
>>> system.web.ui.page.processrequestmain(boolean
>>> includestagesbeforeasyncpoint,
>>> boolean includestagesafterasyncpoint) +5102
>>>
>>> --------------------------------------------------------------------------------
>>> version information: microsoft .net framework version:2.0.50727.42;
>>> asp.net
>>> version:2.0.50727.42
>>>
>>>
>>>
>>>
>
>


Jan 30 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.