SQL 2005: Object Browser does not populate when starting Mgmt Console

[mkrausnick]

This has to be something simple. I start the Sql Server 2005 management console with the command:

"C:\...\SqlWb.exe"  -S ServerName -E -nosplash

and the console comes up connected (the list of databases in the dropdown is populated) but the object browser is blank. I have to click the Connect -> Database Engine button and go through the connection dialog. Then the object browser populates and displays.

How can I get the Management console to come up with the object browser populated so I don't have to go through the dialog each time?

Other information: The server name has a dash in it. I tried enclosing the server name in single quotes and double quotes. Same result.

Mike Krausnick
Dublin, California

 

[mrdenny]

According to the switches there is no switch to tell SQL Server what server to connect the object explorer to. You should submit this as a new feature for a future version of SQL Server at

http://connect.microsoft.com.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mkrausnick]

Thanks for responding. Typing

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"  /?

into the RUN command yields a dialog box that says otherwise. It's graphical so I can't reproduce it here, but try it. So anyway, I have to manually connect to the SQL server each time I run the Mgmt Console? That doesn't seem very efficient.


Mike Krausnick
Dublin, California

 

[mrdenny]

The flags say that the -S is the server to connect to. Your query window has connected to that server. The object explorer is a seperate connection to the server and it's apparently not setup to take the -S switch.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com