I have a MySQL server that I need to set up as a linked server in SQL Server 2014.
I need a login from the SQL Server (which is a Windows group) to impersonate a username at the MySQL end.
I can see from Googling that this cannot be done.
I can create a new Windows login for every user in the Windows Group and map them, but was wondering if there is a slicker way of doing this?
I am not an admin of the MySQL server so cannot make any config changes there.