Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager co...
Microsoft Dynamics GP (Archived)

Integration Manager connect to remote SQL server

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

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

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Integration Manager connect to remote SQL server

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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Integration Manager connect to remote SQL server

    show off :)

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Integration Manager connect to remote SQL server

    Like that Leslie? :)

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Integration Manager connect to remote SQL server

    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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager connect to remote SQL server

    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.

  • Suggested answer
    rudra Profile Picture
    rudra 6,534 on at
    RE: Integration Manager connect to remote SQL server

    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.

  • soma Profile Picture
    soma 24,406 on at
    RE: Integration Manager connect to remote SQL server

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans