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
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
Hi Martino - using Management Studio works so I'll go with that for now. Regards Jim Allen SkyPilot Software