SQL Server 2005 - Reports Missing From SQL Server Management Studio

  • I'm currently working on a server for which I am unable to obtain any reports on the resident databases. Normally, a DBA can right click on a database name shown in the SQL Server Management Studio interface, a pop-down menu will appear, and "Reports" is one of the options.

    Not on this server.

    Has anyone ever seen this condition before and more importantly, is there a setting somewhere that can turn on the reporting capabilities in SQL Server Management Studio?

    LC

  • Verify the version of the client tools - if they are not at SP2 or greater, the reports won't show up. Also, make sure you are connecting to an instance of SQL Server 2005 SP2 or greater.

    If you are connecting to a 2000 system the reports will not show up.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey,

    Thanks. I'll arrange for SQL Server to receive the updates it needs.

    LC

Viewing 3 posts - 1 through 3 (of 3 total)

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