User guest does not have permission to run DBCC showfilestats for database master

Nov 22, 2011 at 5:42 PM

OK, I don't know what I did but I've managed to screw up my EPM installation.  When I manually kick off the Agent job, the policy from Microsoft works but the custom free space check policy I created by following the steps from http://www.sqlservercentral.com/articles/PBM/68602/ fails with "User guest does not have permission to run DBCC showfilestats for database master".  Any suggestions on where to look?

Ken

Nov 22, 2011 at 6:36 PM

I changed the filter on the policy to examine just user databases and now the error is:

PACORP\svcsql_2008 does not have permission to run DBCC showfilestats for database ProjectServerDEV_Reporting

Nov 22, 2011 at 10:05 PM

Everything works when I run EPM_EnterpriseEvaluation_3.0.0.ps1 at the powershell prompt so I've got a problem with my security configuration.  Sorry for the spam.  Please feel free to disregard this thread. 

Coordinator
Dec 3, 2011 at 2:33 AM

If you opened the PowerShell prompt as adminstrator and ran the script locally then you're running with admin privileges. The DBCC showfilestats needs certain permissions on system databases. Also what version of SQL Server are you running? EPMFramework requires that you run it on at least SQL Server 2008 SP3 or higher. I've also done testing and EPMF works on 2008 R2 RTM and higher. If you're using non-R2, check this page out http://support.microsoft.com/kb/980037

Dec 5, 2011 at 5:29 PM

@@version shows: "Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 ...".  According to http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx, this means I'm running 2008 SP2 + Q2494089.  Since the fix mentioned in your link was included in SP1, it should not be a problem on my installation.

Coordinator
Dec 5, 2011 at 8:23 PM

Ah my mistake, EPMF only needs SP1 + CU3 (that's where I remembered 3 from) and higher and you're right, your edition should include said fixes. Which account is your SQL Agent account running as and which target server is giving you this error? Sounds like the account you're running agent as doesn't have proper permissions on target server to evaluate. Is the service account mapped properly to ProjectServerDEV_Reporting?