Hi Folks
I have created a CLR UDF that calls a web service (a postcode lookup service, but that's besides the point), and when I try to run the function I get the error in the thread title.
The database that I'm deploying the CLR UDF to is a dedicated server, to which I have RDP access as the administrator.
To write and deploy the UDF, I followed the following tutorial post: http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm
I'm no CAS expert, but I think that the problem is the account that the SQL process uses does not have rights to call the web service method.
Can anyone help? Any advice would be greatly appreciated!
...
Go to the complete details ...