How to Encrypt a Column in sql server 2000/2005
In SQL 2005 encryption is built into the database platform. This is the first version of SQL Server which includes encryption as a part of the platform. If you are using SQL Server 2000 you will need to use third party extended stored procedures to encrypt and decrypt the data. Here is some basic code [...]
View Answer
| February 20, 2008 8:11 AM
Encryption, SQL Server
In SQL 2005 encryption is built into the database platform. This is the first version of SQL Server which includes encryption as a part of the platform. If you are using SQL Server 2000 you will need to use third party extended stored procedures to encrypt and decrypt the data. Here is some basic code [...]
View Answer
| February 20, 2008 8:11 AM
Encryption, SQL Server
Deep Freeze 5
from what I have seen on our deep freeze installations you need the original config file (executable) that was made for the original system. then just run it on the new system. the file should be named like this: DF5Wks.exe.
View Answer
| February 19, 2008 5:53 PM
Deep Freeze, Network
from what I have seen on our deep freeze installations you need the original config file (executable) that was made for the original system. then just run it on the new system. the file should be named like this: DF5Wks.exe.
View Answer
| February 19, 2008 5:53 PM
Deep Freeze, Network
Intelligent Messaging Filter (an oxymoron?)
The requirement to copy the Custom Weighting file (MSExchange.UceContentFilter.xml) to each new sub-folder created by IMF updates in the ExchsrvrBinMSCFV2 folder has proven to be a big nuisance. There’s little incentive for Microsoft to fix an older version of Exchange Server, now that Exchange Server 2007 SP1 has been released. The only way out is [...]
View Answer
| February 19, 2008 9:07 AM
Custom Weighting Feature, Exchange 2003, IMF, Intelligent messaging filter, UceContentFilter
The requirement to copy the Custom Weighting file (MSExchange.UceContentFilter.xml) to each new sub-folder created by IMF updates in the ExchsrvrBinMSCFV2 folder has proven to be a big nuisance. There’s little incentive for Microsoft to fix an older version of Exchange Server, now that Exchange Server 2007 SP1 has been released. The only way out is [...]
View Answer
| February 19, 2008 9:07 AM
Custom Weighting Feature, Exchange 2003, IMF, Intelligent messaging filter, UceContentFilter
Segmenting a network
the benefits of segmenting a network is to cut down on broadcasts and traffic going thru the entire network. you can do this with a switch but it has to be a managed switch that is capable of making VLANS. a VLAN basically takes ports that you select on the switch and segments them off [...]
View Answer
| February 18, 2008 2:37 PM
Network Segmenting, Networking, Switches
the benefits of segmenting a network is to cut down on broadcasts and traffic going thru the entire network. you can do this with a switch but it has to be a managed switch that is capable of making VLANS. a VLAN basically takes ports that you select on the switch and segments them off [...]
View Answer
| February 18, 2008 2:37 PM
Network Segmenting, Networking, Switches
i have a access is denied popup when i try to delete a file that i know has a virus in it.
Your anti-virus software should have an option within it to clean, quarantine or delete the file.
View Answer
| February 17, 2008 3:43 AM
Antivirus, Microsoft Windows, Viruses
Your anti-virus software should have an option within it to clean, quarantine or delete the file.
View Answer
| February 17, 2008 3:43 AM
Antivirus, Microsoft Windows, Viruses
Windows XP System Hardening – Sysprep problem
I don’t have the answer, but can recommend some utilities which may point you in the right direction. Download filemon and regmon from Microsoft Technet (formerly Sysinternals.com), and see if you can get them to run at your initialization time – prior to the driver detection (I’ve not done this – but it’s worth a [...]
View Answer
| February 14, 2008 10:16 PM
Desktops, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server
I don’t have the answer, but can recommend some utilities which may point you in the right direction. Download filemon and regmon from Microsoft Technet (formerly Sysinternals.com), and see if you can get them to run at your initialization time – prior to the driver detection (I’ve not done this – but it’s worth a [...]
View Answer
| February 14, 2008 10:16 PM
Desktops, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server
Check AS400 password in PC environment
From your VBasic program call the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QSYGETPH.htm”>Get Profile Handle API QSYGETPH</a>. This will allow you to validate the userid and password. After validating the password you will want to call the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QSYRLSPH.htm”>Release Profile Handle API QSYRLSPH</a>. Bruce Vining <a href=”http://www.brucevining.com/”>http://www.brucevining.com/</a>
View Answer
| February 14, 2008 2:51 PM
AS/400, AS/400 security, Password authentication
From your VBasic program call the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QSYGETPH.htm”>Get Profile Handle API QSYGETPH</a>. This will allow you to validate the userid and password. After validating the password you will want to call the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QSYRLSPH.htm”>Release Profile Handle API QSYRLSPH</a>. Bruce Vining <a href=”http://www.brucevining.com/”>http://www.brucevining.com/</a>
View Answer
| February 14, 2008 2:51 PM
AS/400, AS/400 security, Password authentication
MYSQL/PHP based CMS (Mambo,Joomla) on the 400.
It should work. Erwin L. Early will be covering it this year at COMMON. I will look around and see what I can find out.
View Answer
| February 14, 2008 12:46 AM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
It should work. Erwin L. Early will be covering it this year at COMMON. I will look around and see what I can find out.
View Answer
| February 14, 2008 12:46 AM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
Ultimate Cleaner problem
Boot the computer into Safe-Mode and run those programs again. Check you services and make sure any references of Ultimate Cleaner are disabled. Also go into your startup with by typing ‘msconfig’ at your Run prompt. Look for anything related to Ultimate Cleaner and uncheck it. Now delete any directories and files associated with the [...]
View Answer
| February 13, 2008 2:25 PM
Antivirus, Viruses
Boot the computer into Safe-Mode and run those programs again. Check you services and make sure any references of Ultimate Cleaner are disabled. Also go into your startup with by typing ‘msconfig’ at your Run prompt. Look for anything related to Ultimate Cleaner and uncheck it. Now delete any directories and files associated with the [...]
View Answer
| February 13, 2008 2:25 PM
Antivirus, Viruses
Forget Administrator Password
1. This will help you reset the admin password. http://www.lostpassword.com/windows.htm <a href=”http://www.asktheadmin.com/2007/06/recover-windows-xp-2000-2003-and-nt.html”><b>($45!!! No way! Here is a program that does the same thing for FREE!)</a></b><b> 2. No, you cannot restrict users from dropping files of a specific type of file into a folder. (again I hate to disagree but of course you can!) To restrict [...]
View Answer
| February 11, 2008 8:38 PM
Security, Windows XP
1. This will help you reset the admin password. http://www.lostpassword.com/windows.htm <a href=”http://www.asktheadmin.com/2007/06/recover-windows-xp-2000-2003-and-nt.html”><b>($45!!! No way! Here is a program that does the same thing for FREE!)</a></b><b> 2. No, you cannot restrict users from dropping files of a specific type of file into a folder. (again I hate to disagree but of course you can!) To restrict [...]
View Answer
| February 11, 2008 8:38 PM
Security, Windows XP
nnnlifc.dll
Hi Randy, NNLIFC.DLL is NOT a virus it is a dynamic link library and does not appear in any virus reference manual. If your antivirus is reporting an issue what is the virus name that is showing up? Have you run the safety.live.com or a hijack this scan? Can you post the results so i [...]
View Answer
| February 11, 2008 8:26 PM
Virus protection services
Hi Randy, NNLIFC.DLL is NOT a virus it is a dynamic link library and does not appear in any virus reference manual. If your antivirus is reporting an issue what is the virus name that is showing up? Have you run the safety.live.com or a hijack this scan? Can you post the results so i [...]
View Answer
| February 11, 2008 8:26 PM
Virus protection services
pix 515E firewall inside traffic monitoring and controll
If you want to filter p2p, you can do this either on the router or on the pix. I answered how this is done on a router, <a href=”http://itknowledgeexchange.techtarget.com/itanswers/limiting-bandwidth-for-streaming-online-audiovideo/”>here</a> To do this on a pix is a bit differen. you’ll need to tell us what version of the pix os you have ( do the [...]
View Answer
| February 11, 2008 4:53 PM
Firewalls, PIX 515E, Routers
If you want to filter p2p, you can do this either on the router or on the pix. I answered how this is done on a router, <a href=”http://itknowledgeexchange.techtarget.com/itanswers/limiting-bandwidth-for-streaming-online-audiovideo/”>here</a> To do this on a pix is a bit differen. you’ll need to tell us what version of the pix os you have ( do the [...]
View Answer
| February 11, 2008 4:53 PM
Firewalls, PIX 515E, Routers
Traffic monitoring on SUSE 10.1/Nagios
You can set up flow monitoring. <a href=”http://www.ntop.org”>NTOP </a>would be a good open source choice. It will give you monthly/daily/hourly/etc reports of all the traffic coming through it. You can see what protocols, what destinations and what source ip addresses are involved. NTOP consists of two parts. There’s a collector and a sensor. The collector [...]
View Answer
| February 11, 2008 3:47 PM
DataCenter, Development, Firewalls, Nagios, Network security, Servers, SUSE Linux Enterprise Server
You can set up flow monitoring. <a href=”http://www.ntop.org”>NTOP </a>would be a good open source choice. It will give you monthly/daily/hourly/etc reports of all the traffic coming through it. You can see what protocols, what destinations and what source ip addresses are involved. NTOP consists of two parts. There’s a collector and a sensor. The collector [...]
View Answer
| February 11, 2008 3:47 PM
DataCenter, Development, Firewalls, Nagios, Network security, Servers, SUSE Linux Enterprise Server
wireless security cameras
I have 4 dlink DCS 5300g cameras in place: 3 outside and 1 inside. They support pan & scan, motion, optional infrared; attach either wired or 802.11g wireless Dlink also has a feree monitor/playback package called IP-Surveillance. Easy to set up, nice gui. I have been pretty appy with everything
View Answer
| February 11, 2008 2:31 PM
Physical security, Security, Security Cameras
I have 4 dlink DCS 5300g cameras in place: 3 outside and 1 inside. They support pan & scan, motion, optional infrared; attach either wired or 802.11g wireless Dlink also has a feree monitor/playback package called IP-Surveillance. Easy to set up, nice gui. I have been pretty appy with everything
View Answer
| February 11, 2008 2:31 PM
Physical security, Security, Security Cameras
downloading security updates
These utilities typically update themselves automatically. Upon performing a cursory review, I did not see a highly advertised area to download updaes from manually. In light of this, there are a few things that you can try: 1. Lavasoft Ad-aware appears to store its updates in C:Documents and SettingsAll UsersApplication DataLavasoftAd-Aware 2007updatenew 1-2. You can [...]
View Answer
| February 10, 2008 6:03 AM
Security updates
These utilities typically update themselves automatically. Upon performing a cursory review, I did not see a highly advertised area to download updaes from manually. In light of this, there are a few things that you can try: 1. Lavasoft Ad-aware appears to store its updates in C:Documents and SettingsAll UsersApplication DataLavasoftAd-Aware 2007updatenew 1-2. You can [...]
View Answer
| February 10, 2008 6:03 AM
Security updates
Problem Between Windows Live OneCare and McAfee Total Protection
Having both of these program sounds like overkill. McAfee enterprise 8 has all the features you need to block spyware, viruses and restrict ports. If you need something more inclusive find a single package and dont double up on the same system. A lot of times this is in fact what causes the issue. Uninstall [...]
View Answer
| February 8, 2008 9:25 PM
Antivirus, McAfee Security Center, McAfee Total Protection, Windows Live OneCare
Having both of these program sounds like overkill. McAfee enterprise 8 has all the features you need to block spyware, viruses and restrict ports. If you need something more inclusive find a single package and dont double up on the same system. A lot of times this is in fact what causes the issue. Uninstall [...]
View Answer
| February 8, 2008 9:25 PM
Antivirus, McAfee Security Center, McAfee Total Protection, Windows Live OneCare
Symantec Anti Virus Corporate 8.0 issue
I had the same problem today and I have found the solution with a kind of trick. Do this; Just copy everything in “C:Program FilesCommon FilesInstallShield” from a good working XP PC into the same path of the PC with that problem and start the uninstall process again and see it is working. At least [...]
View Answer
| February 8, 2008 3:41 PM
backdoors, Current threats, Firewalls, Forensics, Hacking, Help Desk, human factors, Incident response, Installation, Intrusion management, Network security, Norton, Security, Spyware, Symantec, Tech support, Third-party services, Trojans, Viruses, VPN, Wireless, worms
I had the same problem today and I have found the solution with a kind of trick. Do this; Just copy everything in “C:Program FilesCommon FilesInstallShield” from a good working XP PC into the same path of the PC with that problem and start the uninstall process again and see it is working. At least [...]
View Answer
| February 8, 2008 3:41 PM
backdoors, Current threats, Firewalls, Forensics, Hacking, Help Desk, human factors, Incident response, Installation, Intrusion management, Network security, Norton, Security, Spyware, Symantec, Tech support, Third-party services, Trojans, Viruses, VPN, Wireless, worms
IPSec Tunnel
You’ll need to modify the edge PIX to allow secure traffic to pass though it. I think the command is something like service permit ipsec(?). Also make sure to have nat-traversal enabled ( I think service nat-t) and turn off the fixup for IKE if you have it.
View Answer
| February 8, 2008 12:01 AM
ASA, IPsec
You’ll need to modify the edge PIX to allow secure traffic to pass though it. I think the command is something like service permit ipsec(?). Also make sure to have nat-traversal enabled ( I think service nat-t) and turn off the fixup for IKE if you have it.
View Answer
| February 8, 2008 12:01 AM
ASA, IPsec
SMTP transmission failure has occurred using Exchange 2003 and Trend Micro IMSS
Each session is limited to 500 messages. The easy way to “solve” this is to increase your maximum. I don’t really recommend this. Instead follow the advice in this discussion and the MSKB article here. Also double check to make sure you exclude the proper directories from your AV here and here.
View Answer
| June 14, 2013 11:23 PM
Exchange 2003, IMSS, SMTP
Each session is limited to 500 messages. The easy way to “solve” this is to increase your maximum. I don’t really recommend this. Instead follow the advice in this discussion and the MSKB article here. Also double check to make sure you exclude the proper directories from your AV here and here.
View Answer
| June 14, 2013 11:23 PM
Exchange 2003, IMSS, SMTP
Specific site access issues with Java Runtime 6 through proxy
If I understand it correctly, 17 out of 19 don’t have a problem. First make sure you have the latest IE/OS patches Make sure you’ve set up the jre proxy correctly <a href=”http://java.com/en/download/help/proxy_setup.xml”>here</a> Next determine where your jvm is trying to connect use “netstat -vb” Some IE versions don’t pass their proxy info back to [...]
View Answer
| February 7, 2008 10:12 PM
Desktops, DNS, Java, Proxy servers
If I understand it correctly, 17 out of 19 don’t have a problem. First make sure you have the latest IE/OS patches Make sure you’ve set up the jre proxy correctly <a href=”http://java.com/en/download/help/proxy_setup.xml”>here</a> Next determine where your jvm is trying to connect use “netstat -vb” Some IE versions don’t pass their proxy info back to [...]
View Answer
| February 7, 2008 10:12 PM
Desktops, DNS, Java, Proxy servers
