Author: actsupp-r0cks

Shrink 2008 MSSQL 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) […]

Continue Reading

SQL Server Port

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 […]

Continue Reading

[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection Error when binding MSSQL database with plesk 10

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 […]

Continue Reading

MSSQL – Enabling “Service Broker protocol” for a DB

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 […]

Continue Reading

Event viewer error message “Metabase Key 7041 is out of range. using 1 as default”

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 […]

Continue Reading

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

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 […]

Continue Reading

Steps to install SQL server 2008 with screenshot

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 […]

Continue Reading