RE: Strange SQL Server Timeout Problem

From: Kelly (Kelly_at_discussions.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 10:14:01 -0700

It sounds like the auto close option is turned on.

"Joseph Geretz" wrote:

> We're seeing a very strange SQL Server access problem. At intermittent
> times, all users are unable to log into our software. We've traced the
> problem to the following query:
>
> INSERT INTO WORKSTATIONS SELECT MAX(WORKSTATIONID)+1, 'VMSRSSERVER1',
> GETDATE(), 0 FROM WORKSTATIONS
>
> Here's the error information returned:
>
> PROVIDER ERROR
> Error: -2147217871
> Description: Timeout expired
> Source: Microsoft OLE DB Provider for SQL Server
>
> What's strange about this is that, in order to reach this point, the
> software must have already successfully issued a SELECT statement from the
> USERS table in order to to validate credentials. It seems, that in this
> scenario, SELECT statements are successfully processed, but the first INSERT
> statement will hang. When this happens to one user, it happens to all users
> and no one can log into our software.
>
> Evan stranger, the situation can be corrected by simply accessing the
> database in Enterprise Manager. In this scenario, I notice that accessing
> the database takes much longer than usual, approximately 30 seconds. But
> once Enterprise Manager accesses the database, suddenly all users are able
> to log in again. Also, this seems to happen only in the morning. Once we use
> the Enterprise Manager trick, all users can once again log in and we're good
> until tomorrow...
>
> Has anyone seen this problem? Or if you can suggest an approach for me to
> investigate this, that would be extremely helpful as well.
>
> Thanks very much for your help!
>
> - Joe Geretz -
>
>
>

Relevant Pages

  • Re: login security question
    ... Say the password for the Application role is found, can a user access the database through the ... Query Analyser or Enterprise Manager using the application rolde/password.>> ... The user name, however, will be the app role name. ...
    (microsoft.public.sqlserver.server)
  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
  • Re: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)
  • Change Column Size
    ... table1 alter column column1 varchar" and the command ... logged in using Windows Authentication (My ... I changed to the MyDB database, ... Enterprise Manager say one thing about the column length ...
    (microsoft.public.sqlserver.tools)
  • Re: Issue with Migrating OLAP Cube
    ... I tried your scenario and it works fine. ... uat server, but the underlying SQL database differs. ... I copy those same cubes from ...
    (microsoft.public.sqlserver.olap)