title: create linked server to Mysql Cpanel
body: <p>I've created an ODBC connection to my MySQL cPanel. I've made the settings in System DSN and when I press TEST Connection the message that returns is succesful. I've added the IP as a wildcard. Then I'm going in the SQL Server Management Studio to create the linked server. I fill up with the dates, I choose "Microsoft OLE  DB Provider for ODBC drivers", but when I press OK the following error is showing up:</p>
  
  <blockquote>
    <p>The linked server has been created but failed a connection test. Do
    you want to keep the linked server?</p>
    
    <p>Cannot initialize the data source object of OLE DB provider "MSDASQL"
    for linked server "GRUPSAPTE". OLE DB provider "MSDASQL" for linked
    server "XXXXXXX" returned message "[MySQL][ODBC 5.1 Driver]Access
    denied for user 'gsapte'@'XXXXXXXXXX' (using password: NO)".
    (Microsoft SQL Server, Error: 7303)</p>
  </blockquote>
  
  <p>I've created many linked servers for localhost but when I'm trying to create for my webserver it shows the error above. Do I have to make some changes to the webserver or some access things? </p>
  
  <p>Any advise will be much appreciated.</p>