Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS-Report Manager Unable to connect to the remot

Author  Topic 

pittrecon08
Starting Member

11 Posts

Posted - 2013-06-20 : 21:46:00
We installed SSRS 2008 R2 standard edition on the web server (windows server 2008 R2), clients can deploy reports to the report server, I can view these reports on the report server. While clients cannot access report manager URL, only shows report manager partial GUI, error msg “unable to connect to the remote server”. Any idea?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-21 : 02:21:25
is the server open to internet? Are the clients accessing it inside same domain? if outside, is it a VPN setup with clients using windows authentication (with domain usernames)?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 2013-06-21 : 12:22:21
What do you mean open the server to internet? SSRS 2008 is independent to IIS. more details for newbies, please.

quote:
Originally posted by visakh16

is the server open to internet? Are the clients accessing it inside same domain? if outside, is it a VPN setup with clients using windows authentication (with domain usernames)?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs


Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-21 : 12:44:14
i didnt ask about IIS. I know SSRS 2008 is independent of IIS
my question was regarding how users will be accessing the report server. Inside firewall in the domain or outside through internet url

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 2013-06-21 : 23:14:03
Clients access report server outside through the internet url.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-22 : 02:32:57
oh ok...so they use a sql login or an external login? and is mapping done internally to a domain login?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 2013-06-22 : 13:57:11
Clients use intranet login--domain user account. I do not know how to map. We use SSRS configuration manager and report manager to assign roles.

quote:
Originally posted by visakh16

oh ok...so they use a sql login or an external login? and is mapping done internally to a domain login?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs


Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 2013-07-01 : 12:41:42
tried to copy report manager url to the config file and set the connection level "0" , but no luck, still not work. Any idea?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-02 : 03:20:26
quote:
Originally posted by pittrecon08

Clients use intranet login--domain user account. I do not know how to map. We use SSRS configuration manager and report manager to assign roles.

quote:
Originally posted by visakh16

oh ok...so they use a sql login or an external login? and is mapping done internally to a domain login?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs





Then wats the issue
so long as you've mapped the domain accounts they use to a valid role within SSRS reportserver (like Browser) they should be able to access the reports.
You can manage these access rights from report manager UI

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 2013-07-02 : 08:42:39
We added clients and assigned corresponding roles. Clients tried to open report manager url. It prompted a window for username/pw, we input correct account info, it loaded partial Report Manager GUI and showed error msg "Unable to connect the remote server". We added specific report server URL (http://123.234.45.345:8101/reportserver) in the rsreportserver.config file. We added report manager url on the "local intranet" list. With no luck...
Btw,we used windows firewall and IPsec, we opened the port ,added clients IP on the list.
Go to Top of Page
   

- Advertisement -