 |
|
|
|
Next: Strong passwords in FileMaker Pro Server
|
| Author |
Message |
External
Since: Nov 03, 2005
Posts: 5
|
(Msg. 1) Posted: Thu Nov 03, 2005 3:14 pm
Post subject: 2-node cluster won't stop sqlservr.exe during user-initiated
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
|
|
|
I have the following cluster config:
2x HP DL585 servers (identical) - 4x Opteron 852 processors, 8GB RAM,
Win2003Enterprise, SQL 2000 Enterprise
1x HP MSA 500 SCSI shared-storage
1x HP SCSI adapter per server (included with MSA500, not sure of the model #)
The servers are in an active/passive configuration. Either one works fine
during normal operation. But when we do a "move group" for the SQL Server
group from either node to the other, the move process stalls waiting for
sqlservr.exe to stop.
These are pretty fast machines, but we've waited 20 minutes, with almost no
CPU activity, before killing sqlservr.exe in task manager. At that point the
cluster resources complete their move to the passive node and everything
starts up just fine. We don't experience any database corruption, though
we've de-activated all the db client applications before doing this, so the
db server load is very near zero.
My suspicion is that this is related to roaming profiles (required for
encrypting file system with Win2003 clusters), which are located on the same
machine in a cluster share, in the SQL Server cluster group, with SQL Server
dependant on the share.
Any thoughts?
-David S. |
|
| Back to top |
|
 | |
External
Since: Nov 03, 2005
Posts: 5
|
(Msg. 2) Posted: Thu Nov 03, 2005 3:34 pm
Post subject: RE: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Mar 15, 2005
Posts: 76
|
(Msg. 3) Posted: Fri Nov 04, 2005 5:17 am
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Any clues in the cluster host nodes' application event logs?
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David S." wrote in message
>I have the following cluster config:
>
> 2x HP DL585 servers (identical) - 4x Opteron 852 processors, 8GB RAM,
> Win2003Enterprise, SQL 2000 Enterprise
> 1x HP MSA 500 SCSI shared-storage
> 1x HP SCSI adapter per server (included with MSA500, not sure of the model
> #)
>
> The servers are in an active/passive configuration. Either one works fine
> during normal operation. But when we do a "move group" for the SQL Server
> group from either node to the other, the move process stalls waiting for
> sqlservr.exe to stop.
>
> These are pretty fast machines, but we've waited 20 minutes, with almost
> no
> CPU activity, before killing sqlservr.exe in task manager. At that point
> the
> cluster resources complete their move to the passive node and everything
> starts up just fine. We don't experience any database corruption, though
> we've de-activated all the db client applications before doing this, so
> the
> db server load is very near zero.
>
> My suspicion is that this is related to roaming profiles (required for
> encrypting file system with Win2003 clusters), which are located on the
> same
> machine in a cluster share, in the SQL Server cluster group, with SQL
> Server
> dependant on the share.
>
> Any thoughts?
>
> -David S. >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
External
Since: Nov 03, 2005
Posts: 5
|
(Msg. 4) Posted: Fri Nov 04, 2005 9:59 am
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Geoff,
I started the cluster move at about 10:30 AM when this happened. From 10:00
to 11:30, there are nothing but informational messages in the System and
Application event logs. Of those, nothing references the cluster operation,
except to describe some cluster-group services starting on the
becoming-active node.
More versions:
Windows 2003 Enterprise including SP1
SQL Server 2000 including SP3a and SQL hotfix 840 (KB810185 - sets SQL
version to 8.00.0840).
-David
"Geoff N. Hiten" wrote:
> Any clues in the cluster host nodes' application event logs?
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
<snip> >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
External
Since: Feb 23, 2005
Posts: 443
|
(Msg. 5) Posted: Fri Nov 04, 2005 6:52 pm
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Is the Cluster service account a domain account with licam admin group
menbership on both host nodes?
GNH
"David S." wrote in message
> Geoff,
>
> I started the cluster move at about 10:30 AM when this happened. From
> 10:00
> to 11:30, there are nothing but informational messages in the System and
> Application event logs. Of those, nothing references the cluster
> operation,
> except to describe some cluster-group services starting on the
> becoming-active node.
>
> More versions:
> Windows 2003 Enterprise including SP1
> SQL Server 2000 including SP3a and SQL hotfix 840 (KB810185 - sets SQL
> version to 8.00.0840).
>
>
> -David
>
> "Geoff N. Hiten" wrote:
>
>> Any clues in the cluster host nodes' application event logs?
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
> <snip> >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
External
Since: Nov 03, 2005
Posts: 5
|
(Msg. 6) Posted: Fri Nov 04, 2005 6:52 pm
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 02, 2005
Posts: 27
|
(Msg. 7) Posted: Fri Nov 04, 2005 11:55 pm
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yes, that is what I meant. I shouldn't type when I am sleep deprived. My
brain doesn't work my fingers correctly.
You haven't changed the SQL Service account information any time recently,
have you? If you don't set the account using Enterprise Mangler, the
permissions can get messed up. Also, make sure there aren't any DNS, Hosts
file, or SQL aliases that mangle the local computer name. It might be a
service name resolution issue.
Off the top of my head, I can't think of anything else. Maybe Rodney or one
of the other Windows Cluster MVPs can chime in with an idea.
GNH
"David S." wrote in message
> It's a domain account, with local admin membership on both nodes. I think
> that's what you mean. "licam"?
>
> -David
>
> "Geoff N. Hiten" wrote:
>
>> Is the Cluster service account a domain account with licam admin group
>> menbership on both host nodes?
>>
>> GNH
> <snip> >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
External
Since: Nov 03, 2005
Posts: 5
|
(Msg. 8) Posted: Mon Nov 07, 2005 3:59 pm
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Geoff,
That probably has happened. These are new servers, and the deployment
process was fairly complex and involved a few different security
configurations before we settled on the final accounts.
Is there a good way to re-initialize the current run-as accounts for SQL
Server and SQL Server Agent? Do we have to switch to a dummy account,
stop/start cluster resources, switch back, stop/start cluster resources?
-David S.
"Geoff N. Hiten" wrote:
> Yes, that is what I meant. I shouldn't type when I am sleep deprived. My
> brain doesn't work my fingers correctly.
>
> You haven't changed the SQL Service account information any time recently,
> have you? If you don't set the account using Enterprise Mangler, the
> permissions can get messed up. Also, make sure there aren't any DNS, Hosts
> file, or SQL aliases that mangle the local computer name. It might be a
> service name resolution issue.
>
> Off the top of my head, I can't think of anything else. Maybe Rodney or one
> of the other Windows Cluster MVPs can chime in with an idea.
>
> GNH
<snip> >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
External
Since: Mar 15, 2005
Posts: 76
|
(Msg. 9) Posted: Tue Nov 08, 2005 9:42 am
Post subject: Re: 2-node cluster won't stop sqlservr.exe during user-initi [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Almost. Go ahead and switch accounts, save, switch back, save again and
then stop-start the services. Also, the SQL service accounts MUST be
members of the local administrators group in a SQL cluster.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David S." wrote in message
> Geoff,
>
> That probably has happened. These are new servers, and the deployment
> process was fairly complex and involved a few different security
> configurations before we settled on the final accounts.
>
> Is there a good way to re-initialize the current run-as accounts for SQL
> Server and SQL Server Agent? Do we have to switch to a dummy account,
> stop/start cluster resources, switch back, stop/start cluster resources?
>
> -David S.
>
> "Geoff N. Hiten" wrote:
>
>> Yes, that is what I meant. I shouldn't type when I am sleep deprived.
>> My
>> brain doesn't work my fingers correctly.
>>
>> You haven't changed the SQL Service account information any time
>> recently,
>> have you? If you don't set the account using Enterprise Mangler, the
>> permissions can get messed up. Also, make sure there aren't any DNS,
>> Hosts
>> file, or SQL aliases that mangle the local computer name. It might be a
>> service name resolution issue.
>>
>> Off the top of my head, I can't think of anything else. Maybe Rodney or
>> one
>> of the other Windows Cluster MVPs can chime in with an idea.
>>
>> GNH
> <snip> >> Stay informed about: 2-node cluster won't stop sqlservr.exe during user-initiat.. |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
