Exporting SQL 2005 Maintenance Plans on SQL Cluster

I'm trying to export Microsoft SQL 2005 Maintenance plans per the following
article on the MSDN Forums:
http://forums.microsoft.com/MSDN/sho...89484&siteid=1
However I'm getting the following error:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server on the computer. For more information, see the topic "Configuring the
Integration Services Service" in Server 2005 Books Online.
Login timeout expired
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].
(MsDtsSrvr)
BUTTONS:
OK
Searching on google I found the following links which explain how to setup
SSIS as a clustered SQL service (which I did):
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
I've also tried the steps outlined in:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx
I'm at a loss... what am I doing wrong?
Thanks
Brad
I figured out my own problem. It turns out even though I made the registry
change mentioned in this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
The change I originally made didn't take effect - when I refreshed the
registry I noticed the key had reverted back to the original value.
Resetting the key and restarting the Integration Services cluster service
fixed the problem.
Thanks!
Brad
"Brad Baker" <brad@.nospam.nospam> wrote in message
news:u7RdSS16GHA.4404@.TK2MSFTNGP04.phx.gbl...
> I'm trying to export Microsoft SQL 2005 Maintenance plans per the
> following article on the MSDN Forums:
> http://forums.microsoft.com/MSDN/sho...89484&siteid=1
> However I'm getting the following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> The SQL server specified in SSIS service configuration is not present or
> is not available. This might occur when there is no default instance of
> SQL Server on the computer. For more information, see the topic
> "Configuring the Integration Services Service" in Server 2005 Books
> Online.
> Login timeout expired
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> Named Pipes Provider: Could not open a connection to SQL Server [2].
> (MsDtsSrvr)
> --
> BUTTONS:
> OK
> --
> Searching on google I found the following links which explain how to setup
> SSIS as a clustered SQL service (which I did):
> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
> I've also tried the steps outlined in:
> http://msdn2.microsoft.com/en-us/library/aa337083.aspx
> I'm at a loss... what am I doing wrong?
> Thanks
> Brad
>
|||Hi,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====