Search Chirayu Software Solutions Blog

Saturday, July 26, 2014

Remove unwanted ads in all sites in Mozilla Firefox

The Reset Firefox feature can fix many issues by restoring Firefox to its factory default state while saving your essential information. Note: This will cause you to lose any Extensions, Open websites, and some Preferences.
To Reset Firefox do the following:
  1. Go to Firefox > Help > Troubleshooting Information.
  2. Click the "Reset Firefox" button.
  3. Firefox will close and reset. After Firefox is done, it will show a window with the information that is imported. Click Finish.
  4. Firefox will open with all factory defaults applied.

Further information can be found in the Reset Firefox – easily fix most problems article.
Did this fix your problems? Please report back to us!

Thursday, July 17, 2014

To Attach a Database File using sqlcmd command prompt

To Attach a Database File

  1. Open the command prompt on the server.
  2. From the command prompt, connect to an instance of SQL Server by using the following sqlcmd command:
    sqlcmd -S Server\Instance
    Where Server is the name of the computer and Instance is the name of the instance.
  3. When connected, type the following commands:
    USE [master]
    CREATE DATABASE [database_name] ON 
    ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.mdf' ),
    ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\<database name>.ldf' )
    Where database_name is the name of the database you want to attach, FileName is the path and filename of the database file and the log file, and FOR ATTACH specifies that the database is created by attaching an existing set of operating system files.
  4. To verify that the database has been attached, type the following two commands:
    select name from sys.databases

Wednesday, July 16, 2014

Speedup Excel or Word if it is opening or closing slowly


  1. Click the Microsoft Office Button Button image, click Excel Options, and then click Add-Ins.
  2. In the Add-ins box, identify the add-in that you want to enable or disable and note the Add-in type located in the Type column.
  3. Select the Add-in type in the Manage box and then click Go.
  4. Select or clear the check box for the Add-in that you want enable or disable and then click OK.


  1. Click the Microsoft Office Button Button image, and then click Word Options.
  2. Click Trust Center, click Trust Center Settings, and then click Add-ins.
  3. Click the options that you want. These settings are not selected by default unless you work in an organization and your information technology (IT) administrator changed the defaults by using an administrator policy.
    • Require Application Add-ins to be signed by Trusted Publisher Select this option if you want the Trust Center to check for a digital signature on the dynamic-link library (.dll) file that contains the add-in. If the publisher has not been trusted, the Office program does not load the add-in, and the Message Bar displays a notification that the add-in has been disabled.
    • Disable notification for unsigned add-ins (code will remain disabled) This check box is available only if you select the Require Application Extensions to be signed by Trusted Publisher check box. In some situations, the dynamic-link library (.dll) file that contains the add-in might be unsigned. In these cases, add-ins signed by a trusted publisher are enabled, but unsigned add-ins are disabled silently.
    • Disable all Application Add-ins (may impair functionality) Select this check box if you don't trust any add-ins. All add-ins are disabled without any notification, and the other add-in check boxes are made unavailable.

Saturday, July 12, 2014


In this post, we’ll show you how to install PHP and MySQL on a Windows Server 2012 cloud VPS server. This assumes a fresh server build or a server without IIS, MySQL, and PHP already installed.
A popular utility for installing PHP and MySQL applications, among various other tools on Windows machines is the Microsoft Web Platform Installer, or WebPI. While the installation of PHP and MySQL is greatly simplified using this utility, WebPI does not provide the most recent versions of PHP and MySQL. If you run older versions of any software package or utility you are vulnerable to any performance and security issues that are patched or improved upon in newer versions. With WebPI you can only install up to PHP version 5.5.3 (released 7/30/2012), which is several revisions back. Likewise, MySQL version is 5.5. We will be installing the most recent components available, PHP5.5.7 and MySQL Community Edition 5.6.15.
WebPI 1
WebPI 2
Again, it cannot be understated how great a value the WebPI provides; however, to achieve the most up to date versions, we’ll have to do this manually. Plus, you will learn a great deal about IIS, PHP, and even MySQL during the setup and configuration manually. Let’s get started!
Install IIS
Launch Server Manager, and then click “Add roles and features“. Proceed through the wizard selecting Role based installation and selecting your server. In the “Server Roles” section of the wizard, you’ll want to be sure you have ASP.NET 3.5 and CGI components installed. Make any other selections you need for your web server and then finish the wizard.
IIS Role
When completed, restart your computer to finish the installation, then we continue to installing PHP.
Install PHP
First we need to install Visual C++ Redistributable for VS 2012 U4, make sure to select the x86 version. Download the file direct from Microsoft here, then install. If you choose not do this, you will get an error when trying to start php later. There is a dependency on MSVCR110.dll and php-cgi.exe will fail to launch. Pics, because it happens:
dll error
Now, download the latest version of PHP (5.5.7 at the time of this writing), the x64 versions are experimental only, so we’ll go with x86 Non-Thread Safe. Why Non-Thread safe? Explanationhere you will also see an explanation on the left hand margin of the download site here:
For your convenience, here is a direct link to version we need:
When the download completes, right-click on the folder and “Extract All…” to the following location “c:\php”.
PHP extract
Next, copy “c:\php\php.ini-production” to “c:\php\php.ini”. Then we need to edit the php.ini to configure a few items so that PHP will run proper on our server. See this post here on the PHP site. You need to look in the “Required directives” section and make changes to your php.ini file accordingly.
Specifically these items:
extension_dir = "path to extension directory" (should be c:\php\ext)
extension = xxxxx.dll (you need to enable any extensions you want to use in the file)
log_errors = On
error_log = "path to the error log file" (usually "C:\inetpub\temp\php-errors.log")
cgi.force_redirect = 0 (required for running under IIS)
cgi.fix_pathinfo = 1 (FastCGI needs this set)
fastcgi.impersonate = 1 (FastCGI under IIS (on WINNT based OS) supports the ability to impersonate security tokens of the calling client. Set to 1 if running under IIS.)
fastcgi.logging = 0 (causes IIS to generate an HTTP 500 exception if enabled)
Also, you should look over the “Optional directives” such as “memory_limit” and “upload_max_filesize” and make any adjustments there. For example if you are going to be running ownCloud, you’ll probably want to increase the upload size to a higher threshold.
Once you have setup your php.ini file to your liking, I highly recommend copying you php.ini file for backup purposes, naming it “php.ini.backup” or something of the sort. I also recommend repeating this procedure anytime you make a change to your .ini file and perhaps adding the date to keep historical reference to any changes made to the file.
Now we need to configure the system variable for php. Access Control Panel > System > Advanced System Settings, Advanced tab, Environmental Variables.
Env Var 1
Edit the “Path” variable and add “c:\php” to the end of the value listing.
Env Var 2
Now we need to setup the Handler Mapping in IIS Manager. Launch Handler Mapping, click Add Module Mapping in the Action panel. Use this screenshot as a guide here:
Add Module Mapping
Now we need to launch the Default Document setting in IIS manager, and then create a phpinfo page. In the Default Document module click “Add…” then specify default.php.
Default Doc
To create the phpinfo page, create a file here: “c:\inetpub\wwwroot\phpinfo.php”. Inside that file, place this text, exactly:
<?php phpinfo(); ?>
Now issue an IIS reset, then browse this page here on your server:
Your screen should look something like this:
phpinfo page
To make life a little easier for managing PHP on IIS, you can also install PHP Manager for IIS from codeplex. In fact, I highly recommend it. It will advise if you have any potential issues with you php.ini file and even give you suggestions on resolving them.
Note – This requires that you have .NET 3.5 Framework installed.
PHP Manager
If you are unable to see the PHP Manager applet in IIS Manager after installation, your server may have a pending reboot. This is usually caused by not rebooting after installing ASP.NET 3.5 earlier in the process.
At this point your PHP installation is complete! Let’s move on to MySQL.
Install MySQL
This part of the guide is perhaps the easiest. Download the latest community server, the downloads page is here:
For your convenience, the direct download link to latest version as of this writing is here:
Once downloaded, launch the installer and begin the installation. It is very straightforward. I recommend installing MySQL Workbench to manage your MySQL database locally via the application. Some people do not recommend this; however the choice is up to you.
I chose a custom installation:
mysql 1
I chose to install the server and workbench:
mysql 2
You will most likely have to install another Visual C++ component here. Do so and continue with the installation.
mysql 3
Continue to follow the wizard, complete the server installation on the next page. On the page after the installation, you’ll have the option to configure the firewall rule and select the configuration type. If you are installing IIS, PHP, and MySQL, most likely you will want to choose the Server machine config. If you are running MySQL standalone, Dedicated would be a better fit.
mysql 4
On the next page, set a root password. Make extra sure you have this password documented properas you will need this password later. Then on the following page, make sure you configure MySQL to run at startup. Also if the service needs to run as a dedicated user, configure that here.
mysql 5
On the next page, configure the logging to your preferences and then complete the wizard. If you chose to install MySQL workbench it will launch after installation and you are ready to manage your server!
mysql 6
At this time I would recommend performing a computer restart, and then running Windows Update to ensure you have all the proper security patches up to date.
This completes our guide on the installation of IIS, PHP, and MySQL. Thanks for reading.
Want to try this out on Windows cloud VPS hosting? Here are our Windows VPS plans and prices. Signup now and be online in just a few minutes!