November 18, 2017 at 6:33 pm
I am trying to access the tables and other objects in a database for a off the self application.
I tried dBeaver and dbVisualizer and both show the same. Seems like system data tables not the application data tables.
In dbVisualizer, if I click on the schema/database named cresql I see a list of tables but can't click on any and expand. In dBeaver, it does not even show the names of tables.
I am connecting as sa to the sql server instance but cant see individual tables. If I run any SQL it works fine.
Is this a way to keep the schema/database hidden from normal access in a packaged app?
November 20, 2017 at 12:32 pm
ak08820 - Saturday, November 18, 2017 6:33 PMI am trying to access the tables and other objects in a database for a off the self application.
I tried dBeaver and dbVisualizer and both show the same. Seems like system data tables not the application data tables.
In dbVisualizer, if I click on the schema/database named cresql I see a list of tables but can't click on any and expand. In dBeaver, it does not even show the names of tables.
I am connecting as sa to the sql server instance but cant see individual tables. If I run any SQL it works fine.
Is this a way to keep the schema/database hidden from normal access in a packaged app?
No, there isn't anything like this native to SQL Server to hide things from applications. Have you tried using SSMS? What permissions do you have on the instance?
It's more likely related to your permissions or how you configured the other apps.
Sue
November 20, 2017 at 3:58 pm
Yesterday, I could not install SSMS. Probably an error in the downloaded file.
I have the sa ID and perms.
Can I copy the .mdf file to another machine and use SSMS on that file there?
November 20, 2017 at 4:11 pm
ak08820 - Monday, November 20, 2017 3:58 PMYesterday, I could not install SSMS. Probably an error in the downloaded file.
I have the sa ID and perms.Can I copy the .mdf file to another machine and use SSMS on that file there?
If you aren't familiar or comfortable doing a backup and then restoring to the other server, you can try to do a detach from the source and attach to the new server. This document shows you how to do it using SQL statements:
Move a Database Using Detach and Attach (Transact-SQL)
Sue
November 21, 2017 at 1:32 pm
I finally have SSMS installed after it failed a couple of times. Now, everything is visible. Wonder why dbVisualizer and dBeaver both failed. Even after I changed the instance to the named instance (which SSMS automatically picked up) dBeaver failed to show the application tables. Very strange.
November 21, 2017 at 1:43 pm
ak08820 - Tuesday, November 21, 2017 1:32 PMI finally have SSMS installed after it failed a couple of times. Now, everything is visible. Wonder why dbVisualizer and dBeaver both failed. Even after I changed the instance to the named instance (which SSMS automatically picked up) dBeaver failed to show the application tables. Very strange.
I figured it was something with those applications but have no idea what. Most likely some config setting somewhere. Maybe they were stuck pointing to the master database?
If you find what it is, it would be great if you could post back as that would help anyone else who hits the same problem and finds this when searching.
Sue
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply