Monday, March 19, 2012

Error when connecting to SSIS.

I just installed a default instance of SS 2005 and applied the most recent service pack, release date March 5th, SQLServer2005SP2-KB921896-x64-ENU.exe.

All services are running as localsystem. When I try to connect to SSIS through Management Studio on the local machine I receive the following error.

Any help would be appreciated.

TITLE: Connect to Server

Cannot connect to [server name].

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 "[server name]" failed:
Error loading type library/DLL.
.

Connect to SSIS Service on machine "[server name]." failed:
Error loading type library/DLL.
.

BUTTONS:
OK

Do you have the SQL Server SSIS service started (running)?|||I do.|||

There was one thing that was a little weird. I tried re-installing the Service Pack and it did not recognize that the services were running or would interfere with the install.

The first time I installed SP2 it forced me to stop the services before installing, but the second time it did not. Seemed as if the install did not detect the services were running.

After installing the second time, I did a reboot to attempt to clear it up. SSIS still did not allow a connection and I received the same error.

|||Does this help? Are you also running SQL Server 2000?

http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx|||No not running SQL 2000 on this computer. It is a brand new server.|||

I am looking at the link you sent, thought this may be relevant also.

There was a previous named instance that I uninstalled, before installing the default instance. There were no other instances on the computer after I uninstalled the named instance.

|||

Phil,

The xml ini file in the link appears to be correct on my server.

It shows the servername as <ServerName>.</ServerName>.

I appreciate the help, so does my client. ;)

|||

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

|||Have you tried reinstalling the client tools?|||

SnoChoJoe wrote:

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

I just read that myself. Are you on a 32 bit machine? The SP2 service pack you indicated is for 64 bit.|||No it is an X64 architecture.|||No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?|||

SnoChoJoe wrote:

No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?

Perhaps... Make sure you have a working installation before applying any service packs.|||

Ok, I am going to trouble shoot the client install.

I will advise if I determine the problem. Thanks Phil.

No comments:

Post a Comment