Datasheet View is asking credentials by edition trying (Network Steve Forum)

Datasheet View is asking credentials by edition trying

Hi,

I have problem with edition Sharepoint list in "Datasheet View" mode.
I have 2 accounts. The User with first account can edit list in "Datasheet View" mode and the second user cannot edit list in the same mode.
The Sharepoint is recurring authentication prompt when I try editing list in "Datasheet View" mode with the second account.
The rights on the Sharepoint side are enough.

Please help.

This link has not helped.

February 12th, 2015 4:06pm

Do both the accounts have exactly same right or are they different. If they are different then try giving account 2 similar access as 1 and try again to see if that resolves it.

Free Windows Admin Tool Kit Click here and download it now

February 12th, 2015 6:23pm

Does second account have a good user profile on the machine? (if you look in c:\users, do you see a fairly current date and time for this user account, or is it getting a TEMP profile loaded)

February 13th, 2015 3:47am

Yes, both accounts have the same rights.

Free Windows Admin Tool Kit Click here and download it now

February 13th, 2015 9:06am

Yes, the local profile is in good state

February 13th, 2015 9:07am

I investigated this problem and found a few moments.

ULS logs:

02/12/2015 16:13:12.39 w3wp.exe (0x3AD0) 0x3D20 SharePoint Foundation General avfx High SOAP exception: System.Runtime.InteropServices.COMException (0x82000006): The page you selected contains a list that does not exist. It may have been deleted by another user. at Microsoft.SharePoint.SoapServer.SPBaseImpl.GetSPListByTitle(SPWeb spWeb, String strListName) at Microsoft.SharePoint.SoapServer.SPBaseImpl.GetSPList(SPWeb spWeb, String strListName, Boolean bGetMetaData, Boolean bGetSecurityData) at Microsoft.SharePoint.SoapServer.SPBaseImpl.GetSPList(String strListName, Boolean bGetMetaData, Boolean bGetSecurityData) at Microsoft.SharePoint.SoapServer.ItemsCache.get_List() at Microsoft.SharePoint.SoapServer.ListDataImpl.ExecuteQuery(Boolean bUseDefaultViewQueryWhenEmpty, String strRootFolder, String strListName, String st... 57c70322-b2d5-4a20-85a9-3d312d6ec347

Fiddler:

Request:
POST http://sharepoint.domain.lan/sites/subsite/_vti_bin/lists.asmx HTTP/1.1
Content-Type: text/xml; charset=utf-8
SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListItems
X-Office-Version: 12.0.6683
User-Agent: Microsoft Office/12.0 (Windows NT 6.3; Access Web Datasheet 12.0.6683; Pro)
Host: sharepoint.domain.lan
Content-Length: 681
DNT: 1
Connection: Keep-Alive
Pragma: no-cache
Cookie: 7e4935ce43fa42e6bc864b05073702e7DOMAIN%5Co%2Edavydov=0; WSS_KeepSessionAuthenticated={cc1dc499-59bf-467c-8ed8-0f88589659b7}; previousLoggedInAs=; loginAsDifferentAttemptCount=; databaseBtnText=0; databaseBtnDesc=0; Ribbon.List=1276828|7|127|-486169691; OfflineClientInstalled=1
Authorization: Negotiate

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body> <GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/"> <listName>{52b5d00e-d42a-43b8-93a6-67fc17c7a67c}</listName><query><Query><OrderBy><FieldRef Name="Title"/></OrderBy></Query></query><viewFields><ViewFields><FieldRef Name="ID"/><FieldRef Name="Title"/></ViewFields></viewFields><rowLimit>10000</rowLimit><queryOptions><QueryOptions><ViewAttributes Scope="RecursiveAll"/></QueryOptions></queryOptions></GetListItems> </soap:Body></soap:Envelope>

Answer:
HTTP/1.1 401 Unauthorized
Cache-Control: private, max-age=0
Server: Microsoft-IIS/7.5
SPRequestGuid: 57c70322-b2d5-4a20-85a9-3d312d6ec347
X-SharePointHealthScore: 0
X-AspNet-Version: 2.0.50727
WWW-Authenticate: Negotiate
WWW-Authenticate: NTLM
X-Powered-By: ASP.NET
MicrosoftSharePointTeamServices: 14.0.0.6123
X-MS-InvokeApp: 1; RequireReadOnly
Date: Thu, 12 Feb 2015 14:13:11 GMT
Content-Length: 16
Proxy-Support: Session-Based-Authentication

401 UNAUTHORIZED

IIS logs:

2015-02-13 11:27:30 10.10.131.70 POST /_vti_bin/lists.asmx - 80 DOMAIN\o.davydov1 10.10.129.6 Microsoft+Office/12.0+(Windows+NT+6.3;+Access+Web+Datasheet+12.0.6683;+Pro) 401 0 0 140

Edited by Oleg Davidoff 21 hours 50 minutes ago

Free Windows Admin Tool Kit Click here and download it now

February 13th, 2015 9:14am

As per my previous experience this error pops up even for access denied if the user does not have access to the list but in your scenario the user can see the normal views.

Can you check a scenario where the user has Full Control on the list.

February 13th, 2015 9:38am

User have full access to this list

Free Windows Admin Tool Kit Click here and download it now

February 13th, 2015 1:15pm

I investigated this problem and found a few moments.

ULS logs:

Fiddler:

IIS logs:

2015-02-13 11:27:30 10.10.131.70 POST /_vti_bin/lists.asmx - 80 DOMAIN\o.davydov1 10.10.129.6 Microsoft+Office/12.0+(Windows+NT+6.3;+Access+Web+Datasheet+12.0.6683;+Pro) 401 0 0 140

Edited by Oleg Davidoff Friday, February 13, 2015 2:13 PM

February 13th, 2015 5:09pm

Any body home?

Edited by Oleg Davidoff 3 hours 47 minutes ago

Free Windows Admin Tool Kit Click here and download it now

February 17th, 2015 3:17am

This topic is archived. No further replies will be accepted.