asp.net - My database (.MDF) doesn't seem to attach to my .\SQLExpress but i can view it in VS 2010? -

asp.net - My database (.MDF) doesn't seem to attach to my .\SQLExpress but i can view it in VS 2010? -

can help?

i created db under app_data using add together item , choosing sql server db , sure plenty there. can double click , opens in vs 2010 in server explorer tab.

the connection have configured in web.config following

<add name="applicationservices" connectionstring="data source=.\sqlexpress;integrated security=sspi;attachdbfilename=|datadirectory|testdb.mdf;user instance=true" providername="system.data.sqlclient" />

as can see using .\sqlexpress. if open sql server management , connect .\sqlexpress database not there.

actually reason need have access db need add together membership info via aspnet_regsql.exe.

i tried via aspnet_regsql.exe pops gui , come in .\sqlexpress in server name , take db db not there.

i confused, why not attaching it? vs 2010 can view in server explorer tab.

i created blank aspx file , loaded via ie , presummed forcefulness attaching of db.

i must doing wrong?

can provide info? know must stupid doing

thanks

data source=.\sqlexpress;integrated security=sspi;attachdbfilename=|datadirectory|testdb.mdf;user instance=true

remove user instance=true

and fyi italics don't work in code blocks :p

and connectionstrings.com great resource.

here's link sql express, although it's 2005

asp.net sql-server visual-studio-2010 asp.net-membership