ASP.NET 4.5 Free Hosting - EF to SQL 2008 Problem - CREATE DATABASE permission denied

Discussion in 'ASP.NET / ASP.NET Core' started by Zakos, May 10, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Zakos

    Zakos

    Hi ,

    first thanks for the free hosting 4.5 beta , I did a new mvc 4.5 project tempalte - deploy it (Very Easy ) using Visual Studio - and site works great , includes the Database with login/register users.

    Now , I want to use EF (5) for create a new model , lets call it Students , now I want that a new table Students will be added auto, but I get this error :

    CREATE DATABASE permission denied in database 'master'.

    1) Why is it trying to add to 'master' DB , and not to the DB's name I got , where all Application/MemberShip/Users.. etc ?

    2) Permission problem?

    3) What to do?
     
    Zakos, May 10, 2012
    #1
  2. Zakos

    Zakos

    * Using the same String Connection I got for the Free Beta for the EF.

    * Any working example maybe? for EF creating a Table in your remote DB?

    I don't know if its configuration problem or permission problem.
     
    Zakos, May 10, 2012
    #2
  3. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Hi Zakos,

    I'm afraid it's a permission problem. You won't be able to execute a CREATE DATABASE statement because it requires SA privileges, and there would be no way to manage the databases or space in a shared hosting environment.
     
    RayH, May 10, 2012
    #3
  4. Zakos

    Zakos

    Tasslehoff thanks for your reply ,

    to try asp.net 4.5 beta , is to try EF Code First feature too ,

    so something missing here with the new hosting,

    "We're providing a free sandbox so developers can test out what’s next."

    1) If I buy full 4.5 beta hosting from you , I will be able to do it?

    2) Is there an example for the Control Panel ?
     
    Zakos, May 12, 2012
    #4
  5. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    Even when .net 4.5 is launched, we still would not support an app creating a database. There would be no way for us to manage the databases if we allowed that. How would our system know that your app created a database. That would lead to all sorts of issues with availability of sql tools, backups, api....etc.

    After official launch, if you need a database, you would create it using our control panel so that every part of the sql service is hooked up and functional.

    With the beta, we provide a sql database so you can test .net 4.5 beta out with a database.
     
    Takeshi Eto, May 12, 2012
    #5
  6. Zakos

    Zakos

    I can tell you a database name that I will create use ,only 1 is needed.

    So you can hook it up to your system , EF Code First is coming very popular

    which will need your support someday.

    By the way , Is there an example of a Control Panel I can try ?
     
    Zakos, May 13, 2012
    #6
  7. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    We have a control panel demo on our site - http://www.discountasp.net/sp_cpdemo.aspx

    In a shared web hosting environment, we cannot support an app creating a database. If you need this feature, you will need to find a vps or dedicated hosting solution. But these hosting solutions typically do not include the sql tools that we provide.
     
    Takeshi Eto, May 13, 2012
    #7
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page