• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

SQL2008 Management Studio, Database not displaying any Tables

I've installed an ERP Application that use MS-SQL 2008 Server, in the previous version, running on MS-SQL 2005, within Management Studio you were able to browse the Tables created.

The ERP App works fine and connects and creates it's Data perfectly so the Data is there.

There should be 500 odd Tables. Is there a setting for viewing the Tables within SQL-Management Studio without using SQL Script. (Please refer to the attached image)

Thank you in advance
Tables.jpg
0
renier971
Asked:
renier971
  • 5
  • 4
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Seems like the login you used to connect to the database via SSMS doesn't have SELECT privileges over those tables and hence it is not listed out for this particular login..

You will get the same result even if you use the same login for TSQL approach.

Ask your DBA or sa to grant SELECT privileges on those tables.
0
 
eiramarCommented:
Does your account have read right on the database/tables?

Check under security, your login and see what roles you have assigned for your account.
0
 
renier971Author Commented:
Thank you for the responses.

There is a db_reader role, I've added the required members under this role but still can not view the tables, I've logged in as both the "sa" user who should have all access by default and user created by the system.

Anything I am missing?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
if you are logged in using sa role, then all tables should be visible to you..
Have you granted db_datareader role correctly to this particular database and checked it..
Somewhere it went wrong and hence its not visible to you..
0
 
renier971Author Commented:
Thanks rrjegan17, I don't see the tables even logged in as 'sa'

The OS is running on VMware workstation we are using for testing. The OS in this case is Windows XP SP2, SQL 2008 32-Bit, any known issues?

Yes I did grant the db_datareader to a new user I created with select permissions etc. on the Database.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Thanks rrjegan17, I don't see the tables even logged in as 'sa'

Then it can't be definitely the correct instance or database you are testing with..

>> The OS is running on VMware workstation we are using for testing. The OS in this case is Windows XP SP2, SQL 2008 32-Bit, any known issues?

No issues with the OS and SQL Server but definitely a permission issue.
0
 
renier971Author Commented:
>>Then it can't be definitely the correct instance or database you are testing with..
There's a single Named Instance with only 1 Database, I am connecting to the Database from the ERP application.

However when trying to view the Tables in SQL I get the above result. I've created a user other than 'sa' and gave him permissions to the entire Database and still can't view the tables within the Database.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> There's a single Named Instance with only 1 Database, I am connecting to the Database from the ERP application.

Hope ERP application is installed in the same machine..
And what is the credential used by that ERP application so that we can try using that..
0
 
renier971Author Commented:
Oke resolved there is a message displayed underneath Tables  "See Object explorer for details for Object in this folder" ...RTFS

The Object Explorer Details allows you to view the tables, LOL as simple as that.
0
 
renier971Author Commented:
Thanks for the assist.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now