|
|
You're in the
sql server reporting services
group:How does RS connect to AS?
sql server reporting services:
application, and I'm trying to understand how RS does it. When I create a datasource, it uses Windows Authentication to connect, but I'm not understanding how it can use my id from the RS web server. Is it using Kerberos security? (I'm thinking that is needed to to from my machine to the RS server and then to the AS server). I have a web app and I'm trying to connect using ADOMD, but the only way it's working for me right now is if I use impersonation, and I don't want to do that. Obviously RS cannot be doing this. TIA, Jim
RS uses impersonation.
[quoted text, click to view] <jhcorey@yahoo.com> wrote in message news:1150466195.532528.22380@y41g2000cwy.googlegroups.com... > I'm getting myself very confused trying to connect to AS2005 in my own > application, and I'm trying to understand how RS does it. > > When I create a datasource, it uses Windows Authentication to connect, > but I'm not understanding how it can use my id from the RS web server. > Is it using Kerberos security? > (I'm thinking that is needed to to from my machine to the RS server and > then to the AS server). > > I have a web app and I'm trying to connect using ADOMD, but the only > way it's working for me right now is if I use impersonation, and I > don't want to do that. Obviously RS cannot be doing this. > > TIA, > Jim >
Thanks Tim,
I'm still a bit confused. I've used impersonation to make a web site run as a single impersonated user, which would not be the case with RS. I seem to remember reading something about Kerberos giving you the facility to pass credentials to a second server (i.e. database). Is Kerberos being used? Would you know if this is something I could imitate in my web app? Jim [quoted text, click to view] Tim Dot NoSpam wrote:
> RS uses impersonation. > > <jhcorey@yahoo.com> wrote in message > news:1150466195.532528.22380@y41g2000cwy.googlegroups.com... > > I'm getting myself very confused trying to connect to AS2005 in my own > > application, and I'm trying to understand how RS does it. > > > > When I create a datasource, it uses Windows Authentication to connect, > > but I'm not understanding how it can use my id from the RS web server. > > Is it using Kerberos security? > > (I'm thinking that is needed to to from my machine to the RS server and > > then to the AS server). > > > > I have a web app and I'm trying to connect using ADOMD, but the only > > way it's working for me right now is if I use impersonation, and I > > don't want to do that. Obviously RS cannot be doing this. > > > > TIA, > > Jim > >
First question:
Is RS installed on the same box as Analysis Services? And are both your computer, RS and AS inside your domain? If it is, you can set the data source on your server to use Windows (NT) Integrated Security, and it will use your credentials to connect to AS. If they are on two different servers, you have a sligthly bigger problem on your hands... Kaisa M. Lindahl Lervik [quoted text, click to view] <jhcorey@yahoo.com> wrote in message news:1150466195.532528.22380@y41g2000cwy.googlegroups.com... > I'm getting myself very confused trying to connect to AS2005 in my own > application, and I'm trying to understand how RS does it. > > When I create a datasource, it uses Windows Authentication to connect, > but I'm not understanding how it can use my id from the RS web server. > Is it using Kerberos security? > (I'm thinking that is needed to to from my machine to the RS server and > then to the AS server). > > I have a web app and I'm trying to connect using ADOMD, but the only > way it's working for me right now is if I use impersonation, and I > don't want to do that. Obviously RS cannot be doing this. > > TIA, > Jim >
That's the conclusion I reached by experimenting -- RS and AS have to
be on the same box. Obviously I'd love to find out I'm wrong. [quoted text, click to view] Kaisa M. Lindahl Lervik wrote:
> First question: > Is RS installed on the same box as Analysis Services? And are both your > computer, RS and AS inside your domain? > If it is, you can set the data source on your server to use Windows (NT) > Integrated Security, and it will use your credentials to connect to AS. > > If they are on two different servers, you have a sligthly bigger problem on > your hands... > > Kaisa M. Lindahl Lervik > <jhcorey@yahoo.com> wrote in message > news:1150466195.532528.22380@y41g2000cwy.googlegroups.com... > > I'm getting myself very confused trying to connect to AS2005 in my own > > application, and I'm trying to understand how RS does it. > > > > When I create a datasource, it uses Windows Authentication to connect, > > but I'm not understanding how it can use my id from the RS web server. > > Is it using Kerberos security? > > (I'm thinking that is needed to to from my machine to the RS server and > > then to the AS server). > > > > I have a web app and I'm trying to connect using ADOMD, but the only > > way it's working for me right now is if I use impersonation, and I > > don't want to do that. Obviously RS cannot be doing this. > > > > TIA, > > Jim > >
Got it going, thanks to these instructions from MS. We have a dummy
user that we use in the scenario below. (We won't be able to set security by individual user in AS, but hopefully that will be ok. We can secure the report) 1. Publish your report & data source from VS 2. Use Report Manager to browse to the report, click Properties 3. Click Data Sources, Choose "Credentials Stored securely in the report server...." 4. Enter UID/PWD 5. Select "Use as Windows Credentials when connecting to the data source" checkbox 6. *Click Apply* 7. View report again, click Properties, go back to Data Source and make sure the changes you made have indeed been applied. [quoted text, click to view] jhcorey@yahoo.com wrote:
> That's the conclusion I reached by experimenting -- RS and AS have to > be on the same box. Obviously I'd love to find out I'm wrong. > > Kaisa M. Lindahl Lervik wrote: > > First question: > > Is RS installed on the same box as Analysis Services? And are both your > > computer, RS and AS inside your domain? > > If it is, you can set the data source on your server to use Windows (NT) > > Integrated Security, and it will use your credentials to connect to AS. > > > > If they are on two different servers, you have a sligthly bigger problem on > > your hands... > > > > Kaisa M. Lindahl Lervik > > <jhcorey@yahoo.com> wrote in message > > news:1150466195.532528.22380@y41g2000cwy.googlegroups.com... > > > I'm getting myself very confused trying to connect to AS2005 in my own > > > application, and I'm trying to understand how RS does it. > > > > > > When I create a datasource, it uses Windows Authentication to connect, > > > but I'm not understanding how it can use my id from the RS web server. > > > Is it using Kerberos security? > > > (I'm thinking that is needed to to from my machine to the RS server and > > > then to the AS server). > > > > > > I have a web app and I'm trying to connect using ADOMD, but the only > > > way it's working for me right now is if I use impersonation, and I > > > don't want to do that. Obviously RS cannot be doing this. > > > > > > TIA, > > > Jim > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |