I tried to use this tool but get following error:
Insufficient SQL database permissions for user 'ZZZ' in database 'XXX' on SQL Server instance 'YYY'. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_getObjectsByClass', database '..
Does this mean that spwakup access the DB directly to enum sites? As far as I know, accessing MOSS db directly would break Microsoft support.
Btw, I dont use farm admin account, regular service account with access to sharepoint, I can log on using this account to access all sites in IE but not via the tool. Please help and looking for your comments.