473,324 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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

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
8 2235
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Dave | last post by:
I have been reading everything i can find regarding sql mail and sql agent mail. We have a win2k server, sql 2000 and NO, NO, NO exchange server(all up to date on service packs). I have tried...
0
by: VB Programmer | last post by:
Out of necessity I may have to use Access to store my membership, profile, etc... info (usually stored in ASPNETDB.mdf) 1. Do I use aspnet_regsql.exe to populate the mdb? If so, any command...
0
by: Miguel Dias Moura | last post by:
Hello, I am working on an Asp.Net 2.0 / SQL 2005 web site. I am using profile to save the users info on the database. For example, I have the following structure: Public Structure Name...
0
by: Ashkan Daie | last post by:
Hi All, When using forms authentication with IIS 6.0, I can create a user and log in the user. But the LoginStatus control states that the user is logged out. When running the same app using...
0
by: Jesse Johnson | last post by:
I have this block of code below, but when ran it only creates the member it doesnt fill in his profile data. Is there something I am missing? Please let me know what I can do, just trying to...
0
by: dba123 | last post by:
I need to "tie together the cookie with the domain" by referencing the information from my web.config below in my login's codebhind. I don't understand how. I need to also save that after...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
2
by: Annie | last post by:
Hello guys, I have set the MEMBERSHIP, ROLEMANAGER and PROFILE in my config file as below. I just want to use my own sql server 2000 table instead of MSDB.
0
by: =?Utf-8?B?QV9SZXB1YmxpY2Fu?= | last post by:
This is a portion of my Web.config file: <system.web> <membership defaultProvider="SqlProvider"> <providers> <clear/> <add name="SqlProvider" type="System.Web.Security.SqlMembershipProvider"...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.