0

I want to implement security policies in my website using asp.net membership providers. I run aspnet_regsql from following path C:\Windows\Microsoft.NET\Framework64\v4.0.30319. Then I selected my database, and I got all the tables I want. It works fine, in my local server.

Now I want to implement the same on my server. I just logged into server using rdp and execute the same procedure. On the server, I can see only 11 tables, in which the following tables are not showing

  1. __MigrationHistory
  2. AspNetRoles
  3. AspNetUserClaims
  4. AspNetUserLogins
  5. AspNetUserRoles
  6. AspNetUsers

Are these tables hidden? On local server create user,login functionality works fine. But on the server, no luck. I am using SQL Server 2012 I logged in as administrator in server. Any help?

Improve this question
1
  • Are you sure you did not exeute the script in your master DB or another database? Commented Dec 20, 2014 at 8:24

1 Answer 1

Reset to default
1

I don't suppose you noticed any errors when you ran the procedure the firs time? What is the error you're getting on the server?

You can try running the procedure again, or even just script the missing tables and create them on the server.

Improve this answer
Sign up to request clarification or add additional context in comments.

12 Comments

you said on your local server create user, login functionality works, but on the server no luck... does that not mean you're getting an error?
when i run in server i got this error message "An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct."
Did you try scripting the missing tables and creating them on the server
is there any odrer in executing scripts,i can create only __MigrationHistory table all others get foriegn key constraints errors
Yes there would be an order, but I don't know what that is. I'm guessing AspNetUsers and AspNetRoles should probably be one of the first ones you create. Just keep running the create table script until all the errors you're getting is 'object already exists'. After creating the missing tables, you might also want to copy the data inside the tables over to the server
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.