locked
View Definition permission error on the 'master' database. RRS feed

  • Question

  • I have a very simple Lightswitch app that locally compiles with no errors or warnings.  I have setup Azure using the instructions athttp://blogs.msdn.com/b/lightswitch/archive/2011/03/18/step-by-step-how-to-publish-to-windows-azure-andy-kung.aspx  and it all seems to be fine (certificates, connection to SQL Azure, etc)

    However when I "Publish" from Lightswitch I get the following error...

    Error 1 An exception occurred when deploying the database for the application.
    Failed to import target model master. Detailed message The reverse engineering operation cannot continue because you do not have View Definition permission on the 'master' database.

    The database is an internal Lightswitch database!

    Any help would be gratfully received.

    Wednesday, July 24, 2013 11:09 AM

Answers

  • Hi Brian,

    Your meticulous work  is admirable.

    When we publish a web application to Windows Azure from Visual Studio, we need to follow some steps:

    1.Enable a web application for deployment to Windows Azure

    2.If we use a database in our application, we must change our connection strings to use a Windows Azure SQL Database

    3.If we write a local file from our web application, we need to set up local storage for our web role and write to this local storage

    4.If we have specific assemblies that we have added to our web application, we must set the properties to copy the assemblies so that they are also added to the service package.

    Regarding more detail, you may refer to this: http://msdn.microsoft.com/en-us/library/windowsazure/hh420322.aspx

    In addition, there are some differences between publishing a LightSwitch application to a Windows Azure cloud service from a Windows Azure website.

    Please refer to our document: http://msdn.microsoft.com/en-us/library/windowsazure/jj131261.aspx


    Yunjie Pei
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Angie Xu Wednesday, July 31, 2013 12:05 PM
    Friday, July 26, 2013 5:54 AM

All replies

  • Hi,

    According to the error message, it is the internal database resulting in the problem, as an internal database cannot be published to SQL Azure. It is recommended to use SQL Server database to create this simple LightSwitch application.

    Welcome back, if it dosen't work.


    Yunjie Pei
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, July 25, 2013 12:39 PM
  • Thank you Yunjie for your reply. Are you saying that SQL Server LocalDB databases can't be published to SQL Azure via the Lighswitch wizard or that because I have a problem it may be overcome by moving it to SQL Server?

    I can not find any direction on the net that says publishing to SQL Azure needs an external database.

    Sorry to be pedantic but I would sooner resolve the problem than use a work around.

    Brian


    • Edited by MisterB Thursday, July 25, 2013 1:44 PM spelling mistake
    Thursday, July 25, 2013 1:17 PM
  • Hi Brian,

    Your meticulous work  is admirable.

    When we publish a web application to Windows Azure from Visual Studio, we need to follow some steps:

    1.Enable a web application for deployment to Windows Azure

    2.If we use a database in our application, we must change our connection strings to use a Windows Azure SQL Database

    3.If we write a local file from our web application, we need to set up local storage for our web role and write to this local storage

    4.If we have specific assemblies that we have added to our web application, we must set the properties to copy the assemblies so that they are also added to the service package.

    Regarding more detail, you may refer to this: http://msdn.microsoft.com/en-us/library/windowsazure/hh420322.aspx

    In addition, there are some differences between publishing a LightSwitch application to a Windows Azure cloud service from a Windows Azure website.

    Please refer to our document: http://msdn.microsoft.com/en-us/library/windowsazure/jj131261.aspx


    Yunjie Pei
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Angie Xu Wednesday, July 31, 2013 12:05 PM
    Friday, July 26, 2013 5:54 AM