SQL Server 2005 Unable to Connect to Integration Service or Unable to Work with Maintenance Plans

Wednesday, 27 May 2009 23:27 by RanjanBanerji

This is a post so that I remember this problem and can fix it when it resurfaces 6 months later.  Though I really hope that in 6 months I will only be dealing with SQL Server 2008 and not 2005.  I recently setup two SQL Server 2005 environments and on one of them I just cannot connect to the Integration Service.  I also noticed that I was unable to create a backup maintenance plan.  A little research led to the following Microsoft Knowledge base article:

http://support.microsoft.com/kb/919224

 

In my case, I do not know if this is true for everyone, there were some discrepancies between how my machine was setup and the fix for the problem.

  • Microsoft suggests registering the 32 bit dts.dll using %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll".  The problem I found is that dts.dll on my server was not in %ProgramFiles(x86)%\Microsoft SQL Server but instead it was in %ProgramFiles%\Microsoft SQL Server(x86)\90\dts\binn
  • Registering the 32 bit dts.dll did not solve the problem.  I could connect to Integration Service but I was getting all sorts of strange errors.  So I went ahead and registered all the dts/binn DLLs.  Now everything works.

I do not know if by registering all the DLLs if I have created new problems.  But so far everything seems to be working fine.  If I do find problems I will update this post.

Categories:   SQL Server
Actions:   E-mail | Permalink | Comments (0) | Comment RSSRSS comment feed

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading