Can't connect to SQL Server ERROR!

Can't connect to SQL Server ERROR!

Post by Glenn Leit » Thu, 03 Aug 2000 04:00:00

I'm using SQL 6.5 for DB backend support to an EDI software package. I use
ARCServeIT to backup and use their Disaster Recovery Module. After
rebuilding a machine from the disaster recovery disks and tape I can't
connect to the SQL Server even though the services are running.

I can go into SQL security manager and can connect as "local" only.

What would cause this error when the services are running?


1. SQL Agent Job Error: Unable to connect to SQL Server '(local)':

NT 4/SP6a    SQL7/SP3

Hi there:

I have configure the SQL Agent to connect to the SQL Server using SQL Auth.
[sa login].  Every now and then, some job fails with the following error:

Unable to connect to SQL Server '(local)'.  The step failed.

It does not happen to the same job all the time.  It is not a consistent
error either.  Other jobs work OK while one errors out.  Any thought?


Abdul Gill

2. Concatenate String

3. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

4. Exec Stored proce from ACCESS

5. Can't connect to OLAP Server after renaming SQL Server Name

6. Progress bar and forms

7. Can't connect to SQL Server 7 on Win 2000 Server - help

8. How do I get a directory listing via PL/SQL

9. MS Internet Server can't connect to SQL Server ODBC source

10. Connecting to SQL Server in Query Analyzer gets error does not connect

11. Connect to Multiple SQL Server's with SQL

12. SQL-DMO: can't connect to SQL server via network

13. Can't connect to server, Error #17310.