CODEWITHSUNDEEP
sqlasp.net-mvc-3
Charbel Wakim
Charbel Wakim

Reputation: 146

connect mvc3 membership with sql database

I am using the built-in membership for mvc3 with an online sql database, so I changed my connection string to look like this:

<connectionStrings>
   <add name="ApplicationServices" 
        connectionString="Data Source=72.18.142.170,1533;Network Library=DBMSSOCN;Initial Catalog=entertainment;User Id=uname;Password=pswd;"  
        providerName="System.Data.SqlClient"/>
</connectionStrings>

But when I try to register a new user I get the following error:

{"Invalid object name 'dbo.aspnet_SchemaVersions'."} System.Data.SqlClient.SqlException

Thank you for your help

Upvotes: 0

Views: 807

Answers (1)

David
David

Reputation: 218808

The table aspnet_SchemaVersions doesn't exist in the database entertainment (or at least in the default schema). (Conversely, I suppose it's possible that the user uname just doesn't have access to the table.)

You need to create the tables for the membership provider to use.

Upvotes: 1

Related Questions