Solved

Permission denied: connect

Posted on 2010-11-25
10
1,446 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

628 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