Your SQL Server Setup may hang forever when it’s almost at the 99 %!

Consider this scenario, I rebooted several times, disabling my favourite antivirus and still unable to get a clue from all the logs possible. I start looking at my favourite blogs and here I am. Check out if your symptoms match the following. “I am installing SQL Server including reporting services and my setup is getting…

2

SQL Server could not create a subscription for Subscriber ‘ServernameInstanceName’.The value for the @sync_method parameter is not valid

Recently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard —————————— SQL Server could not create a subscription for Subscriber ‘Servername\InstanceName’. —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— The value for the @sync_method parameter is…

1

Upgrade to SQL 2008 from 2005 (cluster) fails with The cluster group ‘SQL GROUP’ could not be moved from node ‘NODENAME1’ to node ‘null’ , 0x8007139F

Problem   We try to upgrade to SQL 2008 from SQL 2005 in a cluster setup and it fails on the Active node with the following error: From the Summary.txt There was an error during the SQL Server upgrade operation. Setup failed to move the failover cluster resource group and bring it online.  To continue…

0

INF: SQL Security – Restricting access to public on server/database objects, its implications and ownership chains

INF: SQL Security – Restricting access to public on server/database objects, its implications and ownership chains There are times when you need to harden the security of your SQL Server and prevent the public/guest users from having access to certain information like server or database level management views. This hardening is required due to company…


Database Mail failing with “The service queue "ExternalMailQueue" is currently disabled.” message

Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008 which will not be able to send emails to the database users. The SQL Server error logs will log following errors:   The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following:  ‘The service queue “ExternalMailQueue”…


How to find who is using / eating up the Virtual Address Space on your SQL Server

Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and getting OOM (out-of-memory) errors in your SQL Server. More often than not there is confusion between physical memory pressure vs. virtual memory pressure. Adding more RAM is definitely not a solution here! Here are some sample error messages you might…

9

SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues

Today I am going to talk about FTS IFilters, its security considerations and some basics on troubleshooting issues with PDF Filters. Read on and be enlightened… What is a Word-Breaker? It is a component within the FTEngine that’s responsible to perform linguistic analysis of the data. In other words, it’s responsible for breaking down words…

1

HOW TO TERMINATE SQL JOBS AFTER CUT-OFF PERIOD

NOTE: This method should not be attempted on the following jobs: Ø  Reindex Ø  Update Statistics Ø  Replication Ø  Backup How many times have we encountered a SQL job which runs for a long time (more than expected) only to error out or even worse hang!  There is no automated method but this is a…


HOW TO DETECT SQL SERVER INSTANCES / FEATURES INSTALLED ON A MACHINE

Have you ever wondered if there is a programmatic way to detect all the SQL server instances and services installed on a machine. Well, worry no more as the code below will do exactly that. There are 2 ways to go about this : Method 1 – For the Programmer The code below is written…