Solved

Instance of MSSQL 2005 database in Microsoft cluster no more reachable

Posted on 2014-03-14
8
369 Views
Last Modified: 2014-03-29
Hello,
one of our customers has a Windows 2003 Enterprise 64bit cluster with an instance of MSSQL server 2005 standard sp2 that is no more reachable by the clients and via management studio we get a timeout.
Could we try to upgrade to sp4?
Which logs we have to look for to have more information on the issue?
In event viewer we see these errors (in italian):

Tipo evento:      Errore
Origine evento:      SQLSERVERAGENT
Categoria evento:      Service Control
ID evento:      103
Data:            14/03/2014
Ora:            14.56.06
Utente:            N/D
Computer:      SQLSERVER
Descrizione:
SQLServerAgent could not be started (reason: Impossibile connettersi al server '(local)'. Impossibile avviare SQLServerAgent.).

Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico all'indirizzo http://go.microsoft.com/fwlink/events.asp.

Tipo evento:      Errore
Origine evento:      WinMgmt
Categoria evento:      Nessuno
ID evento:      10
Data:            14/03/2014
Ora:            14.57.25
Utente:            N/D
Computer:      SQLB
Descrizione:
Impossibile attivare il filtro eventi con query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" nello spazio dei nomi "//./root/Microsoft/SqlServer/ComputerManagement"  a causa dell'errore 0x80041010. Potrebbe essere impossibile utilizzare questo filtro per consegnare gli eventi se  non sarĂ  risolto il problema.

Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico all'indirizzo http://go.microsoft.com/fwlink/events.asp.

Thanks
0
Comment
Question by:SIES di Andrea Barbon
  • 5
  • 2
8 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 39930985
Don't upgrade an instanse thats unresponsivt!

Is the sql server service started?

What does the errorlog say?
http://technet.microsoft.com/en-us/library/ms187885(v=sql.90).aspx

What does application log say when sql starts?

Regards Marten
0
 

Author Comment

by:SIES di Andrea Barbon
ID: 39933783
Hello Marten thanks,
yes the sql server service is started, the sql server agent service does not start and gives the error 103.
The error log doesn't tell me anything but I never work with sql... so I attached it.
The aplication log shows only the two errors I posted even when I restart it.
regards
Andrea
ERRORLOG
0
 
LVL 18

Expert Comment

by:x-men
ID: 39933878
look like a problem in the WMI database/repository.

cjeck this article http://networkadminkb.com/KB/a193/how-to-fix-missing-wbemadap-registry-value-names.aspx
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 39934113
Make sure you use SSCM (SQL Server Configuration Manager) when changing the account,
http://msdn.microsoft.com/en-us/library/ms191543.aspx

Regards Marten
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:SIES di Andrea Barbon
ID: 39934145
0
 

Author Comment

by:SIES di Andrea Barbon
ID: 39934842
They did not change the user of the service and is a domain admins member.
0
 

Accepted Solution

by:
SIES di Andrea Barbon earned 0 total points
ID: 39950301
Hello everyone,
the problem was caused by a faulty memory bank in the server sqla, the failure probably happened when they were moving the sql service between cluster members.
The issue has been fixed reinstalling from scratch the servers.

Thank you for all the answers.

Andrea
0
 

Author Closing Comment

by:SIES di Andrea Barbon
ID: 39963516
It's not a solution, the problem was caused by a hardware failure.
After having changed the faulty memory bank we reinstalled.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now