Thanks,

So what is the better solution for my case described above?

or does it mean only when the job is running using this proxy account , sql service has windows admin permissions, other time it doesnot.

I forgot to say this job...

Thanks,

In my case, the proxy account credential needs to be windows system admin to start and stop service.

For example, I use my account (as a dba), I am a...

I would update this so it may help other ones, our network specialist changed the fiber controller card to a different type , it then it works all fine now.

Thanks...

Jeffrey Williams 3188 (6/3/2012)

---

The hashed password from sp_help_revlogin is valid - and can be used to create the login on another server with the same password.

If you are migrating to...

I am thinking to restart the reporting service this evening to see if it picks up the new email settings.

This is a sql server 2005 box.

If it is cache problem,...

I see the network guy uses Avocent DSView to make it work, so I tried that, it works for me this time after reboot, before I tried to use remote...

Tried to enable the option in group policy, then restart the server, still have the problem

Thanks, we did try to delay start for SQL service, and after that, the network person restart the server, it seems fine.

But when I come back , I restarted the...

We found out the problem is when the SQL service restarted, there is a 30 seconds delay of SAN mounting, so it won't find the path. After I restart...

Before this happened, I restarted SQL service, it looked OK, but by restarting the server itself, then it started to have the problem.

The strange thing is yesterday, after I...

They are SAN drives, this morning, It happened again. Same error.

I can see the drives and files are there from windows exploer, but database cannot be expanded.

Frustrated, I remember yesterday...

I restore the database from backup then restart the server, they all look fine in SSMS.

The databases are restored to the same directory as those mdf and ldf files earlier...

They are all there.

This is the first time I use detach and attach way to attach database.

Before I used restore database and no problem.

I still think this is related with...

Thanks, here is the screen shot of the error log.