Active Directory and SSRS

Is it possible to create a report in SSRS that queries Active Directory data such as user's phone extension, email address etc

What would be a good way to do this?

Thanks,

Nisha

I haven't done this but probably the easiest way will be to use the OLE DB Provider for Microsoft Directory Services. When setting up the data source, choose the OLE DB option and then click the Edit button which will bring you to all OLE DB providers installed.|||

Thank You so much for pointing me in the right direction. I was able to do what I needed.

NB

Accessing shares over internet

I have a remote client accessing a SQL database via an internet connection to
a public IP address on our SQL server. THe program needs to access a shared
folder for printing reports in the program, but the client does not recognize
the UNC path to the folder because they are not on the network. How can I
get around this? LMHOSTS?
TIA,
S. Thompson
Hi
\\ipaddress\sharename does work over the internet, as long as the correct
ports are opened to allow Kerberos or NT Challenge/Response authentication.
If you do, you are asking to get hacked. I would not recommend doing this.
Is there not another printing solution you can use?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
news:24306B87-DD2D-4E0F-9C46-4CD8D7C9C999@.microsoft.com...
>I have a remote client accessing a SQL database via an internet connection
>to
> a public IP address on our SQL server. THe program needs to access a
> shared
> folder for printing reports in the program, but the client does not
> recognize
> the UNC path to the folder because they are not on the network. How can I
> get around this? LMHOSTS?
> TIA,
> S. Thompson
|||No, there doesnt seem to be another solution. Would I use an LMHOST entry
for that?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> \\ipaddress\sharename does work over the internet, as long as the correct
> ports are opened to allow Kerberos or NT Challenge/Response authentication.
> If you do, you are asking to get hacked. I would not recommend doing this.
> Is there not another printing solution you can use?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "scottdog129" <scottdog129@.discussions.microsoft.com> wrote in message
> news:24306B87-DD2D-4E0F-9C46-4CD8D7C9C999@.microsoft.com...
>
>