February 5, 2013 at 6:57 pm
Dear All,
I am facing some problem in connecting the Reporting Services (2008R2).
it is throwing the following error.
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)
----------------
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.
February 5, 2013 at 11:22 pm
Are you able to get into reporting services configuration manager?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 6, 2013 at 9:02 am
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.
February 6, 2013 at 9:17 am
In Configuration manager, try changing the port from 80 to 8080 for the Report Manager and Report Server sites. This generally works for me.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 6, 2013 at 11:12 am
Hi,
I have changed the port number also.. still no luck 🙁
Do i need to change any other configurations?
Thanks,
Santosh
February 6, 2013 at 11:36 am
What is the operating system?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 6, 2013 at 9:38 pm
OS: Windows 7 64 bit
February 7, 2013 at 10:20 am
The UAC (user account control) is probably interfering then. Try disabling UAC in control panel and see if that helps.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2013 at 11:59 pm
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.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply