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
renier971Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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 & Architect, EE Solution GuideCommented:
>> 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 & Architect, EE Solution GuideCommented:
>> 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
renier971Author Commented:
Thanks for the assist.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.