Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

rror msgs is appear when trying to connect to ssis

This error msgs is appear when trying to connect to ssis. services for ssis is running even I have restarted it few times,  also have reinstalled ssis twice, but it did not helped... actually what is wrong here ?


TITLE: Connect to Server
------------------------------

Cannot connect to SERVERB.

------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

Connect to SSIS Service on machine "SERVERB" failed:
 The specified service does not exist as an installed service.
.


------------------------------

Connect to SSIS Service on machine "SERVERB" failed:
 The specified service does not exist as an installed service.
.


------------------------------
BUTTONS:

OK
------------------------------


ASKER CERTIFIED SOLUTION
Avatar of tigin44
tigin44
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

No,
I'm using ssm and try to connect to ssis, it throw me errors as above.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Guys,
Thanks, I think the solution to this is reinstalled the entire sql2005 program. I will try with one of the server which had the same issues and let see whether it will solve or not