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?
Are you using a connection string similar to show here connectionstrings.com
username=xxx;pwd=xxx;
*Trusted_Connection=True;*
Might need a bit more info about your environment.
Active Directory? Make sure that SQL client is running under a domain account and that it is in the same domain as users trying to access it.
Let us know if not AD or if that doesn't work, and we'll keep trying from there.
(Also, I'm not sure about "remote access has been granted for my IP address." You need actual login credentials.)
Has the SQL Server been configured to allow remote connections yet using the appropriate protocol - I'd presume TCP/IP. If it's a fresh install this step may have been missed.
After confirming the basic config the steps CResults has listed should get you there.
To force TCP/IP (if your client defaults to somthing else), try adding this to your connectionstring ";Network Library=dbmssocn", so that it looks something like this:
Data Source=ipAddressHere;Initial Catalog=dbName;User Id=user;Password=pass;Network Library=dbmssocn
or
Data Source=tcp:ipAddressHere,1433;Initial Catalog=dbName;User Id=user;Password=pass
To help rule out any sys-admin type problems I would recommend connecting using SQL Management studio on your client machine. If this isn't available use the Visual Studio Server Explorer to initiate a connection.
Assuming this connects then verify you can run whichever SQL command you are using in your test.