MS SQL Server Clustering - SQL 2000 Problems EVENT ID 17052

Author

SQL 2000 Problems EVENT ID 17052

Pravin Patel

2005-12-14, 9:24 am

Hi, Geoff Hiten I have been having issues with SQL not starting due to the
following error message:

[sqsrvres] checkODBCConnectErro
r: sqlstate = 28000; native error = 4818;
message = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user 'domain\account'

I read through MSDN newsgroup & found your article regarding this issue;
the problem started when the cluster service accounts were reset on both
nodes & SQL would not start, to keep the story short here is what we
did.

After reseting the password in Active Directory for all the service
accounts, all the services are running properly but in cluster
adminstartion the sql resource is not online.

Later I Guessed that the windows cluster login which is on the sql
server is not mapped with active Directory changes.

So I dropped the cluster service logon on sql server and re-created. <--
This seem to work but my question is why would we drop the cluster
service logon on sql server & re-create it to have sql working again.

If you can provide some insight, information, docs it would be a great
benefit.

Pravin.patel@hp.com

Geoff N. Hiten

2005-12-14, 11:23 am

The cluster service has to connect to the SQL instance in order to execute
the IsAlive and LooksAlive checks. This is how the cluster service
determines whether the resource is online. When you changed the cluster
service account, it could no longer connect, therefore it showed the
resources as offline.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Pravin Patel" <Pravin Patel@discussions.microsoft.com> wrote in message
news:CC096769-574E-4AE7-9E82- 088BA2F2F9B7@microso
ft.com...
> Hi, Geoff Hiten I have been having issues with SQL not starting due to the
> following error message:
>
> [sqsrvres] checkODBCConnectErro
r: sqlstate = 28000; native error = 4818;
> message = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
> for user 'domain\account'
>
> I read through MSDN newsgroup & found your article regarding this issue;
> the problem started when the cluster service accounts were reset on both
> nodes & SQL would not start, to keep the story short here is what we
> did.
>
> After reseting the password in Active Directory for all the service
> accounts, all the services are running properly but in cluster
> adminstartion the sql resource is not online.
>
> Later I Guessed that the windows cluster login which is on the sql
> server is not mapped with active Directory changes.
>
> So I dropped the cluster service logon on sql server and re-created. <--
> This seem to work but my question is why would we drop the cluster
> service logon on sql server & re-create it to have sql working again.
>
> If you can provide some insight, information, docs it would be a great
> benefit.
>
> Pravin.patel@hp.com
>

Pravin Patel

2005-12-14, 1:23 pm

When I re-set the password for the cluster account on both nodes & restarted
the cluster service, it started up okay but SQL would not come online; what
may cause this issue?

"Geoff N. Hiten" wrote:

> The cluster service has to connect to the SQL instance in order to execute
> the IsAlive and LooksAlive checks. This is how the cluster service
> determines whether the resource is online. When you changed the cluster
> service account, it could no longer connect, therefore it showed the
> resources as offline.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Pravin Patel" <Pravin Patel@discussions.microsoft.com> wrote in message
> news:CC096769-574E-4AE7-9E82- 088BA2F2F9B7@microso
ft.com...
>
>
>

Rodney R. Fournier [MVP]

2005-12-14, 1:23 pm

Are you using the same user for the SQL services that the cluster users? Did
you reset the password for the SQL services?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

"Pravin Patel" < PravinPatel@discussi
ons.microsoft.com> wrote in message
news:69743AB4-0F39-4F5F-96E7- F1F25FE66373@microso
ft.com...[color=darkred]
> When I re-set the password for the cluster account on both nodes &
> restarted
> the cluster service, it started up okay but SQL would not come online;
> what
> may cause this issue?
>
> "Geoff N. Hiten" wrote:
>

Pravin Patel

2005-12-15, 11:23 am

We are using different users for SQL & Cluster account; the pass for SQL was
not reset until we encountered the problem.

"Rodney R. Fournier [MVP]" wrote:

> Are you using the same user for the SQL services that the cluster users? Did
> you reset the password for the SQL services?
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Pravin Patel" < PravinPatel@discussi
ons.microsoft.com> wrote in message
> news:69743AB4-0F39-4F5F-96E7- F1F25FE66373@microso
ft.com...
>
>
>

Sponsored Links