I've successfully created a plugin and executed it using a connection with my localhost instance of SQL Server. Now I'm trying to execute it connected to a remote server, and I'm getting the error "Login failed for user 'user'".
I've used the 'Add Database Reference' to generate the connection string on the Functions project and used the same string to fill the property on ConnectionString.config. When adding the reference, I tested the connection and it was working fine.
Any ideas on what I'm missing?
My local SQL Server version is 2005 and the remote version is 2008 R2.