|
| I've followed the books online help to configure SSIS (move the
MsDtsSrvr.ini.xml file, edit the file to have the correct path virtual server
name, and change the registry), restart all services...and nothing. I can
connect to SSIS fine through Management Studio, but when I click on Stored
Packages -> MSDB it hangs and eventually times out with this error message:
"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."
I have no default instance of SQL 05 on an active-active failover cluster
(they are all named instances).
Also, I note from the various articles (Hassleden's and the MS info) it was
unclear to me what names should be used in the MsDtsSrvr.ini.xml Server
section: I've tried the machine name\instance name, machine name-instance
name, cluster name-instance name, etc etc, but nothing has worked.
thanks!
|
|