Sunday, February 12, 2012

cannot connect to integration services

When i try to connect to SQL 2005 integration services from object explorer i get connected (in the sense it shows in object explorer running packages stored packages ..)but when i try to exand any of these objects i get the following error

--

Failed to retrieve data for this request(Microsoft.sqlserver.smoEnum)

Additional information

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 "config integeration services" in server 2005 books online.

Login time out expired

An error has occured while establishing a connection to the server.When connecting to the Sql server 2005, the failure may be caused by the fact that under default settings Sqlserver does not allow remote connections.

Names Pipes Provider: could not open a connection to Sql Server[2].(MsDtsSrvr)

-

i have chkd remote connection settings and other settings but cant find a way out.

kindly provide some help

Thanks in advance

This could be because you do not have a default instance of SQL Server in your machine.

Please refer to SQL Server 2005 Books online: http://msdn2.microsoft.com/en-us/library/ms137789.aspx

As it states, the default configuration file is for default instance of SQL Server in the machine. If you do not have a default instance in your machine and you want to use a named instance, then you have to modify the configuration file as described.

Please try it out and let us know if still have problems browsing the objects.|||

Thanks for the Reply ..

Thanks a lot

It worked out ...

|||

Even, I am getting the same error message after making the change in xml config file to connect named instance.

No comments:

Post a Comment