Mssql management studio issues – DB in general
Database,Error while opening Mssql 2005 management studio MMC could not create the snap-in.MMC could not create the snap-in. The snap-in might not have been installed correctly.Name: Microsoft SQL Enterprise ManagerCLSID: {00100100-1816-11D0-8EF5-00AA0062C58F} Fix Run the following command as shown to fix this. Make sure you have installed the Msql in the path as shown or change…
Read moreProblem with webmail
Windows General,Webmail is not working Cause – I 1. Make sure the IME_ADMIN and IME_USER are having permission for the webmail folder. IME_ADMIN should have full control. 2. If still there are problems, change the webmail’s application pool -> prop -> change to user / network service. 3. Make sure mail enable /Plesk DNS services are…
Read moreProblem in starting Plesk name server service
Plesk,If the Plesk name service could not start in the server. Then there could be a duplicate entry in the named.conf file Location of named.conf file c:\program files\ swsoft \ plesk \ dns\ var\ named.conf Solution 1. Backup the named.conf file 2. Check for duplicate domain entries 3. Remove one duplicate entry and save the…
Read moreProblem with Webshell (page not found error)
Windows General,ERROR: Warning: Invalid argument supplied for foreach() in C:\Program Files\HSphere\3rdparty\WebShell4\includes\functions.php on line 768 Webshell link not opening from H-sphere control panel. ex: H-sphere -> user / reseller -> File manager / FTP manager -> Webshell -> login -> Page not found error Solution: Goto server -> IIS -> Default site -> properties -> Advanced ->…
Read moreH-sphere – VPS – GENERIC ERROR
Virtualization,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 moreEnable 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 moreWindows 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 moreFTP 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 moreShrink 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: USE MASTER GO ALTER DATABASE database_name SET RECOVERY SIMPLE GO USE database_name GO DBCC SHRINKFILE (database_name_log, 1)…
Read moreSQL Server Port
Database,Scenario 1: SQL Is Not Connecting via Management Studio Locally After a Fresh Installation Step 1: Verify SQL Installation and Firewall Configuration 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…
Read more