No "Report" option in Object Exlporer? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

SQL Server 2005 Forums

SQL Server Administration (2005)

No "Report" option in Object Exlporer?

Author

Topic

Kit
Starting Member

5 Posts

Posted - 2008-07-24 : 10:35:06

This is my first post here, so go easy on me please. :-)

I'm trying to use the SQL Server 2005 Performance Dashboard Reports (http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en).

In the past, the only way I have ever gotten to reports is by using the Summary tab when I select an instance or a database in SSMS. It's the little green notebook.

Now, when I read various resources about how to use these custom reports, they say that I should be able to right-click objects in the Object Explorer window and get a "Reports" option in the context menu:

"right click on a database in SSMS, go to "Reports" item, then click on the "Custom Reports" item."
- http://www.simple-talk.com/sql/sql-tools/custom-reports-in-management-studio,-using-the-performance-dashboard/

"Right-click a node in Object Explorer, point to Reports, point to Custom Reports and select a custom report "
- http://blogs.msdn.com/sqlrem/archive/2006/11/20/custom-reports-in-management-studio.aspx

and so on.

Trouble is, I dont' have that option in SSMS.

If I right-click on an instance (when logged in as sa), I get the following:
- Connect...
- Disconnect
- Register
-------------------------
- New Query
-------------------------
- Start
- Stop
- Pause
- Resume
- Restart
-------------------------
- Refresh
- Properties

If I right-click a database, I get these options:
- New Database...
- New Query
- Script Database as ->
-------------------------
- Tasks ->
-------------------------
- Rename
- Delete
-------------------------
- Refresh
- Properties

Am I looking in the correct place? Can anyone think why I might not have the report option?

When I go to help -> About, I have the following software versions:
Microsoft SQL Server Management Studio 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 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600

Thanks in advance for your help,
Chris

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-24 : 10:48:00

Did you install Performance Dashboard ? Has SP2 been applied to your server?

Kit
Starting Member

5 Posts

Posted - 2008-07-24 : 11:29:14

When I run this code:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I get this result set:
9.00.3159.00 SP2 Enterprise Edition

I installed the Performance Dashboard on the server, according to the directions I found here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

"Additional Information
The SQL Server instance being monitored must be running SP2 or later. After completing the installation, you must:
1. Run the Setup.sql file on each instance of SQL Server 2005 that you wish to monitor with the SQL Server 2005 Performance Dashboard Reports.
2. Open the performance_dashboard_main.rdl file with the Custom Reports functionality new to Management Studio in Service Pack 2."

I'm getting stuck at step 2, of course.

I'll double check that I installed the .sql on the correct instance.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2008-07-24 : 11:36:16

I don't have that menu option, but I don't have any custom reports.
Have you created your own reports? I think that menu option may only be for YOUR OWN reports.

This is from the first link:
"You can even create your own reports and access them by right-clicking on the object you wish to investigate in the object browser pane "

Kit
Starting Member

5 Posts

Posted - 2008-07-24 : 13:46:28

"I don't have that menu option, but I don't have any custom reports.
Have you created your own reports? I think that menu option may only be for YOUR OWN reports."

That may be so. I haven't found any documentation that is explicit about this. In other words, nothing I have found says, "You won't have a 'Reports' menu option until you create some custom reports".

Even so, it would seem that the customs reports in the Performance Dashboard would count somehow? According to the instructions, the .rdl files don't have to be a in a certain place to be recognized. I imagine one browses the filesystem for them?

"There is no requirement that the report definition files or help file reside in a specific location. ... The first time you choose the Custom Report option you will be prompted to choose the report to run. Browse to this share and select the performance_dashboard_main.rdl report file. Future access to the dashboard can be done using the recent file list instead of manually browsing to the share."
- From the PerfDash.chm file that comes with the dashboard

So my guess that the feature should be popping up for me now. I have also checked that I ran the setup.sql script against the correct instance.

Thoughts?

Thanks,
Chris

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-24 : 13:50:47

Apply sp2, that'll give to reports option by right click in ssms.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-24 : 14:00:49

SP2 has already been applied.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-24 : 14:03:58

>> SP2 has already been applied.

With version number 9.00.1399.00? You may need double check.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-24 : 16:06:25

"When I run this code:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I get this result set:
9.00.3159.00 SP2 Enterprise Edition"

Don't you see his second post?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-24 : 16:25:47

This is for sql engine, not sql tools.

Donald Murphy
Starting Member

5 Posts

Posted - 2008-07-24 : 16:53:26

You need to look under Help/About in Management studio to get the version of the tools installation.

Kit
Starting Member

5 Posts

Posted - 2008-07-25 : 08:50:45

This is from my initial post:

"When I go to help -> About, I have the following software versions:
Microsoft SQL Server Management Studio 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 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600"

Do any of those look like they need upgrading?

Thanks again for all of your help.

EDIT: Ok, looking here (http://www.sqlserverclub.com/essentialguides/sql-server-version-numbers.aspx) and other places I see that I need my tools to have a version number of 9.00.3042.00 or higher. I'll try to find the newest version of SSMS I can get my hands on and see if that helps.

I'll update this thread later today.

- Chris

Kit
Starting Member

5 Posts

Posted - 2008-07-25 : 14:50:01

Success!

It works with the following setup:

Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

Thanks much for all of your help.

- Chris

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-26 : 21:12:51

>> Ok, looking here (http://www.sqlserverclub.com/essentialguides/sql-server-version-numbers.aspx) and other places I see that I need my tools to have a version number of 9.00.3042.00 or higher.

That's what I mentioned about sql tool version.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources