Browse by Tags

• Analysis Services
• backup
• databases
• permissions
• reporting
• Reporting Services
• reportserver
• reportservertempdb
• rsexecrole
• security
• sql server
• xmla

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
27 May 08 01:48 AM | SQL Master | 2 Comments   

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their Read More...

Filed under: sql server, databases, Reporting Services, security, sqlagent, permissions, reportserver, reportservertempdb, rsexecrole

Automation of Analysis Services database backup
26 September 07 03:19 AM | SQL Master | 2 Comments   

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, Read More...

Filed under: sql server, databases, reporting, Analysis Services, backup, security, sqlagent, xmla