I had developed an ASP.NET application that runs SSIS packages, everything went well until i got the need to run a package that updates an Analysis Services Cube.
My package connection string to the cube looks like this:
"Data Source=<server>;Initial Catalog=<database>;Provider=MSOLAP.3;Integrated Security=SSPI;"
So my .net website has impersonation=true and my IIS denies anonymous and has integrated security also true.
I have packages that create files and those files are created correctly so permissions are passing just fine. The problem has arrived when i tried to process the cube. I got the following error:
"Either the user, NT AUTHORITY\NETWORK SERVICE, does not have access to the <database> database, or the database does not exist. "
So if i have Integrated Security in all places why does it uses Network Service