x

Error creating a connection in SSIS

Hi,

I am getting an error when trying to create a connection to a database on an MS SQL Server 2005 from within an SSIS package.

The error message says "Error initializing provider."

I am able to create connections from within an SSIS package fine to other MS SQL servers - except one.

Any thoughts on why this may be happening?
more ▼

asked Apr 27 '12 at 08:18 PM in Default

hms gravatar image

hms
10 1 1 1

Yes, I am able to connect to the server via SSMS using the same credentials.

The provider that I used was the Native OLE DBSQL Native Client. I also tried using Microsoft OLE DB provider for SQL server. But that did not help either.

My local server is a Windows 2003 - and it is a 32 bit server. I am not sure about the server that I am trying to connect to...

Any help with resolving this issue would really be appreciated!! Please let me know if further information is needed.

hms
Apr 30 '12 at 01:51 PM hms
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
First thing is to check all your settings to make sure you are using the correct provider (SQL Server), second are the credentials correct that you are using? Can you connect to that server via SSMS to validate that "remote connections" are enabled on that instance. Are you on a 32bit server trying to connect to a 64bit? Any additional information you can provide will greatly help us help you.
more ▼

answered Apr 28 '12 at 05:42 PM

Tim gravatar image

Tim
35.5k 32 41 138

(comments are locked)
10|1200 characters needed characters left

Yes, I am able to connect to the server via SSMS using the same credentials.

The provider that I used was the Native OLE DB\SQL Native Client. I also tried using Microsoft OLE DB provider for SQL server. But that did not help either.

My local server is a Windows 2003 - and it is a 32 bit server. I am not sure about the server that I am trying to connect to...

Any help with resolving this issue would really be appreciated!! Please let me know if further information is needed.

hms

more ▼

answered Apr 30 '12 at 12:42 AM

hms gravatar image

hms
10 1 1 1

Also, I found out that the sever that I am trying to connect to is a 32 bit server.
Apr 30 '12 at 01:51 PM hms
(comments are locked)
10|1200 characters needed characters left

Hello,

This issue is resolved.

Apparently, for the same userid, there was another password that enabled me to connect through SSIS (though I would think that the account that enabled me to login through SSMS would work for SSIS as well?).

Thanks for your effort with helping me through this issue!

Regards, hms

more ▼

answered Apr 30 '12 at 02:16 PM

hms gravatar image

hms
10 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x900

asked: Apr 27 '12 at 08:18 PM

Seen: 870 times

Last Updated: Apr 30 '12 at 02:16 PM