tags:

views:

854

answers:

1
Q: 

How do I get the full name of the current user from a SQL Reporting Services 2008 report?

I know that the name of the user account can be retrieved from the built in variable User!UserID but how can I get the full user name of the user?

I guess it would be possible to hook up some .NET code and do a Active Directory look up but are there any alternatives?

+2  A: 

In one of my projects I used a table in SQL Server to store the user data from Active Directory ("displayName", "sAMAccountName", "userPrincipalName"), using a C# application for data transfer. The table was updated nightly and also after any change in Active Directory which could impact my project users.

In my case (Infopath form hosted on Sharepoint) I was using an web service to get the account name of the current user from Sharepoint, in order to display the coresponding user full name.

alexandrul  2008-09-25 09:30:36
That would work but I'm looking for other solutions as well. Maybe it is possible to set up an Active Directory data source. Will have to look into that.
Manga Lee  2008-09-25 22:24:13
You could try to set an web service to return the desired data for the specified account, but I could not find an easy way to call the web service from SQL Server. And I did not find out how to set the Active Directory as a linked server, so I just used a table as a cache for the user information.
alexandrul  2008-09-26 05:56:40

related questions

Querying Active Directory with "SQL"?
Can I get more than 1000 records from a DirectorySearcher in Asp.Net?
How to get AD User Groups for user in Asp.Net?
Attempting to update a user's "connect to:" home directory path in AD using C#
Monitoring group membership in Active Directory more efficiently (C# .NET)
How do I speed up data retrieval from .NET AD within ColdFusion
How do you authenticate against an Active Directory server using Spring Security?
Managing large user databases for single-signon.
Move Active Directory Group to Another OU using Powershell
How to move SharePoint sites from one active directory domain to another?
When did I last talk to my Domain Server?
Using ActiveDirectoryMembershipProvider with two domain controllers
I am having trouble getting phpBB to authenticate with our Active Directory
How do I use ADAM to run unit tests?
COMException "Library not registered." while using System.DirectoryServices
Caching Active Directory Data
Windows / Active Directory - User / Groups
Get a list of available domains (NT4 and Active Directory)
How do I use NTLM authentication with Active Directory
I/O permission settings using .net installer
quoting System.DirectoryServices.ResultPropertyCollection
How do you impersonate an Active Directory user in Powershell?
Setting Group Type for new Active Directory Entry in VB.NET
Is there a way for MS Access to grab the current Active Directory user?
Checklist for IIS 6/ASP.NET Windows Authentication?