24
2011
Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed!
While investigating a cluster resource offline issue, came across following three errors in windows system event log, cluster log and SQL error log respectively, Error message 1 Source: ClusSvc Category: Failover Mgr Type: Error Event ID: 1069 User: N/A Computer: < Computer Name > Description: Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed. Error message 2 Error in the Cluster log file, SQL Server < SQLServer >: [sqsrvres] Unable to read the ‘VirtualServerName’ […]
7
2011
Editing Jobs / Maint plans not possible on SP2 tools if server name > 30 characters in length
Today, while doing some maintenance plan modification encountered a unique issue, recieved following error while modifying/opening any maintenance plan or job, Error Screenshots: Job error: Maintenance Plan error: Later on investigation found that this is a known bug with SQL Server 2005 SP2 that if SQL Server name exceeds 30 chars then this issue will occur, for e.g. if SQL server name is dazsqlmper234_1234\dbajsasalsa_456 Issue: SQL Agent Jobs and Maint plans are not editable when […]
6
2011
Identify which DTS package is being called by scheduled job!
I was struggling to identify the DTS package name from the job syntax which looks like, DTSRun /~Z0x5B431B25562BD74…2AE391DF759D0B3B09EEAB94B687E05E66CE7307C6304204 this can be simulated by right clicking the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step – similar to what you see above. Found a solution to this at following link […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5