SSMS - Databases are not Visible

Question

SSMS - Databases are not Visible

Minnu

SSCertifiable

Points: 6451
More actions
July 11, 2013 at 3:19 am

#277260

Hi Team,
After connecting SSMS 'Databases, Security, Server Objects, Management' folders are not showing in the object explorer,
again i need to connect to sql server with login credentials then only above folders are showing.
Is there any configuration required to display the above folder automatically once login to SSMS.
Please suggest...

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

You will be only be able to see objects you have any permissions on. Ask your administrator to grant you the permissions that you need.

John

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

John Mitchell-245523 (7/11/2013)
You will be only be able to see objects you have any permissions on.
John

Not necessarily. You can see databases where you don't have any permissions on it.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?

John

Minnu SSCertifiable Points: 6451 More actions · Answer 4

On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?

John

Yes John Exactly,

I've all the rights, but when i open sql server (SSMS), all the folders should be displayed (without expand).

Sean Pearce SSCoach Points: 15999 More actions · Answer 5

Minnu (7/11/2013)
On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?
John
Yes John Exactly,
I've all the rights, but when i open sql server (SSMS), all the folders should be displayed (without expand).

There is nothing to display until you connect to a server.

What are you expecting to see under "Databases" or "Server Objects" if you have not connected to a server?

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Minnu SSCertifiable Points: 6451 More actions · Answer 6

Hi Team,

am writing in-detail,

Step 1: opening sql server > Start > Programs > Micro soft sql server > SSMS

Step 2 : Connecting to Database engine by Login and Password.

Step 3: SSMS is opening, with Object Exploter (left side - Vertical Window), and a blank query window 'sqlquery1.sql' is opening in right pane.

My query is : am able to see object explorer but, instance name and databases are not showing in the object explorer.

to get the instance name and databases, i need to again click on connect button, then select Database engine and login again with my credentials.

WHY INSTANCE NAME AND DATABASES ARE NOT SHOWING AFTER FIRST LOGIN,

HOPE U UNDERSTAND BETTER NOW...

Sean Pearce SSCoach Points: 15999 More actions · Answer 7

Minnu (7/11/2013)
HOPE U UNDERSTAND BETTER NOW...

Yes, I understand now.

Your SSMS options allows you to open Object Explorer and a New Query at start-up. You probably have it set to open just New Query.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Minnu SSCertifiable Points: 6451 More actions · Answer 8

Thank You:-) Sean Pearce 🙂

I got what i Want.

Thanks Once again.:-):-):-):-)

Minnu SSCertifiable Points: 6451 More actions · Answer 9

Thank You:-) Sean Pearce 🙂

I got what i Want.

Thanks Once again.:-):-):-):-)