Can't see Server Explorer - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Can't see Server Explorer

Author

Topic

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 10:21:55

Hi,

I just installed 2005 Evaluation version (high spec laptop but running Windows XP Home edition).

Have opened SQL Server Management Studio then set up a dummy database with a table and a query then tried opening the Server Explorer.

I understand that Server Explorer should be on the 'View' tab with, say, Object Explorer but I can't see it.

Does the fact I am running this on XP Home edition have anything to do with it? Or do I need to run another SETUP.EXE or configure some options or is it something else?

When I installed SQL Server 2005 I got one error message saying:

quote:
- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

Does Server Explorer need IIS to be running in order to work?

Help will be very appreciated.

Thanks in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-18 : 10:24:57

F8 makes the Object Explorer hide and unhide.

E 12°55'05.25"
N 56°04'39.16"

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 10:29:29

quote:
Originally posted by Peso

F8 makes the Object Explorer hide and unhide.

E 12°55'05.25"
N 56°04'39.16"

Thanks, that was something I didn't know. Do you know the hotkey for Server Explorer? (I'll loko it up anyhow).

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-18 : 10:37:07

Look under the VIEW menu.

E 12°55'05.25"
N 56°04'39.16"

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 10:44:23

quote:
Originally posted by Peso

Look under the VIEW menu.

E 12°55'05.25"
N 56°04'39.16"

Its not appearing there. There is something called the 'Solution Explorer' but I believe they aren't the same.

I'm reading Wrox's SQL Server 2005 Programming book. The author refers to the Server Explorer. Was that possibly renamed 'Solution Explorer' by Microsoft or are they two distinct things?

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-09-18 : 10:48:06

perhaps they mean the "registered servers" window.

elsasoft.org

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 10:54:06

quote:
Originally posted by jezemine

perhaps they mean the "registered servers" window.

elsasoft.org

Afraid no. That's something different.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-18 : 10:58:28

A know a lot of things changed between beta version of SQL Server 2005 and RTM version.

E 12°55'05.25"
N 56°04'39.16"

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 11:12:41

Ok, lets, ask this from a different angle.

If you are trying to debug a stored procedure or a function how do you start the debugger window?

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-18 : 11:22:18

Can you do me a favour?

This is the screen shot I get if I go into HELP ABOUT in the SQL Server Management Studio:

Microsoft SQL Server Management Studio (expires in 177 days) 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600

Do you get similar values?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-18 : 12:04:01

debuging isn't available in SSMS.
you have to do it in visual studio.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

X002548
Not Just a Number

15586 Posts

Posted - 2007-09-18 : 12:11:38

What are you trying to debug?

Cursors, Loops, nested sprocs, nested transactions?

I debug code by looking at it

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-09-27 : 13:05:21

Hi,

Thanks to all who answered. I bought Visual Studio 2005 on Saturday 22nd Sept, not having been here since I posted my last note. I had previously been using the evaluation version from Microsoft's own website.

The guide book Microsoft provide in the box (which of course you don't get with the evaluation version) shows that Server Explorer is in the Visual Studio 2005 IDE, not SQL Server Management Studio, confirming spirit1's helpful comments.

Quick note to X002548: the debugger in Visual Studio can debug your code the same way you debug Visual Basic, letting you set breakpoints, highlight problematic code and has a window to show variable values as the code executes line by line. Hi 5's all round.

I'm not sure Microsoft get as far as teaching how to use it on any of their MSCD type courses these days. They're usually too busy talking about indexes and clustering!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources