Cluster failover not happening..plse help
-
Hi
I have installed the SQL 2000 cluster with the SP4 and hotfix for awe and working fine for few hours, before that I have done so many failovers and restart of both the nodes. But the problem happened around 5 PM when I was testing the fail over, the SQL resources held with online pending. I could see the below error from cluster log and event log(application)
The a\c RTDOMAU\svc-proxy-pclust is the cluster admin account which I have used for the build. Have you ever come across this kind of situation?
00000e44.00001280::2007/09/17-09:32:05.314 ERR SQL Server <SQL Server>:
[sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818; message = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RTDOMAU\svc-proxy-pclust'.
Any comments will be very much appreciated.Thanks in advance.
Regards
Binu John
-
just a wild guess, but did you remove builtin\administrators and forgot to give login auth to the cluster service account ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Yes..I did..understand where I went wrong..thx mate...
-
been there, done that, burned the fingers too
I'm glad you're back on track now.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
:hehe: Now the same thing happened again witht this error 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connectionin cluster'.
Today server guys has hardened the server and might changed the cluster account policies etc.. but now claiming reverted back the changes. But still cluster not getting fail over.:w00t:
Any help would be appreciated...
-
all service accounts that have a relation to your sqlserver instance need at least instance level login auth.
The clusterservice account ('RTDOMAU\svc-proxy-pclust') just needs login rights to the sqlserver instance to be able to poll it.
Have your network gurus :ermm: revert their actions at server level (all nodes !), start your sqlserver instance, grant the needed service accounts the login rights.
Review what they want to do and only if theory is OK, give th GO.:cool:
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
The cluster account (svc-proxy-pclust)having sa rigths on SQL and they have reverted back the changes made( claiming?). Still when I start open the cluadmin the sql resources in 'online pending mode'.
-
have a look in the cluster log as well as the sqlserver errorlog file.
(C:\WINNT\cluster\cluster.log)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
yeap..the same error in cluster.log ''Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connectionin cluster'.
-
- Doublecheck the cluster account
- bring all resources online except for the sql-instance
- Then use 'net start yourinstance', and check the account has login rights (NO sysadmin auth needed !)
- net stop yourinstance
- start it using the cluster service
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Double checked the cluster a\c..all resources except sql is online.
when a use net start instanceanme, getting error service name invalid.
Regards
Binu john
-
keep in mind if you start an instance manualy you need to start:
net start mssql$instancename
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Yea I can start SQL services using net star, previously also I can manually start SQL service and agent service. And even cluster also doing this when I try to bring the sql resource online.
But problem happens in the cluster admin saying online pending and finaly SQL server resource fails in cluster. When its saying online pending I can open EM using sa account and access databases.
Regards
Binu John
-
which network protocols are opened for connections ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
should be tcp\ip..
btw I have read some where this
The fact that in the error message you are getting Login Failed for user
(null) means that the Cluster service is trying to log in with Windows
Authentication, but that it has lost its access token.
any relevance here?
Regards
Binu John
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply