May 28, 2011
Backup all MSSQL databases
Linux General,You can use the below stps to backup all your mssql database at ease. We at actsupport, provide backup solution. 1. Log into your server through Remote Desktop Connection. 2. Open SQL Server Management Studio and select the server name 3. Click the New Query button and enter in the following data: DECLARE @name VARCHAR(50)…
Read more
May 28, 2011
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection Error when binding MSSQL database with plesk 10
Plesk,Connection to a named instance of SQL server 2005/2008 should be made using the format ‘VirtualServer\Instancename’. if the IP address of a machine running a named SQL server instance (ONE)is 192.141.128.140, you can connect to the named instance using 192.141.128.140\ONE for the servername. To avoid a client app from using the above convention for a…
Read more
May 28, 2011
MSSQL – Enabling “Service Broker protocol” for a DB
Windows General,To determine whether or not Service Broker is enabled for a particular database, execute the following T-SQL: SELECT is_broker_enabled FROM sys.databases WHERE name = ‘Database name’; — Enable Service Broker: ALTER DATABASE [Database Name] SET ENABLE_BROKER; — Disable Service Broker: ALTER DATABASE [Database Name] SET DISABLE_BROKER; Database Mirroring will be enabled after installing Service Pack…
Read more
May 28, 2011
Event viewer error message “Metabase Key 7041 is out of range. using 1 as default”
Windows General,When you access a website in Event viewer there is a error message "Metabase Key 7041 is out of range. using 1 as default". Metabase Key 7041 - AspExecuteInMTA AspExecuteInMTA Metabase Property(ASP pages to run on multithreaded apartment (MTA) threads instead of single-threaded apartment (STA) threads. Analysis If your COM components are primarily free-threaded or…
Read more
May 28, 2011
When I open File Manager I get “Operation failed” error.
Plesk,Symptoms When I open File Manager I am getting the following error:FileList::init() failed: ls_dir_wrapper() failed: Unable to logon user (PLESK900W2K3\USER1): (1326) Logon failure: unknown user name or bad password. ———————- Debug Info ——————————- 0: plib\ui_common\FileManagerUIPointer.php:709 FileManagerUIPointer->accessItem(string ‘GET’, NULL null) 1: plib\ui\client.domain.hosting.file-manager.php:86 plesk__client__domain__hosting__file_manager->accessItem(string ‘GET’, NULL null) 2: plib\UIPointer.php:599 UIPointer->access(string ‘GET’) 3: htdocs\plesk.php:42 Resolution Make sure that…
Read more
May 28, 2011
Common Errors and Fixes in IIS and its applications
Windows General,Service Unavailable: If you face the error ‘Service unavailable’ while accessing the domains in the browser. Cause: Application pool gets stopped for that domain. Fix: In this case you have to to start or restart the application pool belongs to that domain. If you are undable to start the applicaton poll and if you get…
Read more
May 7, 2011
Steps to install SQL server 2008 with screenshot
Database,Windows General,Microsoft SQL Server 2008 Release to Manufacturing (RTM) was released in the August 2008. There are different versions of SQL Server 2008 available such as Enterprise, Standard, Workgroup, Web, Express, Compact and Developer editions. The trial version of Microsoft SQL Server 2008 can be downloaded from the following link http://www.microsoft.com/sql/2008/prodinfo/download.mspx. This article describes the steps…
Read more
June 16, 2010
Using wildcard subdomains in Plesk
Plesk,In some situations, you may want to have domain.com as well as *.domain.com point to the same site in Plesk. Plesk will automatically set up hosting for domain.com and www.domain.com within the Apache configuration, but you can direct all subdomains for a particular domain to a certain virtual host fairly easily. DNS Configuration: Add a…
Read more
June 16, 2010
How to enable more than 4GB RAM support on Linux 32bit servers?
Linux General,# uname -r 2.6.18-8.1.3.el5 # yum info kernel-PAE Available Packages Name : kernel-PAE Summary: The Linux kernel compiled for PAE capable machines. Description: This package includes a version of the Linux kernel with support for up to 64GB of high memory. It requires a CPU with Physical Address Extensions (PAE). The non-PAE kernel can only…
Read more
May 19, 2010
FFMPEG Installation
Linux General,FFMPEG and it’s related modules Installation through Script: Details:All FFmpeg packages are installed from source except codecs. The main dependency for installing ffmpeg is: yum Ffmpeg installation will only work on redhat and suse (requires yum) distributions. FFmpeg installation will work in cpanel and plesk servers.How to run:Wget the above script to /usr/src…
Read more
