locked
ASP.Net Web API 2.0 and SQL 2008 R2 ? RRS feed

  • Question

  • User-72415733 posted

    We are trying to create a new web forms application using VS2013, .Net 4.5 framework and Web API 2.0. This works just fine when we create the default web forms application and register a new user which uses entity framework to create the local db and tables automatically. If we then change the connection string to point to our development full sized SQL 2008 R2 server it fails when we attempt to register the new user. This SQL box supports other apps that use entity framework. We get the following error and the database and tables are not created:

    MetadataException was unhandled by user code: An exception of type 'System.Data.Entity.Core.MetadataException' occurred in mscorlib.dll but was not handled in user code

    I have also posted a question on stackoverflow here:

    http://bit.ly/1pmHwcc

    Monday, April 21, 2014 8:51 AM

Answers

  • User-72415733 posted

    Sorry for this question - I found the answer. The account in the connection string did not have enough permissions to create the db and table. FIXED.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 21, 2014 10:59 AM