CODEWITHSUNDEEP
asp.netsql-serversql-server-2012
Sherin
Sherin

Reputation: 431

Table missing in SQL Server 2012 created using aspnet_regsql

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?

Upvotes: 0

Views: 259

Answers (1)

Spock
Spock

Reputation: 4910

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.

Upvotes: 1

Related Questions