Pleases Keep in mind SSRS is not cluster aware. For Example time of Subscription Node1 failover to Node 2 then your subscription don't work. You need to failover Node 1...

You need to SSRS by http://<Servername>/reportservers

Select site setting and then select security and add user. make sure you don't add that user as SYS admin or left...

You can use View T-SQL option through wizard.

one for Backup and other one for Maintenance cleanup task - copy that script and run as Job .

How do you use Linked server by using windows account or remote user ?

You need to log on that server and checked it out is there Drive still there or not if not check you windows log.

In worst case if it is gone...

Try running job under 'sa' account .

FYI : If you use DENY then whoever are into that group lost SQL Server level access for that particular SQL Server even though they are in...

FYI : If you use DENY then whoever are into that group lost SQL Server level access for that particular SQL Server even though they are in...

Thank You For Repaly!!!!!

Thank You!!!

Thanks for Replay but now i am getting this Error

"Msg 205, Level 16, State 1, Procedure XXX#, Line 4

All queries combined using a UNION, INTERSECT or EXCEPT operator must have...

Thank You all for replying answer.

i have posted snapshot error i tried everything almost but it is not showing details of error.

if you any more suggestion by seeing this snapshot

That will great help to me.....

Thanks

Hello!!!

Thanks for Replying

but i am not sure

in top window where ? i am DBA and i Dont have sound knowledge about ssas ?

Thanks

Thanks for replaying for problem

but this what i am getting if press stop.

The connection was lost. Close all processing dialog boxes and try processing the object again. (Microsoft Visual...