SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS-Report Manager Unable to connect to the remot
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pittrecon08
Starting Member

11 Posts

Posted - 06/20/2013 :  21:46:00  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/21/2013 :  02:21:25  Show Profile  Reply with Quote
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 - 06/21/2013 :  12:22:21  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/21/2013 :  12:44:14  Show Profile  Reply with Quote
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 - 06/21/2013 :  23:14:03  Show Profile  Reply with Quote
Clients access report server outside through the internet url.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/22/2013 :  02:32:57  Show Profile  Reply with Quote
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 - 06/22/2013 :  13:57:11  Show Profile  Reply with Quote
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



Edited by - pittrecon08 on 06/24/2013 09:18:22
Go to Top of Page

pittrecon08
Starting Member

11 Posts

Posted - 07/01/2013 :  12:41:42  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 07/02/2013 :  03:20:26  Show Profile  Reply with Quote
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 - 07/02/2013 :  08:42:39  Show Profile  Reply with Quote
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.

Edited by - pittrecon08 on 07/02/2013 08:44:25
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000