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.
I solved the problem creating a new user and just giving access to arachnode.net and another schema I use to save the results.
I really don't know what is wrong with the other user, I assume it has something to do with access rights, but examining the settings I couldn't find anything.
Thanks for your help.
Hmmm... not sure what is wrong?
Is there a specific exception stack trace you can share?
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=Login+failed+for+user+SQL ? Do any of these links help?
For best service when you require assistance:
Is must be some configuration on the server, but I didn't figure it out yet.
In the application event log, one of the messages it gives is:
AppDomain 15 (arachnode.net.dbo[ddl].14) unloaded.
Does this say something to you?
Can you connect via SSMS?
That message is normal.
Try stepping through the code?
Where are you getting the error from? What is the stack trace of the error?
Great! I am glad it is working for you.