StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POchanged name of membership database, can't find users
primarykey
Id
9330978
data
AcceptedAnswerId
9334432
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-17T15:29:39.337
FavoriteCount
0
LastActivityDate
2012-02-21T18:01:52.870
LastEditDate
2012-02-17T18:10:16.640
LastEditorUserId
16354
OwnerUserId
16354
ParentId
0
PostTypeId
1
Score
0
ViewCount
734
LastEditorDisplayName
text
Body
I created an asp.net site using VS 2008. I was using a db in app_data for membership. I am moving this to a new server and the db will be attached to a sql server 2008 R2 instance. I wanted to change the db name so it would fit in better with the rest of the server. Since I changed the name from ASPNETDB.mdf to Reporting.MDF I cannot login and ASP.NET says I have no users. I used the rename function in VS and updated my connectionstring. <pre><code><connectionStrings> <add name="MembershipConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Reporting.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web>  <roleManager enabled="true"> <providers> <clear/> <add connectionStringName="MembershipConnectionString" applicationName="WebSite2" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken="/> </providers> </roleManager> <membership defaultProvider="SqlMembershipProvider"> <providers> <clear/> <add connectionStringName="MembershipConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="WebSite2" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" /> </providers> </membership> </code></pre> Users: 0 Provider: Test to check db works fine. edit: I removed the publicKey in case it is tied to me in some way. edit: I changed the name back to aspnetdb and it still does not work. If i delete the membership code it works again. This is after changing the name back to aspnetdb. I am back where I started.
Tags
<asp.net><asp.net-membership>
Title
changed name of membership database, can't find users
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPrimetime
UserOwnerUserId
1. USPrimetime
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.