I need custom security context - is it possible? -- sql server reporting services

sql server reporting services : I need custom security context - is it possible?

Tomasz Jastrzebski
5/19/2006 6:43:29 PM

Hello,

My SSRS report needs to query exchange servers, via http based WebDAV
protocol, to get users mailbox summary data.
Technically it can be done but the problem is security. The WebDAV query
needs to be issued using security context other than the context used by
SSRS service or the current user. That means that this other security
credentials have to securely stored and accessible to the SSRS service and
my custom report code during report rendering.
Practically speaking I need a reference to some object implementing
System.Net.ICredentials.

Can it be done?

Yes, I know it is not the most standard way of using SSRS, I am aware of the
potential performance problems.

Thank you,

Tomasz

weilu NO[at]SPAM online.microsoft.com
5/22/2006 5:29:55 AM

Hi Tomasz,

Thank you for your post.

From your description, my understanding of this issue is: You want to pass
a credential to use the WebDAV during the report rendering. If I
misunderstood your concern, please feel free to let me know.

I would like to know what's the data source you use. If you use your custom
data provider, I think you could use a specify user and password to connect
to the Exchange using the WebDav. The credential could be stored in a
configure file or in the database and you could encrypt the password by
yourself.

Would you provide some detail informatin about how you use the WebDav ?
This will be helpful for me to troubleshoot this issue and provide some
additional suggestion.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Tomasz Jastrzebski
5/22/2006 9:14:22 AM

Hi Wei,

I do not use any data source to do that. Just functions in my custom report
code.
Since WebDAV is http protocol I simply call
System.Net.HttpWebRequest.GetResponse(), previously setting
HttpWebRequest.Credentials.

Tomasz

[quoted text, click to view]

weilu NO[at]SPAM online.microsoft.com
5/23/2006 12:00:00 AM

Hi Tomasz,

Thank you for the update.

Since you are using your custom code, it's easy to use your custom
Credential.

Basically, we set the HttpWebRequest.Credentials as
CredentialCache.DefaultCredentials. You could use the Add method of the
CredentialCache to add a credential for particular hosts and authentication
types.

Here is the sample:

CredentialCache myCache = new CredentialCache();

myCache.Add(new Uri("http://www.contoso.com/"),"Basic",new
NetworkCredential(UserName,SecurelyStoredPassword));

Here is some article for your reference:

CredentialCache Class
http://msdn2.microsoft.com/en-us/library/615e0wsd(vs.80).aspx

Authentication in web services with HttpWebRequest
http://blogs.msdn.com/buckh/archive/2004/07/28/199706.aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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 about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn