sql server reporting services: How to integrate with Visual.Net -- sql server reporting services

You're in the

sql server reporting services

group:

How to integrate with Visual.Net

Re: How to integrate with Visual.Net

Jéjé
9/5/2004 11:57:15 PM

sql server reporting services:

what do you want to do exactly?
do you talk about Visual Studio?
do you talk about data source connection user/password in a report?

"ad" <ad@wfes.tcc.edu.tw> a écrit dans le message de news:
e301sF8kEHA.748@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]

Re: How to integrate with Visual.Net

Jéjé
9/6/2004 9:26:29 AM

So I resume :
You want to create a custom ASP.NET application (?)
from your application, you want to open a report (?)
and to do this, you need a user name/password to access reporting services
(except if your Reporting services installation allow anonymous accesses)

Does it correct?

If yes, then the data source connection contain the user name and password
to access your database, or use the integrated security, so the login used
to open the report is used as the user name / password for the database.
(there is other cases, but generally 1 of this 2 cases is used)
So you don't need to store your database user name/password anywhere except
in the Reporting Services repository.

I hope this can help you

"ad" <ad@wfes.tcc.edu.tw> a écrit dans le message de news:
OxEsvY8kEHA.2588@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

How to integrate with Visual.Net

ad
9/6/2004 11:27:14 AM

I want to provide useid and passoword in Visual.net , and pass them to
Reporting service.
How can I integrate Visual.Net with Reporting service?

Re: How to integrate with Visual.Net

ad
9/6/2004 12:01:19 PM

I mean both data source connection user/password and reports' user/password
and domain,
I want those all integrate in Asp.Net

<Jéj? <willgart@BBBhotmailAAA.com>> ¼¶¼g©ó¶l¥ó·s»D
:#xoRYW8kEHA.2764@TK2MSFTNGP11.phx.gbl...
[quoted text, click to view]

Re: How to integrate with Visual.Net

Bruce Loehle-Conger
9/7/2004 9:25:36 AM

There are two different types of security with Reporting Services. You can
use integrated security and you can write your own security extension. My
advice is to only do roll your own security if integrated security won't
work for you (for instance this is an internet application and not an
intranet application).

I suggest just doing a simple test. First have RS running with integrated
security. Do a simple report. Then from your own web page you also use
integrated security (i.e. you just let IIS handle the security, no reason
for you to roll your own anywhere in this scenario). Have a link on the web
page that calls the RS report using URL integration. If all works as planned
it should know who the person is and you are on your way.

When integrating your web app with RS you can use either URL integration or
you can use web services.

Note, you need to be sure you understand the role based security that RS
uses.

Bruce L-C

[quoted text, click to view]

Re: How to integrate with Visual.Net

ad
9/7/2004 2:11:38 PM

Thank,
But the report also need authorize with domain's name / password.
Can I use a login web page to collect the id/password, and pass them to
reproting service?

<Jéj? <willgart@BBBhotmailAAA.com>> ¼¶¼g©ó¶l¥ó·s»D
:eLs1cUBlEHA.1644@tk2msftngp13.phx.gbl...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn