Month: May 2011

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