Avatar of CUBSIT01
CUBSIT01
 asked on

SharePoint and Active Directory Sync Issues

In our environment we have a SharePoint server (SharePoint 2007) that synchronizes with the Active Directory (Windows Server 2003) nightly. Unfortunately, while attempting to set up alerts for one user (and strangely this sole user), we ran into a bit of a problem by way of email addresses. This user’s email is correct in the Active Directory, but incorrect in SharePoint. Stranger still is that it is only incorrect in the alerts section; in all other information listings it is correct.

We have tried updating the Active Directory profile with the correct email several times, manually editing SharePoint (which has yielded no results and has proven ridiculously difficult), and forcing SharePoint to manually synchronize with the Active Directory, all to no avail.

Both of these servers are completely updated and neither alone have problems. Any ideas (short of deleting this user’s profile completely and recreating it) as to why this is happening and how to fix it?
Windows Server 2003Microsoft SharePointActive Directory

Avatar of undefined
Last Comment
CUBSIT01

8/22/2022 - Mon
Raphilass

have you looked into the shared services part of the admin website....this is where syncronisation of profiles is managed.

Shared Services Administration: SharedServices > User Profile and Properties  . maybe a simple refresh would work here, i haven't really had much to do with this part of sharepoint,  but this is where i would start.

I think you can also configure which profile fields are mapped to what in here etc...
CUBSIT01

ASKER
Unfortunately, this is one of the first things tried and it doesn't solve the issue. In the AD it's correct, which means in the field is being randomly populated by some piece of incorrect data, but we can;t for the life of us determine where this is being kept.
Zaheer Iqbal

Is there any email address set in the code?
Check the the users exchange settings in exchange does he have more than one email address?

The incorrect email address where do you think it has come from, a Migration for example.
Your help has saved me hundreds of hours of internet surfing.
fblack61
CUBSIT01

ASKER
Let me be more clear: When this user's account was originally synchronized to the SharePoint Server from the AD, the incorrect email was listed in the user profile. It has since been corrected, and updated multiple times, however, this one field refuses to update.

On our domain we do not have an exchange server, so this isn't the problem.
Zaheer Iqbal

Ok does sharepoint use SQL or a DB?

The updated manually in there?
CUBSIT01

ASKER
I'm sorry, I don't quite understand your question, but it is a local instance of SQL, not a central server.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Zaheer Iqbal

you should be able to use SQL Studio to open the database tables then edit the email within the database for this .

Is sharepoint service packs fully up to date ?

Have a look at this..

http://sharepointinsight.wordpress.com/2009/05/25/
ASKER CERTIFIED SOLUTION
Zaheer Iqbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Leo_Skybird

Just for your information. Have you tried SharePoint AD Sync?
CUBSIT01

ASKER
Unfortunately, none of the suggestions have worked...even diving into the SQL and finding the correct tables and updating them did nothing. It seems that there is a part of SharePoint that simply refuses to update.

The way we get to this seemingly unupdatable table is as follows. From the user's "My Site," (where the email is correctly displayed) there is a tab labeled "View Tech Support User Info". This tab brings you to a page that is simply called "User information: [user's name] - [network\user name]". This is the only place in the entire Portal I can find that holds this faulty field, and for the life of me I cannot figure out how to change this. The few other fields that are populated on this page are correctly done so.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Raphilass

whats the URL of the page that holds the dodgy address ?
CUBSIT01

ASKER
SOLUTION
Raphilass

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
CUBSIT01

ASKER
Yes, but that doesn't give access to all the fields...only if the user is currently in or out. And if you remove the force=1 from the URL it simply redirects you to the user's "My Site"...weird stuff.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Raphilass

you dont get email ? if you go into site settings on the peaople.aspx page where you navigated from does the field you want to change appear in there ?
CUBSIT01

ASKER
Nope. That's why this is so perplexing. From what I can tell that field is nearly uneditable...which makes no sense...

Somehow it's linked to an incorrect part of the AD that doesn't exist...or just refuses to update or let anyone edit this one field.
Raphilass

ok bear with me, this is MOSS not WSS3.0 isn't it.  I aint got access to a MOSS server here at home,  

My thoughts are that the list is configured to not display the field in anything other than view mode. If thats the case then it may be possible to make the change using a package called SharePoint Manager 2007.

This wicked little tool allows access to all sorts of properties.  If you download it you can access every object in your site collection as well as their properties.

Just taking alook on my text server WSS3,  i can drill down through into my site collection -> rootsite --> users to my admin user (only one in there) and into the properties whare i can change the email.

Give it a go and let  me know how you get on,  i will take a look tomorrow on my moss server when i get to work.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Raphilass

also,  although i would not advocate messing with the backend database,  have you checked out the userInfo table for the content database on that site, and for the admin content database in case its pulling fromt here for some reason.
Raphilass

sorry if i am going over old ground but did you try stsadm -o sync yet ? I managed to replicate your issue and it worked on mine
CUBSIT01

ASKER
Sorry about the delay in response time; things have been rather hectic here over the last week. I still have no had a chance to try your last suggestion, though editing the backend didn't work either. I'll let you know when I've tried the sync...read: in the next few days or so.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Raphilass

Yeh i trawled the back end on our server and couldn't sort it. took me about 3 hours to go through them all :)
CUBSIT01

ASKER
It's definitely not an easy task.

So now we have a bit of a dilemma...after patches were applied and the machine rebooted (probably should have been doing that after all attempts, eh?), the user is now receiving alerts. Unfortunately, we have no way of knowing which person helped us...due to the fact that all results seemed unsuccessful shortly after implementation.

So now the question is: how do we award points to those who helped? Split it evenly...or? Any ideas?
Raphilass

Split em :) Fairest way if you're not sure
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
CUBSIT01

ASKER
Alrighty. Awarded. Thank you for all the help.