November 19, 2012 at 8:49 am
I've just set up a new instance of SSRS 2012 and I'm unable to connect to it through Management Studio. The error is:
TITLE: Connect to Server
------------------------------
Cannot connect to <server_name>.
------------------------------
ADDITIONAL INFORMATION:
Unable to connect to the server at <server_name>. 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)
It is a native report server. Reporting Services is running on a separate server to the reporting databases (but I doubt if this matters).
I can connect to the management URL fine. It is using SSL. Does this matter when connecting from Management Studio?
Any help appreciated.
November 20, 2012 at 8:43 am
a silly question but is the service started?
i like to start from the bottom 😉
November 20, 2012 at 8:57 am
No better place to start 😀
The service is definitely started, I can connect through the browser and run reports no problem.
November 21, 2012 at 1:32 am
November 23, 2012 at 3:56 am
I just tried with the URL, still no luck 🙁
EDIT: My configuration had a https URL only. I added a http URL to the configuration and now I can connect with SSMS through this URL.
So it seems that my problem was related to using SSL. Unfortunately I can't leave the http URL so I still need to figure out why I can't connect using the SSL URL.
November 23, 2012 at 4:03 am
you wrote Reporting Services is running on a separate server ....
can you check C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
and the application event viewer for any clues
November 23, 2012 at 5:31 am
I've got this warning message in the Application Log:
The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.
There is nothing significant in the log files unfortunately.
November 26, 2012 at 2:00 am
I've had enough with this issue now, I've decided that I will just enable the http URL when I need to manage this server. That will have to do.
January 18, 2013 at 8:50 am
I know this thread is a little old, but I just came across it while troubleshooting a similar problem with SSRS 2008 R2. I could connect but would get an SSL error everytime I tried to view properties of anything.
In my scenario I realized that I could connect through SSMS to SSRS using SSL if I specified the entire report service URL.
ex: https://ssrsServer.yourcompany.org/ReportServer
Once that was done I connected fine and was able to view everything I expected to.
Joie Andrew
"Since 1982"
May 31, 2016 at 11:26 pm
Hi BLOB_EATER,
I encountered the same issue and your advice worked for my case. Thank you so much!
I tried but couldn't find any information like this (using URI for Server name in SSMS' login dialogue).
I would greatly appreciate it if you could tell me how you came up with this idea or direct me to some documentations on it.
N
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply