Hello
I'm running MOSS2007 with SQL 2005 SP2 and trying to install the Reporting Services add-on. It goes through the install and stays at the removing backup files screen for a while. It then says installation failed. Event viewer is showing the following message:
"Insufficient SQL database permissions for user 'SYSTEM' in database xxxxx. Additional information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_GetListFields', database xxxx."
I'm using a separate SQL Server box. I have tried giving the SYSTEM account on the SQL box full rights. But the problem still exists.
I don't know why it would be trying to talk to the SQL Server using the SYSTEM account. I'm logged into the app server with the server farm account. If it used the Server Farm account all I imagine would be ok.
HELP!!!
I'm running MOSS2007 with SQL 2005 SP2 and trying to install the Reporting Services add-on. It goes through the install and stays at the removing backup files screen for a while. It then says installation failed. Event viewer is showing the following message:
"Insufficient SQL database permissions for user 'SYSTEM' in database xxxxx. Additional information from SQL Server is included below.
The EXECUTE permission was denied on the object 'proc_GetListFields', database xxxx."
I'm using a separate SQL Server box. I have tried giving the SYSTEM account on the SQL box full rights. But the problem still exists.
I don't know why it would be trying to talk to the SQL Server using the SYSTEM account. I'm logged into the app server with the server farm account. If it used the Server Farm account all I imagine would be ok.
HELP!!!