dbTalk Databases Forums  

The AcquireConnection failed with error code 0xC0202009. sql<->sql

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss The AcquireConnection failed with error code 0xC0202009. sql<->sql in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Liliya Huff
 
Posts: n/a

Default RE: The AcquireConnection failed with error code 0xC0202009. sql<- - 04-20-2008 , 11:30 PM






yes. in my case somebody crated/altered domain account for sql server agent
not according to the policy, so it's password has expired that same day.
after fixing that all went back to where it supposed to be. would have seen
that earlier if we would bounce out servers often, but such a thing does not
happen for month and month...
policy violations are not really expected every day in our case either, so
it took some time to find.
--
Thanks, Liliya



Reply With Quote
  #22  
Old   
Liliya Huff
 
Posts: n/a

Default RE: The AcquireConnection failed with error code 0xC0202009. sql<- - 04-20-2008 , 11:30 PM






yes. in my case somebody crated/altered domain account for sql server agent
not according to the policy, so it's password has expired that same day.
after fixing that all went back to where it supposed to be. would have seen
that earlier if we would bounce out servers often, but such a thing does not
happen for month and month...
policy violations are not really expected every day in our case either, so
it took some time to find.
--
Thanks, Liliya



Reply With Quote
  #23  
Old   
Liliya Huff
 
Posts: n/a

Default RE: The AcquireConnection failed with error code 0xC0202009. sql<- - 04-20-2008 , 11:30 PM



yes. in my case somebody crated/altered domain account for sql server agent
not according to the policy, so it's password has expired that same day.
after fixing that all went back to where it supposed to be. would have seen
that earlier if we would bounce out servers often, but such a thing does not
happen for month and month...
policy violations are not really expected every day in our case either, so
it took some time to find.
--
Thanks, Liliya



Reply With Quote
  #24  
Old   
Liliya Huff
 
Posts: n/a

Default RE: The AcquireConnection failed with error code 0xC0202009. sql<- - 04-20-2008 , 11:30 PM



yes. in my case somebody crated/altered domain account for sql server agent
not according to the policy, so it's password has expired that same day.
after fixing that all went back to where it supposed to be. would have seen
that earlier if we would bounce out servers often, but such a thing does not
happen for month and month...
policy violations are not really expected every day in our case either, so
it took some time to find.
--
Thanks, Liliya



Reply With Quote
  #25  
Old   
Liliya Huff
 
Posts: n/a

Default RE: The AcquireConnection failed with error code 0xC0202009. sql<- - 04-20-2008 , 11:30 PM



yes. in my case somebody crated/altered domain account for sql server agent
not according to the policy, so it's password has expired that same day.
after fixing that all went back to where it supposed to be. would have seen
that earlier if we would bounce out servers often, but such a thing does not
happen for month and month...
policy violations are not really expected every day in our case either, so
it took some time to find.
--
Thanks, Liliya



Reply With Quote
Reply




Thread Tools
Display Modes

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.