March 11, 2014 at 10:31 am
Hi, all
We have all local development, on SQL Server 2012 and I'm thinking how I can share my local SSRS server with other on the network, is there any place/way to configure it?
Or probably there are some better ways to do this.
We are on small network, right now neighbouer can ping my machine, but can't go to my local ssrs server going to:
http://my-machine/Reports/Pages/Report.aspx?ItemPath=%2Test%2fTestReport
and I made him content manager, browser on my ssrs server.
Best
Mario
March 11, 2014 at 1:05 pm
Why do they want to access your local server ? You can just grant them access to Report Manager to develop\deploy reports.
--
SQLBuddy
March 11, 2014 at 4:05 pm
Are you on a domain?
Did you turn off the firewall?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:09 pm
Thanks all,
that our setup, we all do local work, don't have any common SSRS server,
Biz users just want to get access to our SSRS server to validate reports.
I setup security up to max level for them on Report Manager, but it won't help.
We're on the same domain network wise, no firewall (assume I can ping OK).
M
March 11, 2014 at 4:11 pm
mario17 (3/11/2014)
Thanks all,that our setup, we all do local work, don't have any common SSRS server,
Biz users just want to get access to our SSRS server to validate reports.
We're on the same domain network wise, no firewall (assume I can ping OK).
M
The protocol used to ping and SSRS use different ports. So I wouldn't rule out the firewall. (although being able to ping is already a good step)
What is the error when your colleague tries to connect?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:37 pm
Yes, Ruser able to follow my link and has error like standard missing permission:
User 'RUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
And I did all levels of access for Ruser in Report Manager, not sure if it's same lik UAC????
Trying to check what ports are used now:
http://technet.microsoft.com/en-us/library/bb934283.aspx
M
March 11, 2014 at 5:22 pm
mario17 (3/11/2014)
Yes, Ruser able to follow my link and has error like standard missing permission:
User 'RUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.And I did all levels of access for Ruser in Report Manager, not sure if it's same lik UAC????
Trying to check what ports are used now:
http://technet.microsoft.com/en-us/library/bb934283.aspx
M
Check Port 80.
--
SQLBuddy
March 11, 2014 at 11:01 pm
Thanks to all.
IT works now,
I made a lot of changes.
1. FW alllow for specific range
2. TCP port 80 FW allow
3. Added user to Report Manager
4. Added user to my SQL Server user, as had problem with shared data source
5. Added user to site security
Mario
March 12, 2014 at 3:09 am
mario17 (3/11/2014)
Thanks to all.IT works now,
I made a lot of changes.
1. FW alllow for specific range
2. TCP port 80 FW allow
3. Added user to Report Manager
4. Added user to my SQL Server user, as had problem with shared data source
5. Added user to site security
Mario
Good to know it finally works.
Thanks for posting back the solution.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2014 at 8:21 am
Nice to know that 🙂
--
SQLBuddy
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply