Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1519
  • Last Modified:

Permission denied: connect

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
dgrafx
Asked:
dgrafx
1 Solution
 
jorge_torizResearch & Development ManagerCommented:
Can you put your connection string?
0
 
logideepakCommented:
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
 
dgrafxAuthor Commented:
jorge - this is ColdFusion which doesn't need to use connection strings
logideepak - 1433 is open
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
dgrafxAuthor Commented:
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
 
_agx_Commented:
Argh. I *hate* when that happens.

Btw: Didn't logideepak suggest it might be a firewall problem? :)
0
 
dgrafxAuthor Commented:
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
 
_agx_Commented:
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
 
dgrafxAuthor Commented:
>>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
 
_agx_Commented:
>> 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
 
dgrafxAuthor Commented:
i found the solution
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now