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.
| 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 |
 |
|
|
|
|
|