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 |
|
garyyeung
Starting Member
6 Posts |
 Posted - 2010-03-17 : 05:29:36
|
| I have developed a system that runs in SQL server 2000 everyday. The system is a power builder program which works fine. However, user sometimes report of abnormal waiting on some functions in the system. When this occur, I remote to the DB server and try to figure out the problem by using Enterprise Manager. But when I try to connect to the DB, the enterprise manager prompts 'A connection could not be established to (local). Reason: Login failed for user '(null)'........ It's really strange that I can connect to the Enterprise Manager using the same procedure everyday, but the error occurs sometimes unpredictably. I finally restart the DB server and everything works fine again.Anyone got some idea on this problem?? (headache...) |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-17 : 05:57:36
|
Have you got the latest Service Packs on the Database and the client tools and client drivers? If not you may be looking at a problem that has already been fixed  Upgrading to latest service pack may bring its own problems ... so be prudent about any upgrades. |
 |
|
|
hagis
Starting Member
8 Posts |
Posted - 2010-03-17 : 06:23:08
|
| What authentication are you using to get the DB connection on Enterprise Manager? I had a similar problem a while back when I tried to connet using Windows Authentication, turns out my PW had expired. |
|
|
|
garyyeung
Starting Member
6 Posts |
Posted - 2010-03-17 : 21:42:29
|
Window Auth. has been used. But why all the stuff resume normal after rebooting the server? The auth. mode has not changed. The password has not changed. But it happens sometimes, not very often, may be once 1 week but not periodically. This unpredictable behavour make me feel exhaust in tracing the real problem.  |
|
|
|
|
|
|
SQL server fails suddenly