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:
Thank you a lot for this article. I will go one hour earlier at home today!
Michael
Thanks Ken, Ihad a similar problem with same solution. I created the site with the ip address and users connected with the computer name.
Thank you so much Ken, it was really usefullllll ;)
Thank you so much Ken! It was really usefulllllllll
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!
Thanks! It solved a lot of problems :)
Thanks Ken for this post .It solved the issue.:)
even works in 2012 on 2010!
Post a Comment