dbTalk Databases Forums  

Resources not coming online

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Resources not coming online

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Resources not coming online in the microsoft.public.sqlserver.clustering forum.



Reply
Page 1 of 5 1 2 3 4 5 >
 
Thread Tools Display Modes
  #1  
Old   
kj2n
 
Posts: n/a

Default Resources not coming online - 09-26-2008 , 12:44 PM





I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online. I
can not bring them online manually either. The services are stopped. When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able to
start the services and bring the resources online. I can fail back to node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM





Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Resources not coming online - 09-26-2008 , 12:50 PM


Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


Reply With Quote
Reply
Page 1 of 5 1 2 3 4 5 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top