.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Support for using email addresses as User Ids in AD, and being compatible with BI tools, such as SSR

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server

So we have an AD instance integrated with our BI environment. We have a requirement for external BI users to be allowed to use an email address as their user ID in AD. I understand that email addresses are suported in AD, but does the BI tool SharePoint 2007, SSRS and SSAS 2008 support user ID that arn't pre-windows 2000 user ids.

Our testing would indicate that email addresses are failing to be provisioned in SharePOint 2007 and SSAS 2008. Is this a configuration issue or really a limitation of the BI suite.

Your help is greatly appreciated.


View Complete Post

More Related Resource Links

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




Fetching the Currently Logged in user Email


Hey Frnds,

I am using the System.DirectoryServices.UserPrincipal.Current.EmailAddress to fetch the Currently logged in users email from AD.

If  debug my sol am getting the Exact mail id of that Particular user for ex:john@in.domain.com.

If i host My Application on iis

And Access my App am getting some other Email id instead of the john@in.domain.com.

I have changed the Application Pool identity to NetWorkService.

Can any one tell what could be wrong




Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio


We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008

Send an Email with User fields data entered in the form


Hi All,

          I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.


[Sharepoint 2007] How can i change the email of a sharepoint user ?

Hi all,

I have created a new sharepoint user.

1. First of all i have added a new user in active directory. However at that time i forgot to give an email address. Big mistake !

I cannot send mail from sharepoint workflow with the new user.

2. Therefore I updated the email addresd in active directory afterwards. But the change was not reflected in sharepoint.

I updated the mail in sharepoint adminsitrative user profile. But it did not make no difference in the user moss profile.

I followed the article in http://sharepointnotes.wordpress.com/2008/05/05/syncing-wss-and-moss-user-profile-properties-with-active-directory/

I did the following commands :

1. stsadm -o sync
2. stsadm -o sync -synctiming m:2
3. stsadm -o sync -deleteolddatabases 6
 stsadm -o sync

None of these commands updated the user properties mail for my new MOSS User.

I also rebooted the machine but my MOSS user email was not updated.

Also I used the tool at http://userprofilesync.codeplex.com/releases/view/13227
like the following :

tool>UserProfileSync.exe -url http://mysite -ssp http://mysite:37239/ssp/admin
I did not make any difference

What else can I try in order to update the email of my MOSS user ?

Need Form Application to allow user to review spreadsheets and email

I need an application to allow a user to see a list of documents/spreadsheets in a directory, click a link to the file, have it open, then review it, close it, then from the form choose to accept or deny it, then have it emailed to a recipient contained in a db or list any good ideas how to accomplish this?  maybe a windows form?    

Search References multi-platform support is forward-compatible

Remember when I introduced you to the Search References extension? I know my fellow coworkers at Clarius are awesome and all, but I was happily surprised when after installing MonoDroid, the following just worked: See the "Filtered to: MonoDroid Profile"? See how the paths point to the right assemblies under MonoDroid reference assemblies? Kudos to the http://go-mono.com/monodroid/ team for integrating so nicely in the VS2010 environment! Read full article

Task assignment to user without read access in 2007 results in no email to assignee, no warning to a

It appears (from observation and searching) that SP 2007 will not send a task assignment email when the assignee does not have read access for the assigned task and there is no warning when assigning a task to someone who will be unable to read it. I have not been able to find any mentions of attempting to address this quirk by either an item event listener or a workflow that would either prevent the assignment or task the originating user to fix the issue by either changing the assignment or having them added to the appropriate group.  I could see one done badly causing a cascade of tasks. The approaches that I've thought about are: Attempt to block assignment by hooking ItemAdding and ItemUpdating on the task content type.  In ItemUpdating, you could use SPListItem.DoesUserHavePermissions since the SPListItem should be there, but you'd may have check the list since I don't think SPListItem is available at that time.  I could see this causing problems when the assignment is via workflow or something that doesn't like other code interfering with its task creation. Hooking ItemAdded and ItemUpdated to assign a new task to the assigning user to either change the assignment or have the assignee added to the users with access to the site. Define a workflow which could be enabled for a list that would check if any new or modified task is assigned to users with

Is it possible to display the friendly name or email address of LiveID User Using Claims Authenticat

We have finally gotten LiveID authentication to work.  However when we specify a user to add to a sharepoint group, we need to do it via the unique id that live uses.   The user does login using their usual email address and password, but on the sharepoint side they see the PUID@live.com as the logged in user, and when we want to specify the user to have access to the a particular site or library, we have to do it by the same PUID@live.com.  This display makes it difficult to manager users on the sharepoint side.   Is there something I missed on setting up of the authentication provider, or is there something I can do to get sharepoint to retrieve the other information so that we can view the user through the email or full name that live provides?   Steve Paplanus

Query Active Directory for accounts missing email addresses

How I can query Active Directory for accounts missing email address.  What is the syntax for this from a .Net application.  Does anyone have sample code for doing this?  I am also looking to query AD for GetCustomersWithInvalidEmailAddresses. Thanks so much.... 

incoming email - multiple email addresses

is it possible to have more than 1 email address specified as the incoming email address for a library?

SharePoint 2010 email enabled list with workflow has incorrect User ID when items are emailed to the

I have set up an approval workflow for a document library that has email enabled. Emails come into the document library fine, however, if an item is emailed to the library the workflow kicks off with the initiator as "System Account" rather than the person who submitted the email. This makes the error of "The e-mail message cannot be sent. Make sure the e-mail has a valid recipient." come up. If someone submits a document directly to the library (by logging into sharepoint and submitting) everything works fine. The person submitting by email is a valid sharepoint user and the profile shows the correct email address. The Created by and Modified by fields show the correct person (rather than System Account), it's only the workflow User ID that shows incorrectly if document is emailed to library. Any help or ideas would be appreciated. Thanks

How to get Email of Current User Data View Web Part Sharepoint 2010 and pass to WebService data sour

I have to pass in the email address of the current user to a web service data source (run time) of a Data View Web Part.

My Question is:

a) How can I get Email address of current user based  in DVWP.
I know we can get the CurrentUser using the CurrentUserName but how do we get the Email for the Current User.

b) After getting the Email how do we pass to the Web Service.

Deactivating a user roles automatically when email activation is clicked


 Hi I know this is a simple fix but here's my register.aspx.vb and activation.aspx.vb codes. Its given an ordinary user unauthorized permissions after activation from email link which when clicked, approves and logs them in.


Protected Sub RegisterUser_CreatedUser(ByVal sender As Object, ByVal e As EventArgs) Handles RegisterUser.CreatedUser


    If _group IsNot Nothing Then

      Dim mp As ******WebMembershipProvider = CType(Membership.Provider, ******WebMembershipProvider)

      Dim user As MembershipUser = Membership.GetUser(RegisterUser.UserName)

      mp.AssociateUserWithGroup(user, _group)


      Dim cuw As CreateUserWizard = DirectCast(sender, CreateUserWizard)

      Dim userId As Guid = DirectCast(user.ProviderUserKey, Guid)

      Dim EmailMsg As New System.Net.Mail.MailMessage("inquiry@*******.com", RegisterUser.Email)

      EmailMsg.Subject = "Email Verification from ******.com"

      EmailMsg.IsBodyHtml = True

      EmailMsg.Body = "T

Retrieve user email address from text box


I have an Technical Service Request InfoPath form and an email alert needs to be sent to two users each time that the form is completed and submitted to a library. An email alert needs to be sent to our technical manager which is a relatively easy workflow to set up in SharePoint Designer. The other user which needs to be alerted is the engineer which could be one of six people (we only have one technical manager).

The person completing the form will have to enter the name of the engineer to whom the alert should be sent to. I am struggling to send an email to this user. Is there a way to associate an email address with the name which is entered? We could use drop down lists and need to automate this in some way.

We dont need to retrieve full user information from AD but just need the email address of the user whose name is captured in a Text Box named 'Engineer'.

Any suggestions or assistance would be greatly appreciated,

Many Thanks

SPD workflow doesn't send email to user in list when automatically started

Hi all,

My first post here and I hope someone out there could kindly help. I recently found out a strange issue with my SPD workflow. Basically, it couldn't send out email if (1) the recipient resides in the list and (2) the workflow is automatically started.

For example, I have a list with a "user" field. A workflow first "Send an email" to this user, and then "Collect data from a user" from this user. If the workflow is set to start automatically, then this user gets no email. Tasks list does contain a task, but the "Assigned To" field of the task is empty. This is the case no matter if the user field is of type "Single line of text" or "Person or Group".

Everything's fine if I manually start the workflow. And everything's fine if the user is directly spelled out (jay@company.com) in the "Send an email" and "Collect data from a user" actions instead of retrieved from the list. Either case the user would get two emails as expected, and the "Assigned To" field would display the user name properly.

I looked into the log but didn't find anything special. As you can imagine, this is breaking a lot of our workflows and making SPD workflow look very bad. It's just not
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend