I’m having trouble with getting external access working on one of my databases.
I have an open ticket (CEF-62823-846) with the issue and I was told that they cannot grant external access and I would need to backup the database, make my changes and then send them the backup to restore. This is not what I’ve had to do with any of my other databases.
I can log in to the database with SQL Server Management Studio. I can see the database and the tables. However, when I click on a table to try to view the data in the table, I get an error.
I was able to work around the error by opening up a query window and just running the queries that way, but there is something that is not set up correctly with the user.
The answer that I was given from support was not acceptable in that I know that you allow the external access as I have it with all of my other SQL databases.
We allow external access, however the error you are getting is about xp_regread if I am not mistaken, and this is not granted for anyone, so the function is trying to do an admin level read from registry, it is not something we can allow.
They actually filtered this through me to verify, when that error is coming, that we cannot enable that function. We did check and all settings were good on the user and permissions however.
I am not sure why you are getting there error unless trying something that won’t work, like you can’t backup on the server itself, but I don’t think you were trying to do that.
Do you have any idea why SQL Management Studio would be giving me this error when all if Do is right click on a table that I created to select the menu option to View all of the rows?
I can highlight the database, right click and select New Query. I can run queries, so I have permissions in the directory. I’m not specifically doing anything to run xp_regread. I’m not trying to access any of the system tables. I do not have an issue with any of my other databases and users that have external database access.