May 28, 2011

FTP Problems in Virtuozzo Servers

Windows General,

When connecting to VPS via FTP( Say File zilla ) which results in Could not connect to server. But the settings will be perfect. You check with server FTP settings, Permissions, ports, FTP modes etc and see everything is fine to avoid FTP Problems in Virtuozzo.

Read more
May 28, 2011

Shrink 2008 MSSQL database

Database,

Shrinking SQL 2008 database is nowhere related to SQL 2000/2005 Method. Because SQL Server 2008 no longer allows you to truncate the transaction log using the no_log syntax But here is the special code to shrink the database:

Read more
May 28, 2011

SQL Server Port

Database,

After completing a fresh SQL installation and opening the required port in the firewall, you might still be unable to connect through SQL Management Studio. However, it’s important to note that installing SQL Server and opening the firewall port alone

Read more
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

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.

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 =

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".

Read more
May 28, 2011

When I open File Manager I get “Operation failed” error.

Plesk,

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.

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.

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.

Read more