Cannot Connect to SSIS remotely or locally

Question

Cannot Connect to SSIS remotely or locally

Ryan-209402

Hall of Fame

Points: 3707
More actions
July 11, 2006 at 1:04 pm

#366775

I receive an error when I attempt to connect to SSIS via Management Studio. There is only a default instance on this SQL server and it is not running IIS or any COM+ services. There are other SQL servers in that same subnet and I can connect to SSIS fine so this is apparently not a networking issue. Thanks for any help you can offer.
Connect to SSIS service on machine "servername" failed: library not registered
===================================
Cannot connect to "servername".
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Ryan,

are you sure that SSIS is installed and the service started ? The error seems toindicate that SSIS is not (properly) installed.

Markus

[font="Verdana"]Markus Bohse[/font]

Ryan-209402 Hall of Fame Points: 3707 More actions · Answer 2

Thanks for your reply. It is definitely installed and the service is started. I will try uninstalling and reinstalling SSIS to see if that helps.

Ryan-209402 Hall of Fame Points: 3707 More actions · Answer 3

Thanks. I found that even though SSIS was installed, the DTSRuntimeWarp.dll was not even present. I reinstalled sp1 and all is well.

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 4

I had similar issue in an environment with SQL Server 2005 with SP2.

I registered two dlls(command below) and its working fine now.

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

rev_swamy SSC Rookie Points: 42 More actions · Answer 5

Thanks a lot .............

The above registration worked.............

Thanks,

Revansiddayya

askastech SSC Rookie Points: 25 More actions · Answer 6

askastech

SSC Rookie

Points: 25

March 17, 2009 at 12:56 am

#960832

It was very helpful

gregg mcgilvray Valued Member Points: 53 More actions · Answer 7

gregg mcgilvray

Valued Member

Points: 53

April 16, 2009 at 8:21 am

#978892

Beutiful, it worked for me too. Thanks a buncg

Gregg

ryan.shirley SSC Journeyman Points: 92 More actions · Answer 8

Had the same problem with an SSIS project in VS 2005. It wouldn't load after a Windows Update. The solution above fixed it. Thanks!

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 9

Did Windows update updated SQL Server 2005 with SP2. If yes then do the above registration and I think it should work.

You can use below query to know the version:

SELECT CONVERT(char(20), SERVERPROPERTY('productlevel'));

GO

select @@version

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

ryan.shirley SSC Journeyman Points: 92 More actions · Answer 10

Yes, I think Windows Update installed SP2. I checked the version and SP2 is installed, but I don't know how long it has been there.

Registering the two DLL's let me open packages but I could not open the Dataflows! So now I'm trying this.

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=83&threadid=88464&enterthread=y

aortoll_con Grasshopper Points: 24 More actions · Answer 11

aortoll_con

Grasshopper

Points: 24

June 22, 2010 at 6:56 pm

#1183673

It fixed for me too !! Thanks a lot 🙂

SQL DBA-685905 Say Hey Kid Points: 670 More actions · Answer 12

I have faced the same issue, resolved it by reapplying the Service Pack. 🙂