You do not have View Any Definition permission on the server 'mssql5.gear.host


#1

I solved my issue but putting this here just in case someone else has the same issue.

I was updating a database that hasn’t changed in a few months (maybe a year) and it gave the error:
“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 ‘mssql5.gear.host’.”

Looking at the database page on https://my.gearhost.com, it looks like the server name changed to ‘den1.mssql5.gear.host’.
Updating my connection string to include den1 seems to have fixed the issue. Not sure when den1 was added. Guessing a missed an email about this at some point.


#2

Hi,
How did you updating the connection string to include den1?


#3

The old connection string included the server name ‘mssql5.gear.host’. At some point the server name changed and changing the connection string’s servername over to ‘den1.mssql5.gear.host’ worked for us.

If you’re having issue with your connection string see https://www.gearhost.com/documentation/connection-strings


#4

@maayansoft Most of the time the connection string is in your web.config file. If you are still having issues please open a support ticket.