Unable to Connect Reporting Services (2008R2) in SSMS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Unable to Connect Reporting Services (2008R2)...

Unable to Connect Reporting Services (2008R2) in SSMS

Rate Topic

Display Mode

Topic Options

Author

Message

santoooo

Posted Tuesday, February 05, 2013 6:57 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

Dear All,

I am facing some problem in connecting the Reporting Services (2008R2).

it is throwing the following error.
[color=#FF0000]
TITLE: Connect to Server
------------------------------
Cannot connect to <<SERVER>>.
------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the server at <<SERVER>>. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later.
Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode.

(Microsoft.SqlServer.Management.UI.RSClient)
----------------[/color]

my Sys configarations
OS : Windows7 64 bit
SQL: SQL2008R2.

I have cross checked the following things.

1. In Report Server Configuration Tool, in Database tab, i created the new database under native mode sill NO LUCK,
2. I have installed a fresh copy of Reporting Services with named instance still NO LUCK
3. In the ReportServer DB. under ConfigurationInfo table it is (SharePointIntegrated is False).

Please help me in this regard how to rectify this. Do i need to uninstall and reinstall entire SQL2008R2 or it is just a configuration change?

Thanks in Advance..

-Santosh.

Post #1416203

SQLRNNR

Posted Tuesday, February 05, 2013 11:22 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Are you able to get into reporting services configuration manager?

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1416256

santoooo

Posted Wednesday, February 06, 2013 9:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

Hi Jason,

Thank you for your reply,,

Yes i am able to open the Reporting Services Configuration Manager..

I am not able to browse the ReportServer and Report Manager also.. It is showing HTTP 500 error when i try to browse in IE.

Thanks,
Santosh.

Post #1416569

SQLRNNR

Posted Wednesday, February 06, 2013 9:17 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

In Configuration manager, try changing the port from 80 to 8080 for the Report Manager and Report Server sites. This generally works for me.

Post #1416586

santoooo

Posted Wednesday, February 06, 2013 11:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

Hi,

I have changed the port number also.. still no luck Sad

Do i need to change any other configurations?

Thanks,
Santosh

Post #1416651

SQLRNNR

Posted Wednesday, February 06, 2013 11:36 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

What is the operating system?

Post #1416665

santoooo

Posted Wednesday, February 06, 2013 9:38 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

OS: Windows 7 64 bit

Post #1416803

SQLRNNR

Posted Thursday, February 07, 2013 10:20 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

The UAC (user account control) is probably interfering then. Try disabling UAC in control panel and see if that helps.

Post #1417225

santoooo

Posted Thursday, February 07, 2013 11:59 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

Hi,

I have tried the same, but still i am facing the problem.

I am planing to Uninstall and Install a fresh copy of SSRS 2008 R2, and let you know if this works or not.

Thanks,
Santosh.

Post #1417474

« Prev Topic | Next Topic »

Permissions