SQL has always seemed a back are to me, and wherever possible I have delegated this to others. However at the moment I am stuck trying to work out the best approach to solve this.
Companyweb was fine, not idea why but it stopped working, the error log is full of messages :-
Event Type: Error
Event Source: Windows SharePoint Services 2.0
Event Category: None
Event ID: 1000
#50070: Unable to connect to the database STS_Config on OP01\SharePoint. Check the database connection information and make sure that the database server is running.
Have tried restarting IIS, and MSSQL$SHAREPOINT, but the sharepoint just stops again.
Did see a number of articles about timer service, and from what I can tell this is set correctly to NT AUTHORITY\NETWORK SERVICE and seems to start fine.
In Enterprise manager I can see the sharpoint server, which is stopped, and if I try and do anything it says "A connection could not be established OP01\SHAREPOINT"
Reason: SQL sever does not exist or access denied !
Now I am out of my depth, most of the articles I found by a google do not seem to be the same issue I have. They mention service packs and MSDE2000. Whereas this was running find then suddenly stopped.