SQL Modify ERROR

Discussion in 'Hosting Services / Control Panel' started by jjjallen, May 26, 2013.

  1. I'm getting this error when trying to modify my DB schema:
    SQL00000 :: The target database schema could not be retrieved. The reverse engineering operation cannot continue because you do not have View Any Definition permission on the server 'tcp:sql2k1201.discountasp.net'.


    I'm doing the change via .Net 2012.
    What do I need to do?

    Regards
    Jim Allen
    SkyPilot software
     
  2. martino

    martino DiscountASP.NET Staff

    I been seeing this error lately. One other person stated that they were getting this error in Visual Studio. The one thing they did to resolve the issue was to restart Visual Studio.

    Or trying creating the DB schema directly on the SQL database using SQL Server Management Studio. Read our knowledge base article on how to connect to the SQL database using SQL Server Management Studio here: http://support.discountasp.net/KB/a186/how-to-connect-to-sql-server-2008-using-sql-server.aspx
     
  3. Hi Martino - using Management Studio works so I'll go with that for now.

    Regards
    Jim Allen
    SkyPilot Software
     

Share This Page