java.net.SocketPermission Error with SQL Server

General Web Coding Cold Fusion MX
1

Ever since Saturday’s reboot, I get the following error whenever I try to query a SQL Server database:

[Macromedia][SQLServer JDBC Driver]Error establishing socket. access denied (java.net.SocketPermission mssql1.myhsphere.biz resolve)

To try to isolate the problem, I’ve tried to simplify the problem: I’ve created a simple test page:

Untitled Document SELECT * FROM Test1

I created the database fresh and created a single table, “Test1” and populated it with a single row.

Nobody seems to have a clue. My code was working fine before the CFRegistry reboot.

Anybody out there have any ideas?

2

SELECT *
FROM Test1

First thing that stands out to me on this query is the lack of a username and password parameter.

Try adding in the username that has access permission and it’s associated password into the CFQuery tag and see if that doesn’t clear things up for you.

Additionally, you might want to have the Admins double check the SQL Server that you’re dealing with. mssql1.myhsphere.biz doesn’t look like a proper JodoHost SQL Server.

3

mssql1.jodoshared.com is an alias of mssql1.myhsphere.biz. His database is on the same server your’s is hatton

4

Mason,

Are you still experiencing problems with your database connection?

5

I had this problem too. JodoHost changed some security settings and it started working

6

The problem was related to security settings at JodoHost which have now been fixed. Thanks for the feedback all.