locked
LightSwitch Deployment Error 15418 “Only members on the sysadmin role or the database owner can set the compatibility level” RRS feed

  • Question

  • Trying to create a tier-two desktop application on Visual Studio 2012 LightSwitch C#. For a university project in South Africa. Tried our first deployment test and came up with the error:

    15418: "Only member on the sysadmin role or the database owner can set the compatibility level"

    Have tried to change users and roles, delete users and roles, have no roles. We think the problem lies in this area, but cannot be sure. If anyone can tell us what does the error means and how to fix it ? It will be much appreciated.

    Friday, October 9, 2015 3:49 PM

Answers

  • 15418: "Only member on the sysadmin role or the database owner can set the compatibility level"

    HI,

    According to the error message above, you may look into your lmsl file,  and ProviderManifestToken looks like this:

    <DataService.ConnectionProperties> (snip) <ConnectionProperty Name="ProviderManifestToken" Value="2012" /> </DataService.ConnectionProperties>

    Or you can try to change the compatibility level of a database, and check whether it makes any difference.

    Angie


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Angie Xu Wednesday, October 21, 2015 7:48 AM
    • Marked as answer by Angie Xu Thursday, October 22, 2015 1:37 AM
    Monday, October 12, 2015 8:28 AM