How to Edit DNS Zone in WHM

* Login into WHM
* Click on DNS Functions
* Click on Edit DNS Zone
* Select the Domain Name and Click on Edit button
* To Create A Record enter the following Entry under Add New Entries Below this Line Text boxes

yourdomain.com. A xx.xx.xx.xx

Here xx.xx.xx.xx is IP address.  Also please do not forget to place dot (.) after domain name.

* To Create MX Record enter the following Entry under Add New Entries Below this Line Text boxes

yourdomain.com. MX mail.yourdomain.com. (Put the MX record which your Hosting Company updates you)

Please do not forget to place dot (.) after domain name.

* To Create CNAME Record enter the following Entry under Add New Entries Below this Line Text boxes

any-name CNAME yourdomain.com. (Put the MX record which your Hosting Company updates you)

Please do not forget to place dot (.) after domain name.

SQL Server 2005 Features Comparison

Workgroup Edition

Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. Workgroup Edition can serve as a front-end Web server or for departmental or branch office operations. It includes the core database features of the SQL Server 2005 product line.

Standard Edition

Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for non-critical e-commerce, data warehousing, and line-of-business solutions. Standard Edition’s integrated business intelligence and high-availability features provide organizations with the essential capabilities needed to support their operations.

Enterprise Edition

Enterprise Edition scales to the performance levels required to support enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. With comprehensive business intelligence, robust analytics capabilities and high-availability features such as failover clustering and database mirroring, SQL Server Enterprise can handle the most critical enterprise workloads.

For additional help choosing the optimal edition for your particular business situation, please refer to the Microsoft SQL Site.

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

How to increase file upload limit in asp.net

If you are using ASP.NET than there is a 4 MB cap by default and you can change this cap by editing your web.config

<httpRuntime executionTimeout=”1800″ maxRequestLength=”400000″ />

This allows 400 MB file upload.

How to change/update email id password in DNP

* Login into DNP Control Panel
* Click on User Spaces Name
* Click on Mail -> Accounts
* Click on Your Mail Account Name
* Enter password, Mailbox Size Limit and another details (optional)
* Click on Change Password Check Box
* Click on Save

How to add SPF record from WHM on a Linux Cpanel Server

Please refer to this to understand what is SPF: http://openspf.org

If you are an advanced user you can follow the steps given at the following link and that should help you in setting up a SPF

http://old.openspf.org/wizard.html

Once you know what SPF record you need to enter into your dns zone, please login to WHM. Go to DNS Functions, Edit DNS Zone. Select the zone to edit, and click the Edit button.

You’ll have to edit the dns zone. On this page, when adding spf record for the first time, add the new record below the line which says:

Add New Entries Below this Line

The first text field will contain your domain name with a terminating dot i.e. example.com.

Leave the number as it is in next field. After IN, select TXT from the drop down. In the next text field, add the SPF record with quotation marks e.g.

“v=spf1 a ~all”

That’s it, click Save button and allow a couple of hours for dns propagation.

WIPL Provides web hosting in india with proper SPF record setup to avoid common DNS problems. We also provide Windows Web Hosting in India & Linux Web Hosting in India with pre configured SPF Records.

Connection String for PHP-MSSQL

<?
/*
PHP MSSQL Example

Replace data_source_name with the name of your data source.
Replace database_username and database_password
with the SQL Server database username and password.
*/

$data_source=’mssql.dnsracks.com,1533′;
$user=’database_user_name’;
$password=’database_password’;

// Connect to the data source and get a handle for that connection.
$conn=mssql_connect($data_source,$user,$password);
if (!$conn){
if (phpversion() < ‘4.0′){
exit(”Connection Failed: . $php_errormsg” );
}
else{
exit(”Connection Failed:” . errormsg() );
}
}

?>

***********************************************************************************************************

ODBC

<?
/*
PHP MSSQL Example

Replace data_source_name with the name of your data source.
Replace database_username and database_password
with the SQL Server database username and password.
*/

$data_source=’dns_name’;
$user=’database_user_name’;
$password=’database_password’;

// Connect to the data source and get a handle for that connection.
$conn=odbc_connect($data_source,$user,$password);
if (!$conn){
if (phpversion() < ‘4.0′){
exit(”Connection Failed: . $php_errormsg” );
}
else{
exit(”Connection Failed:” . odbc_errormsg() );
}
}

// Disconnect the database from the database handle.
odbc_close($conn);
?>

For MSSQL 2005
data_source = 74.86.116.10,1433

For MSSQL 2008
data_source = 72.18.135.197,1433

Connection Strings For MSSQL 2008 Database

Data Source=72.18.135.197,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Secure your Wi-Fi Network

You can Secure your Wi-Fi Network just by doing the 9 following simple steps:

• Change the default password of Modem/Router
• Disable the DHCP Service
• Change the default SSID
• Opt for WAP2 or PSK Security
• Enable the MAC Filter
• Disable the Remote Administration
• Use the router’s Firewall
• Switch of the router when not is use
• Position your Router Carefully