Solved

Permission denied: connect

Posted on 2010-11-25
10
1,427 Views
Last Modified: 2012-05-10
Am getting the following error and need help

Connection verification failed for data source: xxx
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: zzz:1433. Reason: Permission denied: connect
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: zzz:1433. Reason: Permission denied: connect

zzz is servername
this is on windows 7 using sql 2K8
don't know what to add so just ask whatever questions you need to
thanks
0
Comment
Question by:dgrafx
10 Comments
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 34214988
Can you put your connection string?
0
 
LVL 5

Expert Comment

by:logideepak
ID: 34215433
It seems that the firewall has blocked the 1433 port and hence the connection could not be made.

Please set the incoming connections to "Allow" for Domain Profile, Public Profile and Private Profile and try again. it should be resolved.
0
 
LVL 25

Author Comment

by:dgrafx
ID: 34217700
jorge - this is ColdFusion which doesn't need to use connection strings
logideepak - 1433 is open
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 25

Accepted Solution

by:
dgrafx earned 0 total points
ID: 34219985
i found the problem!
mcafee security center was malfunctioning!
just got off the phone with mcafee tech support where they deleted the install and re-installed due to a malfunctioning product - as they said.
I don't know how I thought of it but I disabled mcafee and everything then worked great!
so anyone else with a problem that doesn't seem to make sense having to do with a connection problem - one thing to try is to disable your antivirus / firewall!
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34227770
Argh. I *hate* when that happens.

Btw: Didn't logideepak suggest it might be a firewall problem? :)
0
 
LVL 25

Author Comment

by:dgrafx
ID: 34230133
agx - logideepak meant "check that your firewall is allowing correct port and software".
i'd done that and everything else i could think of before posting including extensive googling.
not only did firewall say the port and software were good to go but i could telnet and netstat gave a thumbs up as well.

he did NOT mean "you have a bad install of your antivirus / firewall product - uninstall and reinstall - i've seen this before where antivirus / firewall malfunctions and is covertly blocking software"

btw - i'm not an expert in "stuff" like this but i believe that technically it was not a port issue but a software being blocked from communicating issue - ???

I wanted to post about this so it could be a possible resource for others
Thanks everyone
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34235664
dgrafx -

Yeah, I missed your response "port 1433 is open".  It also sounds like you did a lot of research, uninstalling, etc.. on your own.  So I wouldn't argue the point.  

>> i believe that technically it was not a port issue but a software being blocked
>> from communicating issue

My original read on it was: it's a problem with your firewall. Technically that's what it seems to be.  But I'd have to agree it's a program level blocking rather than port level. I have mcafee and my version has a separate section for program level permissions.  A program can be either totally blocked or allowed.  Drove me nuts at first when some programs stopped working.  Until I figured out how to "undo" blocked programs ;-)  Wish I'd come across this thread earlier.  But thanks for posting the resolution. I'm sure it'll definitely help others.
0
 
LVL 25

Author Comment

by:dgrafx
ID: 34235957
>>Drove me nuts at first when some programs stopped working.  Until I figured out how to "undo" blocked programs<<
Note that in my case the software already said the programs were unblocked - so i couldn't do any more with that.
And also according to McAfee it was a "bad install" - they connected remotely to my pc.
I take their word for it - I don't know much about this subject and it's their product!
But now it works great and I can go back to not knowing much about this subject ...
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34239888
>> so i couldn't do any more with that.
Yeah

>> I take their word for it - I don't know much about this subject and it's their product!
Haha. Surprising how many companies have tech support that doesn't know their own product.Glad that wasn't the case w/McAfee :)
0
 
LVL 25

Author Closing Comment

by:dgrafx
ID: 34246404
i found the solution
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question