Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Unable to connect to SQL server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-01 : 07:34:56
Zin writes "I have this error message coming out when i try to run program to connect to sql server. The error is 'Specified SQL server not found.ConnectionOpen (CreateFile()).

My SQL server and program is running 24 hours non stop whole day. This error only comes out during midnight and yet during day time, everything is smooth.

The current SQL i am using now is SQL7.0. Please help me on this error as i really wish to find out the reason.

Thanks.

Regards,
Zin Lu"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-01 : 12:33:20
Your SQL Server is probably over loaded at midnight and can't log anyone into the system. I would run SQL Profiler to determine what is running on SQL Server. You might also consider running a network sniffer to determine what else is occurring in the environment.

Tara
Go to Top of Page
   

- Advertisement -