RE: SQL state (error) is 37000

Any takers?

"mherberger" wrote:

> Hello,
> We are experiencing an intermittent problem where we loose our connection to
> SQL server from RSSQL. The system logs are reporting this in the following
> order:
>
> 1 8/23/2005 1:58:59 AM 5 256 RSSql N/A TSSFOOTAGECTR (52152) SQL state
> (error) is 37000
> 1 8/23/2005 1:58:59 AM 5 256 RSSql N/A TSSFOOTAGECTR (52153) SQL state
> (error) text is [Microsoft][ODBC SQL Server Driver][SQL Server]SQLServerAgent
> Error: Request to run job sfd_foot_strip_lgth (from User
> TSSFOOTAGECTR\Administrator) refused because the job already has a pending
> request from User TSSFOOTAGECTR\Administrator.
> 1 8/23/2005 1:58:59 AM 5 256 RSSql N/A TSSFOOTAGECTR (52155) A Database
> error transaction occurred: -1: { ? = CALL dbo.sp_LengthReady (543, 1,
> 8.400000e+001, 1, 0, 1 )
> 1 8/23/2005 1:58:59 AM 1 256 RSSql N/A TSSFOOTAGECTR (53773) 000050 064193
> Closer thread closed transaction 216_Slitter_Reel_1 occurrence 64193 with
> error 33147
> 2 8/23/2005 1:58:59 AM 5 256 RSSql N/A TSSFOOTAGECTR (52080) Attempting to
> reconnect for DB FootageCounter ConnectionId: 0
>
> After which all is fine for awhile, then is will occur again.
>
> The job sfd_foot_strip_lgth is a very small SQL script that tries to create
> a new job from RSSQL to SQL Server. It first checks to see if there is
> already a job with the same name pending and if not it creates a new one.
> This cycle is around one second in length.
>
> It appears that there is a job in SQL Server even thou SQL Server says there
> isn’t.
>
> Any help with this would be greatly appreciated.
>
.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)
Loading