On a SQLServer 6.5 NT 4.0 box the backup jobs started giving the following error, "Unable to connect to SQL Server '(local)'." The only change I made to the box in the last 2 months was to add my id with a grant all for all objects. How can SQLServer not be able to connect to itself? Thanks, Mark.

-- Anonymous, April 18, 2001

Answers

Microsoft SQL Server 6.5 functions with TWO separate services - the SQL Server database engine and the SQL Executive. It is the Executive service which handles automated tasks such as the backups and it is the Executive service which is generating the errors you see. It is telling you that it cannot contact the other service - the MSSQL service. Using the "services" applet in the control panel, the SQL Server Service Agent, or Enterprise Manager to re-start the MSSQL service might solve your problem.

-- Anonymous, April 19, 2001