Hi all,
Quick Question-
Is it possible to have two websites on the same report server for reporting
services?
Example: I have one website, lets say for internal reports (employee time,
job info etc.) and another one for customer info (how a customer product is
coming along, how many product support cases we have out there).
http://cmbsssmsrs/personaltime/reports and http://cmbsssmsrs/vantive/reports
I hope someone can help or point me in the right direction.
Thanks in advanced,
Kerrie
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1I installed a named instance of SQL 2005 with reporting services and it
installed a second reporting services virtual directory on my server... I
suspect that it can be done, but do not know if it is supported... remember
that reporting services is just a dot net app. You probably have to have a
different pair of DBs to support it..
Can you possibly use different directories on a single instance, with
different permissions?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:52B1C7ACAA5B4@.SQLMonster.com...
> Hi all,
> Quick Question-
> Is it possible to have two websites on the same report server for
> reporting
> services?
> Example: I have one website, lets say for internal reports (employee time,
> job info etc.) and another one for customer info (how a customer product
> is
> coming along, how many product support cases we have out there).
> http://cmbsssmsrs/personaltime/reports and
> http://cmbsssmsrs/vantive/reports
> I hope someone can help or point me in the right direction.
> Thanks in advanced,
> Kerrie
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1
Showing posts with label websites. Show all posts
Showing posts with label websites. Show all posts
Wednesday, March 28, 2012
Monday, March 12, 2012
Report Servicing
Hi everyone. Can any one help me with report servicing? I need to know the in and out of
report servicing. Any suggesting websites? , blogs? tutors anything will be very help ful.
Hi,
you can take a look at this article:http://www.ftponline.com/vsm/2006_03/magazine/features/rjennings/default_pf.aspx
Grz, Kris.
Monday, February 20, 2012
Report Security: CAnt view report
Hi,
We have some websites. We want to attch a link on each wrbsite which would
take the users to a different reports. Please suggest what will be the best
security mechansism for this scenario..
Also, I was trying to implement the simplest security mechansim,i.e I craetd
a user called User1 and created a Group called Group1. I added the User1 to
be a member of Group1. Now from Reports Manager, I assigned the Browser role
to the Group1. Also, in the virtual directory for Reports & Report Server, I
enabled Integrated Windows Authentication. Now, when I try to view the
report, I get a prompt for username & passowrd. So when I type User1 as
username & the password asscoated with the user, i cant view the report. I
get the error : The Page cant be dispalyed. Also when i click a the link
Reports.com because that is the domain we are using for our Reports.I
get...You are not authorized to viw the reports...
Plz help with this issue.
--
pmudHi,
I still need your suggestion about which security mechansim should be used
in our scenario but I figured out the second question of my previous post,
which is the basic sercuirty mechansim for a report. It was not displaying
the report coz for the user account in Local Users I had checked the check
box, "User should change password on next logon". When I cleared that check
boz and didnt check any of the check boxes, i was able to view the reports.
Any suggestion would be helpful about which security mechansim should be
used.
Thanks
"pmud" wrote:
> Hi,
> We have some websites. We want to attch a link on each wrbsite which would
> take the users to a different reports. Please suggest what will be the best
> security mechansism for this scenario..
> Also, I was trying to implement the simplest security mechansim,i.e I craetd
> a user called User1 and created a Group called Group1. I added the User1 to
> be a member of Group1. Now from Reports Manager, I assigned the Browser role
> to the Group1. Also, in the virtual directory for Reports & Report Server, I
> enabled Integrated Windows Authentication. Now, when I try to view the
> report, I get a prompt for username & passowrd. So when I type User1 as
> username & the password asscoated with the user, i cant view the report. I
> get the error : The Page cant be dispalyed. Also when i click a the link
> Reports.com because that is the domain we are using for our Reports.I
> get...You are not authorized to viw the reports...
> Plz help with this issue.
> --
> pmud
We have some websites. We want to attch a link on each wrbsite which would
take the users to a different reports. Please suggest what will be the best
security mechansism for this scenario..
Also, I was trying to implement the simplest security mechansim,i.e I craetd
a user called User1 and created a Group called Group1. I added the User1 to
be a member of Group1. Now from Reports Manager, I assigned the Browser role
to the Group1. Also, in the virtual directory for Reports & Report Server, I
enabled Integrated Windows Authentication. Now, when I try to view the
report, I get a prompt for username & passowrd. So when I type User1 as
username & the password asscoated with the user, i cant view the report. I
get the error : The Page cant be dispalyed. Also when i click a the link
Reports.com because that is the domain we are using for our Reports.I
get...You are not authorized to viw the reports...
Plz help with this issue.
--
pmudHi,
I still need your suggestion about which security mechansim should be used
in our scenario but I figured out the second question of my previous post,
which is the basic sercuirty mechansim for a report. It was not displaying
the report coz for the user account in Local Users I had checked the check
box, "User should change password on next logon". When I cleared that check
boz and didnt check any of the check boxes, i was able to view the reports.
Any suggestion would be helpful about which security mechansim should be
used.
Thanks
"pmud" wrote:
> Hi,
> We have some websites. We want to attch a link on each wrbsite which would
> take the users to a different reports. Please suggest what will be the best
> security mechansism for this scenario..
> Also, I was trying to implement the simplest security mechansim,i.e I craetd
> a user called User1 and created a Group called Group1. I added the User1 to
> be a member of Group1. Now from Reports Manager, I assigned the Browser role
> to the Group1. Also, in the virtual directory for Reports & Report Server, I
> enabled Integrated Windows Authentication. Now, when I try to view the
> report, I get a prompt for username & passowrd. So when I type User1 as
> username & the password asscoated with the user, i cant view the report. I
> get the error : The Page cant be dispalyed. Also when i click a the link
> Reports.com because that is the domain we are using for our Reports.I
> get...You are not authorized to viw the reports...
> Plz help with this issue.
> --
> pmud
Subscribe to:
Posts (Atom)