Having some difficulty with SSO from BO to PI. Anyone have experience that could help. Connecting through WEBI client from laptop works but when we publish we get an error.
Database error (CS) SSO failed in CMS internal error IES 10901
Looks like it was a 64/32 bit driver issue, we are connected now!
The error message appears to be a Login Failed message of sorts for SQL Server and not the Data Archive.
That being said, I would suggest checking the SQL Server message logs to see what the connecting user is when you try to publish and ensure that it has permissions. My initial thought is that perhaps when reading data through the " WEBI client", your personal credentials are passed through to SQL, but on publish it's the account running the SQL Server. Though, that's just a thought because again this SQL Server error rather than a PI error.
Retrieving data ...