The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Not able to create MS SQL Server Linked server

Discussion in 'Workarounds and Optimization' started by cse_king2, Aug 30, 2016.

Tags:
  1. cse_king2

    cse_king2 Registered

    Joined:
    Aug 30, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chennai India
    cPanel Access Level:
    Website Owner
    I am trying to create MS SQL Server Linked server to connect web MYSQL . I have given access to my static IP address in "Remote MYSQL".

    I have choosen following option in MS SQL Server Linked server

    Provider: Microsoft OLE DB Provider for ODBC Drivers

    Product name: MySQL

    Data Source: MySQL ( I don't know what I should give here hence I have given MysQL)

    Provider String: DRIVER={MySQL ODBC 5.5 Driver};SERVER=Shared IP address Mention in CPanel;PORT=3306;DATABASE=database name; USER=user;PASSWORD=password;

    When I try to connect using above obtion I am getting error as "Not able to connect"

    When executed below command in my CMD
    telnet "Shared IP address Mention in CPanel" 3306

    I am getting following message:

    [Removed]


    Kindly help me how to solve this issue?
     
    #1 cse_king2, Aug 30, 2016
    Last edited by a moderator: Aug 30, 2016
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. cse_king2

    cse_king2 Registered

    Joined:
    Aug 30, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chennai India
    cPanel Access Level:
    Website Owner
    Hi @Michael,
    I am not trying to call remote mysql from my php script. I am trying to connect cpanal mysql to desktop installed ms sql serverver through linked server option.
     
    #3 cse_king2, Aug 30, 2016
    Last edited by a moderator: Aug 31, 2016
  4. cse_king2

    cse_king2 Registered

    Joined:
    Aug 30, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chennai India
    cPanel Access Level:
    Website Owner
    I have reolved this issue.
    I have followed following steps
    1.Given client IP address in Remote MySQL
    2.Installed "MySQL Connector/ODBC 5.1" in Client Meachine by following this tutorial -> ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
    3)Created Temp table in Client Meachine & given full permission by following this tutorial -> https://support.microsoft.com/en-us/kb/814398
    4)I have created linked server by following this tutorial -> ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
    5) Along with above step while creating linked server I have given "provider string" values like (SERVER=IP address of CPANEL;PORT=3306; DATABASE=database_name;USER= database_user;PASSWORD= database_password;" along with product name & source name while creating linked server.
     
    #4 cse_king2, Sep 1, 2016
    Last edited by a moderator: Sep 1, 2016
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page