- Thank you received: 0
Test connection failed because of an error in initializing p
- danielbos
- Topic Author
- Visitor
-
9 years 5 months ago #10318
by danielbos
Test connection failed because of an error in initializing p was created by danielbos
Hi all,
I am evaluation the Redshift provider but I can't get it to work.
What I did is:
- Install the Redshift provider
- Opened SSDT (2012)
- Created a MSSQL OLE DB source
- Created a Redshift target
When creating the target I filled in the server connection details including the AWS S3, as said by the manual.
When I click on 'test connection' I get:
TITLE: Connection Manager
Test connection failed because of an error in initializing provider. Value does not fall within the expected range.
BUTTONS:
OK
I really would like to test out the product if it works and have the performance benefits as described.
Could you help me out?
Regards,
Daniel
I am evaluation the Redshift provider but I can't get it to work.
What I did is:
- Install the Redshift provider
- Opened SSDT (2012)
- Created a MSSQL OLE DB source
- Created a Redshift target
When creating the target I filled in the server connection details including the AWS S3, as said by the manual.
When I click on 'test connection' I get:
TITLE: Connection Manager
Test connection failed because of an error in initializing provider. Value does not fall within the expected range.
BUTTONS:
OK
I really would like to test out the product if it works and have the performance benefits as described.
Could you help me out?
Regards,
Daniel
Please Log in or Create an account to join the conversation.
9 years 4 months ago #10322
by Moderator
Replied by Moderator on topic Re: Test connection failed because of an error in initializi
As we found later it was a user error: database name was not specified correctly.
Please Log in or Create an account to join the conversation.
Time to create page: 0.147 seconds