SessionId=1.V22.59C8RC4/gkN0iuzPEkfmVl90.5.en-US5.en-US73.+0480#-01T02:00:00:0000#+0000#-02T02:00:00:0000#, WorkbookVersion=ConnectionInfo.WorkbookVersion:ĬonnectionManager.CreateConnection: Authentication failureĬonnectionManager.GetConnection: Failed to create new connection, exception=.: Exception of type '.' was Index=0, Credentials=ĬonnectionRequest.ConnectionRequest: New connection request. Is no evidence on the SQLServer box that any authentication attempt is made, and the same SSS application authenticates cleanly and provides access to fill an externla list.ĮxternalSource.GetExternalKeyAndStateAndMarkUsed: Populating the session's credentials for external data. These once again point to an authentication error, but there #HOW TO REFRESH DATA ON PIVOT TABLE IN EXCEL FOR MAC 2008 HOW TO#I don't know if this helps (as I see no one has any ideas how to help yet), but here are the actual ULS entries when I try to refresh (slightly redacted to remove accounts, passwords and hosts). So, any clues? I must be missing something either very simple or something in Excel Services is not acting as it should and the error messages themselves are erroneous. Lastly, I have tried this on two separate servers (farms), and the same happens on both. I followed this flow chart:Īnd it would lead you to think that the problem is that the SSS application provides credentials that don't have access to the data, but that has been disproven. I have read every blog entry, MS instruction page and forum I can find, and on clues. So, it seems that Excel Services is giving the error without even attempting to use the SSS credentials. I tried it all using a connection file instead of an embedded connaction, and same issue.I turned on a trace in SS Profiler and see attempt to connect when the SharePoint page webpart is attempting a refresh.I looked at the logs on the SQL Server machine and see no entry saying that the login failed. #HOW TO REFRESH DATA ON PIVOT TABLE IN EXCEL FOR MAC 2008 PASSWORD#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |