Have you checked the Windows System and Application event logs ? If there are any HBA or network issues they should show up there. You do not mention the SAN...

You could also use integrated security for a domain user account (this may make the Windows Admins a bit happier). We use domain user accounts for the services and these...

The issue sounds more legal than anything else (there are technical points but they are outweighed by the legal ramifications in my opinion). A 'reputable' vendor will have the neccessary...

On the computer in question go to Computer Management | Services (right click My COmputer and select Manage).

If you have a default instance of MSDE look for:

MSSQLSERVER --> for the...

time for:

exec sp_update_resume

possibly time for:

exec sp_distribute_resume

To answer the original question (our site 'standard process') ...

1) Check the Windows event logs (System, Application) for any errors prior to the 'outage'. I'd look out for disk errors or...

I'd leave the default port number alone and let your network team earn thier keep.

Try this port list (I had to work through a 'deny-all' firewall once) ...

1433, TCP

1434,UDP

3389,TCP --> for RDP Client Access

445,TCP

445,UDP

135,TCP

135,UDP

137,UDP

138,UDP

139,UDP

5000-5250,TCP --> registry hack needed as well for the range of...

Microsoft is the only correct answer. Even before Database Daily gets the information Microsoft provides it to my firm under the terms of our Enterprise and Premier agreements. In lieu...

The function is still there (as of about 45 days ago) ... beware, it can be horrendously slow !!!

I have not seen it yet ... waiting anxiously ... we do not want to have to license a number of visual studio installs ...

How 'draconian' ... I've been there a couple of times myself ... there is the possibility that the Windows admins are 'hiding' behind policy because they do not want to...

Good things sometimes come in small packages - as this one goes it's a keeper !!!

Hey Chris, where did you get this piece of information --> "The message is repeated every 1000th time this happens."

... enquiring minds want to know ...

Yes Remi, in the past I have run into 'issues' (problems) that after calls to MS support the first thing recommended was reboot and 'issues' have gone away. Also, I'm...