Solved

Permission denied: connect

Posted on 2010-11-25
10
1,410 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Suggested Solutions

Title # Comments Views Activity
SQL query to summarize items per month 5 53
SQL Maintenance Plan 3 30
Merge Statement 3 40
Joining Two Tables In SQL and combining records 6 52
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now