CF and database problem

[Good Oyster]

I am trying to switch from using Access to MS SQL. The tech support guys transferred my data to my MS SQL db, and set up the connection. I made the changes to my code (usernames and passwords for the db in queries, changed datasource name). When I try to log in, I get the following:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Error establishing socket. access denied (java.net.SocketPermission ms***.jodo*****.com resolve)

The error occurred in C:\*****\w*****e\****ds.com\******.cfm: line 9

7 : SELECT username, password
8 : FROM tbl****g
9 : WHERE (UserName = '#username#') AND (Password = '#password#')
10 : </cfquery>
11 :

Anything look suspicious? As far as I can tell from the lists I've found, I haven't used any MS SQL reserved words. And this same script works great using Access.

 

[Yash]

This is not related to your code

Please submit a ticket and it will be taken care of. The host name you are trying to access must be allowed within Cold Fusion

 

[Good Oyster]

Thanks, Yash. I submitted the ticket.