Monthly Archives: December 2014

Modifying maxAllowedContentLength

Issue:  “ http://dev-perfdb2/olap/msmdpump.dll” is thrown by an application due to default configuration in the IIS sever which throws an error when the content length of the data (the data which is passed from an application to DB is passed through … Continue reading

Posted in IIS, MSSQL | Leave a comment

Providing Permissions for Non-Admin users to use Activity Monitor

Windows 2012 and SQL 2012 To grant permission for Non-Admin users to use Activity Monitor on an SQL 2012 server, follow the below 1) Add [Domain\Username] to [Computer Management] –> [Performance Monitor Users] 2) Run the below script on SQL Instance … Continue reading

Posted in MSSQL, Permissions | Leave a comment