Thursday, April 24, 2008

SharePoint Error: Access web datasheet is attempting to retrieve data from a different domain.

A user reported this error today on a custom list built using the Datasheet view. We both could open the view, but as soon as any changes were made, the error would popup:

Access web datasheet is attempting to retrieve data from a different domain...

I had recently moved the site collection from a server (let's call it Terrance) to a new server (let's call it Phillip). I have to assume that when the datasheet view was trying to save changes, it was posting to http://terrance... instead of http://phillip...

I did some searching and found the answer: Alternate Access Mappings. You'll find this in SharePoint Central Administration, under Operations, and Global Configuration.

I needed to add a new Internal URL for http://terrance for the default zone, which has a public URL of http://phillip

According to Microsoft's documentation, when someone visits the site using the internal URL, the the public URL for the zone will be returned to the browser. So, visiting http://terrance/default.aspx, returns http://phillip/default.aspx in the address bar of the browser and the page that exists there.

Adding this Alternate Access Mapping immediately solved the problem the datasheet view was having.

8 comments:

Martin said...

Thank you a lot for this article. I will go one hour earlier at home today!

Michael

Carlos said...

Thanks Ken, Ihad a similar problem with same solution. I created the site with the ip address and users connected with the computer name.

Mahdyar said...

Thank you so much Ken, it was really usefullllll ;)

Mahdyar said...

Thank you so much Ken! It was really usefulllllllll

Leif said...

Wow this fixed my error exactly. Had a user accessing from outside the network on a public computer and the internalservername.domain.com needed to be added to the Alt Access Mappings.

Your post saved me a lot of headache!

Thanks again!

elMariachi said...

Thanks! It solved a lot of problems :)

AshwiniBhat said...

Thanks Ken for this post .It solved the issue.:)

Laurence said...

even works in 2012 on 2010!