Getting a permission error when trying to connect to sql database
- by Matt
I have a sql server on a dedicated machine, running SQL 2008. I have the IP of the box, a database setup on it.
I've built a small script that just does a connection test, and when I run it, I get the following error.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I've been told by the admin that SQL remote access has been granted for my IP address.
Anybody know what's wrong?