?
Solved

Permission denied: connect

Posted on 2010-11-25
10
Medium Priority
?
1,556 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 53

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 53

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 53

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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

569 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