Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intermittent Logon Problems

Status
Not open for further replies.
Dauphy

Dauphy

IS-IT--Management
Nov 8, 2001
111
CA
Hello.. Help! We have a company wide SQL server database application that we have been using for years. It's never required any maintenance. All of a sudden, the users are unable to connect the first time of the day; they get the login box and may or may not be able to get in. Sometimes they have to try 5 times. Once they get in for the first time during the day it is usually fine. There are other databases on the same SQL Server with no issues; therefore I don't suspect a connectivity issue to the server itself. I touch the SQL Server only when I need to.. very infrequently - so basically am a newbie. Therefore, please be explicit with any instructions.. :) Oh yeah, version is SQL Enterprise Manager 8.0. Thanks!!!!!!!!!!!!!!
 
Sort by date Sort by votes
What error message do they get when they can't login? Is the problem only at a specific time of day. for instance if the first login of the day is inthe afternoonn rather than when they first come in inthe morning does it happen?

What has changed recently onthe server? Is there a scheduled job that runs about then? Not just a SQl server job but is there some sort of server maintenance that is suddenly happening?


Also you might want to move this to the SQl Server Setup and Maintenance forum, you are likely to get a better answer there.

"NOTHING is more important in a database than integrity." ESquared
 
Upvote 0 Downvote
Hey SQL Sister... Thanks for replying.. They are not getting any error messages.... they are just getting the Login screen and a drop down of all the available SQL servers that they can connect to. It is using a trusted connection.
It happens mostly in the a.m. but has known to happen later in the day. Once they get in, they are usually good. I'm in charge of the servers and there is nothing new scheduled; nor has anything changed.

Thanks for the info re moving this post... not sure how to move it.. can I just create a new one there?
 
Upvote 0 Downvote
YOu can use the redflag link at the bottom to ask the site admin to move it or create another one there.

"NOTHING is more important in a database than integrity." ESquared
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G12Consult
  • Locked
  • Question
Problems with SP
Replies
5
Views
110
Olaf Doschke
Olaf Doschke
VAST39
  • Locked
  • Question
Problems Creating a Query with Multiple Counts
Replies
3
Views
57
gmmastros
gmmastros
egstatus
  • Locked
  • Question
Problems with RTRIM when creating a field from other fields in SQL
Replies
2
Views
47
egstatus
egstatus
wijb
  • Locked
  • Question
Intermittent Slow SQL Connection
Replies
6
Views
49
wijb
wijb
UnsolvedCoding
  • Locked
  • Question
ISNull giving problems 1
Replies
9
Views
53
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top