Error when connecting to Integration Services via SSMS

i***@comcast.net

2006-09-25 18:04:29 UTC

I found the answer at
http://msdn2.microsoft.com/en-us/library/ms137789.aspx . It works, but
you still have to use only the server name when connecting through SQL
Mgmt Studio.

Here's an excerpt:

Microsoft SQL Server 2005 Integration Services (SSIS) includes a
configuration file for configuring the Integration Services service.

By default, the file is located in the folder, Program Files\Microsoft
SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml.

The following XML code shows an example of a modified configuration
file for Integration Services. This file is for a named instance of SQL
Server called InstanceName on a server named ServerName.

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>ServerName\InstanceName</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

HTH,
Chris

Post by Catadmin
We have a development cluster with 3 named instances of SQL server on it (SQL
2005) and no default. Each instance has a xxx_MSDB folder under Stored
Packages. When I go to connect to Integration Services via SSMS, I get the
below error.
"Failed to retrieve data for this rquest. (Microsoft.SqlServer.SmoEnum)
The SQL server specified in SSIS service configuration is not present or 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 failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (MsDtsSrvr)"
So, I went to BOL and *cannot* find the above topic. Not listed filtered by
SQL Server 2005 and not filtered by SQL Server Integration Services. ????
Plus, the login error message is totally confusing as I was using my Windows
account to login on SQL, not an anonymous login.
Since this topic is missing from BOL, can someone here explain what is going
on?
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back???
@=)