Integration Manager connect to remote SQL server

(0) Share

Report

Posted on by Community Member

IM 11. I am trying to create a DSN for Integration Manager to connect to a remote SQL server. I am using the IP address including the port. I can connect to the server from SQL Server Management Studio SQL Server 2012 and run queries. I can create DSN's to my local servers. When setting up the DSN I get

Connection Failed

SQLState: '01000'

SQL Server Error: 53

Connection Failed

SQLState: '08001'

SQL Server Error:17

Server does not exist or access is denied.

my connection string looks like

DRIVER=SQL SERVER;SERVER=XX.XXX.XXX.XXX,3913;=UEIxDportUser;PWD=********;APP=Integration Manager;WSID=DYNAMIC;DATABASE=BD_Global

I have tried variations including the server name instead of the ip address with no success. I have run out of ideas.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

soma 24,410 on at

Like (0)

Report

Can you attach the screenshot for the connection details in both DSN and SQL sever management Studio?

Was this reply helpful? Yes No
Suggested answer

rudra 6,534 on at

Like (0)

Report

Hi ,

Is the port 3913 is opened incase if firewall is enabled, then you will get this exception and passing the wrong string values will also cause this kind of issues.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

I got it to work. Creating the DSN would only allow me to select SQL Server as the driver to be able to use the Configure button to enter the server and login info. Once the connection string was properly built, I selected the general tab again and switched to SQL Native Client 10 and it worked. If I was confident that I could type the entire connection string perfectly without the help of the configure button (not with my fingers), I could have selected Native Client from the beginning and succeeded. Thanks for your reply.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

It would be helpful to others who find this post if you would post the results of the connection string. This question could then be marked as resolved.

Kind regards,

Leslie

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Like that Leslie? :)

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

show off :)

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

I am just the wizard of Oz here. All smoke and mirrors!!

Was this reply helpful? Yes No