Error while trying to connect with SSRS through SSMS

• Sgar...

  SSCarpal Tunnel

  Points: 4409

  More actions

  February 27, 2012 at 10:40 pm

  #391668

  Error while trying to connect with SSRS through Sql server management studio

  Hi

  I have installed SQL Server 2008 R2 on my system. Reports manager is working fine for me, but when I tried to connect to Reporting service instance using SSMS, I got the following error. I am not able to understnad why it is happening.

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

  Sagar Sonawane
  ** Every DBA has his day!!:cool:

• Pradyothana Shastry

  SSCertifiable

  Points: 5211

  More actions

  February 27, 2012 at 11:56 pm

  #1452388

  http://blog.sqlauthority.com/2011/05/03/sql-server-error-failed-to-retrieve-data-for-this-request-microsoft-sqlserver-management-sdk-sfc-databaseproperty-is-not-a-recognized-built-in-function-name-microsoft-sql-server-error-1/

  
  - Pradyothana http://www.msqlserver.com