Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

Installation of SQLserver2008 cluster might fail on windows2008 with error mentioned below The cluster resource ‘SQL Server’ could not be brought online.  Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)   Root Cause This problem occurs because of a new security feature named…

12

Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

  Do you see below errors in SQL error along with dumps and stuck? New version of this post in available in This Link   Non-yielding IOCP Listener * BEGIN STACK DUMP: *   05/06/12 03:54:59 spid 0 * Non-yielding IOCP Listener Non-yielding Scheduler * BEGIN STACK DUMP: *   04/16/12 10:09:58 spid 6256 * Non-yielding Scheduler…

10

Unable to open SQL2000 DTS packages in SQLserver2008 SSMS/BIDS 2008

Problem=======When we open a SQL2000 DTS package in SQL2008 SSMS/BIDS It fails with below error. Error: ——–SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, “SQL Server 2000 DTS Designer Components” to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)   Resolution========1.Install SQL Server 2000 DTS Designer Components, Microsoft SQL Server…

9

How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.

The only possible way to add an IP to SQLServer2005 after adding new NIC to the node where SQLServer2005 is installed (or) After adding second ip address to existing NIC is to either manually edit the registry or run Service pack/Hotfix setup again.   The only possible way to add an IP to SQLServer2005 after…

6

Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher

Error=== 2008-03-19 23:06:23 – ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode retail build) : Process ID 24282008-03-19 23:06:23 – ? [101] SQL Server SNETNAME version 9.00.3186 (0 connection limit)2008-03-19 23:06:23 – ? [102] SQL Server ODBC driver version 9.00.30422008-03-19 23:06:23 – ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is…

5

Different Status bits of sysdatabases in SQLServer

Sysdatabases.status and sysdatabases.status2 Bit of Sysdatabases in SQLServer======================================================================== <Script1> declare @status int;declare @status2 int; Set  @status=’65544′  –Replace your DB status here set @status2=’1090520064′ –Replace your DB status2 here SELECT CASE (@status & 1) WHEN 1 THEN 1 ELSE 0 END AS autoclose, CASE (@status & 4) WHEN 4 THEN 1 ELSE 0 END AS selectintobulkcopy,…

5

Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788.

Problem Description :   v  Unable to start SQL Server 2005 default instance on a standalone server. v  We notice below Error message in the SQL Server Error Log                                             2009-07-15 19:03:25.74 spid5s      Error: 15466, Severity: 16, State: 1.                                 2009-07-15 19:03:25.74 spid5s      An error occurred during decryption.                                 2009-07-15 19:03:25.79 spid5s      Server name…

4

How to Analyze "Deadlocked Schedulers" Dumps?

How to Analyze "Deadlocked Schedulers" Dumps? Newer version of this post is available in http://mssqlwiki.com/2010/06/15/how-to-analyze-deadlocked-schedulers-dumps/ Do you see "Deadlocked Schedulers" errors similar to one below and stuck? From SQLServer Errorlog **Dump thread – spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt * BEGIN STACK DUMP:…

4

The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive

Error The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run. Error: 927, Severity: 14, State: 2. Database ‘model’ cannot be opened. It is in the middle of a restore. Could not create tempdb. You may not have enough disk space available. Free additional disk space…

4

Runtime error: ActiveX component can’t create object: ‘SQLDMO.SQLServer’

  When you use SQLDMO ??? Install SQL Server2005 Backward compatibility http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi Also remember if you have installed 32-Bit SQL Server on 64-Bit you have to use Cscript.exe from SysWOW64

3