SQL Server 2017 Tabular Data Model

%3CLINGO-SUB%20id%3D%22lingo-sub-190112%22%20slang%3D%22en-US%22%3ESQL%20Server%202017%20Tabular%20Data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190112%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20a%20tabular%20data%20model%20in%20Analysis%20Services.%20The%20model%20is%20set%20to%20update%20nightly%20from%20two%20SharePoint%20lists.%20I%20can't%20get%20the%20credentials%20to%20stick%2C%20so%20the%20nightly%20refresh%20fails.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20go%20in%20and%20set%20credentials%20in%20SSMS%2C%20I%20can%20process%20the%20model%20fine.%20I%20had%20another%20admin%20process%20the%20model%20and%20it%20worked%20fine.%20I%20can%20even%20trigger%20the%20scheduled%20job%20and%20that%20works%20fine%20as%20well--regardless%20of%20who%20runs%20the%20job.%20Why%20won't%20the%20credentials%20stick%20overnight%3F%20Has%20anyone%20seen%20this%3F%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I've created a tabular data model in Analysis Services. The model is set to update nightly from two SharePoint lists. I can't get the credentials to stick, so the nightly refresh fails.

 

When I go in and set credentials in SSMS, I can process the model fine. I had another admin process the model and it worked fine. I can even trigger the scheduled job and that works fine as well--regardless of who runs the job. Why won't the credentials stick overnight? Has anyone seen this? Any ideas?

0 Replies