May 22, 2010 at 9:02 am
We have Installed a Bugnet it's a Bug tracker application.
The application runs fine..It created a Database called Bugnet...But we do not see the tables which are created under the Bugnet database...Even if we give all the permission to the user account..still we cannot see the tables under the database...
If we look at the configuration string in the application...It starts with path ./ it means the database is stored under local server...so it should present some where on my system...But I do not see it...
PLease someone help me with this Issue....
May 22, 2010 at 9:30 am
You said you granted the user account "all permissions", but make sure that view schema permission is one of them.
Metadata Visibility Configuration
http://msdn.microsoft.com/en-us/library/ms187113.aspx
VIEW DEFINITION Permission
http://msdn.microsoft.com/en-us/library/ms175808.aspx
If this doesn't make the tables visible in SSMS, then next temporarily add the user account to the db_owner role, just to confirm that what you're expecting too see is actually there.
The 3rd party application may have even been bundled with SQL Server Express edition and installed it's own instance. Using the browser service is one way to determine what instances are installed.
http://msdn.microsoft.com/en-us/library/ms181087.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 22, 2010 at 9:32 am
I'm not sure if this is the best place to ask for issues with a 3rd party product...
You should check a website/forum related to that software.
May 22, 2010 at 10:21 am
Thanks for the Reply
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply