This post is more than 5 years old
2 Intern
•
128 Posts
0
777
February 15th, 2011 14:00
SQL2005 Module and Microsoft Analisys and Reporting Services
Hi,
Someone has experience about the integration of these two SQL Services to an SQL2005 Resource Group? I know that this configuration is not supported by EMC, but our customer needs to activate them under Autostart. I've only put them on Startup and Shutdown sequences (after SQL Server and Agent services), without any kind of special customization. Comments? I need to hear a lot..
Regards
Claudio
No Events found!
JoelStewart
24 Posts
0
February 15th, 2011 14:00
Proxies are not needed if you just need to send start and stop commands to the service. AutoStart will use its default monitoring features for services which reference the service state provided by the services.msc data.
If you'd like a more specific application level monitoring such as that offered by the SQL Module for SQL Server, then you would need to write some additional customizations.
If timing is a concern, there are "Wait" objects that can be added into the resource group during the startup and shutdown sequences as needed. Without a wait object configured, it will start (or stop) the item as soon as the previous item has been started (or stopped).
Polska1422
2 Intern
•
128 Posts
0
February 15th, 2011 14:00
Joel,
I'll keep on mind that. Autostart version is 5.3 SP4 with Hotfix build 286. What about proxies and other timmings? Aren't needed?
Regards
Claudio
Polska1422
2 Intern
•
128 Posts
0
February 15th, 2011 14:00
Thank you, Joel. Your comments were very useful.
Regards
JoelStewart
24 Posts
1
February 15th, 2011 14:00
Claudio,
That configuration should work just fine. AutoStart will send the start commands to these services when the resource group is brought online and will send the stop commands during the take offline process. AutoStart will also monitor these services for failure and take the configuration actions if failure is detected.
Depending on your AutoStart version, if you make changes to the "Module" configuration in the GUI it may overwrite your customizations to the "Resource Group". Be cognizant of this fact when performing any maintenance and double check the configuration before starting up the resource groups following maintenance.