BobojoBaxter
New Member
- Messages
- 3
- Reaction score
- 0
- Points
- 1
We had an issue with another thing post console update, where we couldn't modify or even look at our cloud attach. We ran a sql command to update the user table I believe...
Now we have the issue where cmpivot has no results and the error in the smsprov.log is as follows:
The user that ran the command is an sccm admin. I do still see the smsdbuser_readonly and it has execute permissions on dbo, so not sure it is that...
If I check the database it looks like the pivot did actually run, I can see the results in sql.
Now we have the issue where cmpivot has no results and the error in the smsprov.log is as follows:
SQL:
*~*~[42000][229][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The SELECT permission was denied on the object 'CMPivotResult', database 'CM_MEM', schema 'dbo'. ThreadID : 18576 , DbError: 229 , Sev: 14~*~*
*** [HY010][0][Microsoft][ODBC Driver Manager] Function sequence error
*~*~[HY010][0][Microsoft][ODBC Driver Manager] Function sequence error [42000][229][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The SELECT permission was denied on the object 'CMPivotResult', database 'CM_MEM', schema 'dbo'.The user that ran the command is an sccm admin. I do still see the smsdbuser_readonly and it has execute permissions on dbo, so not sure it is that...
If I check the database it looks like the pivot did actually run, I can see the results in sql.
Last edited:
