Why this doesn't work: [MySQL][ODBC 5.1 Driver]Access denied for user
- by bvandrunen
So I know that there is a very similar question to this all over the web as well as stack overflow:
http://stackoverflow.com/questions/2539961/error-access-denied-for-user-mysql-server
but my question I think is different. So I have set up a linked server and it works...I have the correct permissions set up for my IP's that I am using. However the problem arises when our user "webuser@correctIP" tries to access it. Therefore, any user using window authentication is allowed to access it and works great...but any that are not using windows authentication are blocked.
However, I have tried all the common solutions such as setting up a strict password, changing security settings in Microsoft SQL Server etc. Nothing is working. Any help is appreciated. Thanks.
FYI: I am using this from Microsoft SQL Server 2008 - mysql (through myphpadmin)