Okay, not sure what is going on but I went back into management studio and did a refresh on the sql server instance and it allowed me to 'attach' the database again.
My question and my fear now is, what is involved in changing the service account? I was under the assumption that you go to configuration manager and pick your service, key in the logon id and password. then that is it, sql should set up all permissions necessary. Is this correct or am I suppose to do more legwork behind the scene? The service account is a basic domain account, no admin rights assigned it.
Thank you for any info anyone can share..
This is my first sql2005 experience :unsure: