When our group was running a trial version of TOAD Data Point, our connection to our server through the SQL Server worked fine. Since then, we purchased the product, but there was a lapse of a few weeks, and during this time the server migrated.
We were able to make the new connection, and everything appears fine, until we attempt to open the tables. Then we get the following error:
X SQL Server Database Error
VIEW DATABASE STATE permission denied in database ‘X’.
The user does not have permission to perform this action.
Here’s a screenshot:
We can get to this database and work with these tables in Microsoft Access, and we can also connect with these tables using the ODBC Generic connection, although we want to keep our data as SQL Server-parallel as possible. It worked before, so we aren’t sure why it’s no longer working.
Anybody know what gives?
Thanks in advance.