Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

Instance of MSSQL 2005 database in Microsoft cluster no more reachable

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
SIES di Andrea Barbon
Asked:
SIES di Andrea Barbon
  • 5
  • 2
1 Solution
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
SIES di Andrea BarbonAuthor Commented:
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
 
x-menIT super heroCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
SIES di Andrea BarbonAuthor Commented:
0
 
SIES di Andrea BarbonAuthor Commented:
They did not change the user of the service and is a domain admins member.
0
 
SIES di Andrea BarbonAuthor Commented:
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
 
SIES di Andrea BarbonAuthor Commented:
It's not a solution, the problem was caused by a hardware failure.
After having changed the faulty memory bank we reinstalled.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now