locked
failed deploying database into azure RRS feed

  • Question

  • User-1106823036 posted

    I have finished my mvc5 application with sql 2008 database and want to upload now.I have copied the connection string to the web.config file in the mvc aplication and set the 

    <customErrors mode="Off" />

    Now  published, when running the website, it's giving an error that the database is not found, I opened my database server to view the tables and yet none is there. although I tested the connection before publishing and test was successful.

    Can someone help me with this problem please

    Tuesday, December 30, 2014 6:20 AM

Answers

All replies

  • User1759999623 posted

    Where is your database?  Are you using an Azure SQL Database?

    Why are you using a SQL Server 2008 database?  Why not upgrade to SQL Server Express 2014?

    Tuesday, December 30, 2014 9:15 AM
  • User-1242236722 posted

    I had similar issue with azure deployment before. My resolution was to create a database in azure portal first and get hold of connection string pointing to that database.

    Then I ran database update command in pacakge manger console with teh connection string to the sql server database at azure.

    Tuesday, December 30, 2014 4:44 PM
  • User1918509225 posted

    Hi lolo512,

    I suggest  that you could deploy your local database to Azure SQL Server .

    For more information,please refer to the link below:

    http://azure.microsoft.com/en-us/documentation/articles/sql-database-deploy/

    Best Regards,

    Kevin Shen.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 5, 2015 1:53 AM