May 28, 2011
H-sphere – VPS – GENERIC ERROR
Hsphere,There is a Generic error while signing up a VPS account FIX 1. Open the user control panel -> Plans -> Temple directory -> Type as “vz/template” without quotes (type the path as per the template folder available in the system) 2. Once this has been done, error free signup is possible.
Read more
May 28, 2011
Enable Audio from remote machine through RDP
Windows General,Here are the steps to follow to enable audio from remote machines in windows: Steps: 1. First check the RDP application has audio enabled Start -> mstsc -> options in RDC application -> Local resources -> Remote computer sound -> choose “Bring to this computer” 2. Edit group policy of the remote machine start -> run -> gepdit.msc -> computer configuration…
Read more
May 28, 2011
Windows Client Experience in Server OS
Windows General,To enable the windows vista/windows 7 experience (theme) in server three things should be considered: 1. Installing Terminal server Role 2. Installing Desktop Experience 3. Modifying Group policy to take effect the theme for the users Installing Terminal server Role: RDC (Remote Desktop Connection) no longer supports desktop ecpereince service for the server. So it is mandatoy that…
Read more
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. Cause of FTP Problems in Virtuozzo After uploading large…
Read more
May 28, 2011
Shrink 2008 MSSQL database
mssql,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: USE MASTER GO ALTER DATABASE database_name SET RECOVERY SIMPLE GO USE database_name GO DBCC SHRINKFILE (database_name_log, 1)…
Read more
May 28, 2011
SQL Server Port
mssql,Scenario 1: SQL is not connecting via Management studio locally after a fresh Installation: 1. After a fresh Installation of SQL and opening the port in the Firewall you may not be able to connect via SQL management studio. Note: Installing SQL and opening the port in Firewall will not listen to the service/port. Its…
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 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
