Tuesday, October 05, 2010

How to Add Inbound/Outbound Rule to specific port on Windows 2008 Firewall with Advanced Security

Windows Server 2008 has enhanced the firewall security to have more functions!

  • New Interface (MMC Snap-in) to configure the firewall
  • Ability to filter inbound and outbound traffic
  • Firewall can work together with IPSEC encryption configuration much better
  • Ability to create firewall rules (exception) for Windows AD Group, Protocol number, TCP/UDP Port, interface, IPv6 traffic and ICMP

Thursday, August 26, 2010

SpeedFan - A tool to change your CPU Fan's Speed

SpeedFan is a free tool (made by Alfredo Milani Comparetti) that helps you to

  • change your computer's fan speeds

  • read the temperatures of your motherboard and your hard disk,

  • read voltages and fan speeds and

  • check the status of your hard disk using S.M.A.R.T. or SCSI attributes


It is fully configurable and you can create custom events to handle every situation in an automated way. SpeedFan works under Windows 9x, ME, NT, 2000, 2003, XP, Vista and Windows 7. SpeedFan works fine on 64 bit too.


Speedfan can be downloaded from Alfredo's website (http://www.almico.com/sfdownload.php)

Friday, July 16, 2010

Windows 2008 R2 and SQL Server 2008 R2 - DTC

First of all, I hit a Distributed Transaction Coordinator issue with my .NET application after deployed it on the network. The OS in client machine is Windows 7, and server machine is running on Windows 2008 R2 64 bit and SQL Server 2008 R2.

The error below would prompt once the client machine attempting to access database server machine:

The partner transaction manager has disabled its support for remote/network transaction.

I found out the cause is incorrect network access in component services on the servers. The network access of DTC in all servers should be enabled

Following is the procedure to enable it on Windows Server 2008 R2
  1. Click Start, click Run, type dcomcnfg and then click OK to open Component Services.

  2. In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator and then click Local DTC.

  3. Right click Local DTC and click Properties to display the Local DTC Properties dialog box.

  4. Click the Security tab.

  5. Set the following options on the Security tab of the Local DTC Properties dialog box and click OK



  6. Open the Control Panel, open Windows Firewall, and click Change settings to display Windows Firewall Settings.

  7. Click the Exceptions tab.

  8. Check the box for Distributed Transaction Coordinator and click OK.

Sunday, July 11, 2010

Use CoreTemp to check DTS (Digital Temperature Signal)

Don't underestimate overheating problem with your laptop/PC. Your computer would probably end up restarting itself, hang, white screen or shutting down!

I started worrying about my laptop, Dell Studio 15 when it's hang with white screen. Oh, yeah I didn't turn it off for a week and quite overheating...So, let's find out what the actually problem is causing it. My first shot would be installing temperature reading software, and I decide to use Core Temp.

Core Temp is a handy tool which is tiny and extremely accurate. Intel and AMD’s new technology known as DTS(Digital Temperature Signal) let these applications help monitor the temperature accurately.

See screen shot for example, need to shut down the laptop once the temperature reaches 49-50 degree




Core Temp lets you monitor Intel "Core Duo", "Core Solo", "Core 2 Duo", "Core 2 Solo", "Core 2 Quad", " Pentium", "Core i3", "Core i5", "Core i7", "Core i9", series, "Celeron" series (Conroe/Merom architecture and newer), "Xeon 3000/3200/5100/5300/5400/5500/5600/6500/7400/7500/7600" series (Woodcrest, Clovertown, Harpertown, Dunnington and Nehalem based architecture).
All AMD Phenom II, Athlon II, Phenom, Athlon, Opteron, Sempron, Turion II and Turion series series die temperature.

The temperature readings are very accurate as the data is collected from a Digital Thermal Sensor (or DTS) which is located in each individual processing core, near the hottest part. This sensor is digital, which means it doesn't rely on an external circuit located on the motherboard to report temperature, its value is stored in a special register in the processor so any software can access and read it. This eliminates any inaccuracy that can be caused by external motherboard circuits and sensors and then different types of programs trying to read those sensors.


This is how the program works:

Intel defines a certain Tjunction temperature for the processor. This value is usually in the range between 85°C and 105°C. In the later generation of processors, starting with Nehalem, the exact Tjunction Max value is available for software to read in an MSR (short for Model Specific Register).
A different MSR contains the temperature data. The data is represented as a Delta in °C between current temperature and Tjunction.

So the actual temperature is calculated like this 'Core Temp = Tjunction - Delta'

The size of the data field is 7 bits. This means a Delta of 0 - 127°C can be reported in theory. In fact the reported temperature can rarily go below 0°C and in some cases (Core 2 - 45nm series) temperatures below 30° or even 40°C are not reported.

--------------------------------------------------------------------------------

AMD processors report the temperature via a special register in the CPU's northbridge. Core Temp reads the value from the register and uses a formula provided by AMD to calculate the current temperature.
The formula for the Athlon 64 series, early Opterons and Semprons (K8 architecture) is: 'Core Temp = Value - 49'.
For the newer generation of AMD processors like Phenom, Phenom II, newew Athlons, Semprons and Opterons (K10 architecture), and their derivatives, there is a differnt formula: 'CPU Temp* = Value / 8'.

The sensor in AMD CPUs can report temperatures between -49C and 206C.

*CPU Temp is because the Phenom\Opteron (K10) have only one sensor per package, meaning there is only one reading per processor.

Friday, July 09, 2010

Webservice Extension on IIS7 Windows Server 2008 R2

I hit a classic 404 error today.

The 404 error occurs if the Web Service Extensions - Active Server Pages are Prohibited or the ASP.Net v2.0.50727 is set to Prohibited

I just realized that on IIS6 there is a smart node for Web Services Extensions to setup ASP .NET, however this disappeared when I looked at IIS 7 which a default package on Windows Server 2008 R2.



After a few minutes, I found it has another name called 'ISAPI and CGI Restrictions'
Lastly, here's the tips on how to get the ASP .NET installed quickly :)

Go to command prompt and type aspnet_regiis.exe i

Wednesday, July 07, 2010

TRUSTWORTHY SQL Database Property

I frequently come accross with Trustworthy issue when moving database from one server to another server. Enabling Trustworthy will elevate the impersonation of security.

TRUSTWORTHY { ON OFF }
ON
Database modules (for example, user-defined functions or stored procedures) that use an impersonation context can access resources outside the database.
OFF
Database modules in an impersonation context cannot access resources outside the database.
TRUSTWORTHY is set to OFF whenever the database is attached.

In SQL 2008 and SQL 2000, By default, all system databases except the msdb database have TRUSTWORTHY set to OFF.

That's the background why we may receive an error message when trying to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server

Read more information at http://support.microsoft.com/kb/918040

The value cannot be changed for the model and tempdb databases. We recommend that you never set the TRUSTWORTHY option to ON for the master database.

To set this option, we must be a member of the sysadmin fixed server role.

The status of this option can be determined by examining the is_trustworthy_on column in the sys.databases catalog view.

For example:
ALTER DATABASE AdventureWorks2008R2 SET TRUSTWORTHY ON; .

Tuesday, June 15, 2010

SQL Server 2008 R2

We don't need to argue that Microsoft SQL Server technology is a leading database information system.

I discovered some cool resources relevant about SQL stuff today.


Professional Association for SQL Server
http://www.sqlpass.org/Community.aspx

Data Warehousing
http://www.microsoft.com/sqlserver/2008/en/us/fasttrack.aspx

Master Data Services
http://www.microsoft.com/sqlserver/2008/en/us/MDS.aspx

PowerPivot
http://www.powerpivot.com/

SQL Server 2008 R2 Update
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d