How could i find the client?

Question

Post reply

How could i find the client?

Thinky Night

SSCommitted

Points: 1663
More actions
May 2, 2013 at 9:01 am

#394709

I have a consolidated SQL Server Machine, and none of application are running on this. But I have an error like below:
The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
How can i find the client driver? With Which events of Server Side Trace or Profiler trace?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

session is single_user mode, or the database?

if it's the database,

you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who's currently in it via sp_who2:

this worked for me, when i moved a database into single_user mode.

declare @RESULTS TABLE(

[WHORESULTSID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

[SPID] CHAR (5) NULL,

[INSERTDT] DATETIME NULL DEFAULT(GETDATE()),

[STATUS] VARCHAR(30) NULL,

[LOGIN] VARCHAR(30) NULL,

[HOSTNAME] VARCHAR(30) NULL,

[BLKBY] VARCHAR(30) NULL,

[DBNAME] VARCHAR(30) NULL,

[COMMAND] VARCHAR(30) NULL,

[CPUTIME] INT NULL,

[DISKIO] INT NULL,

[LASTBATCH] VARCHAR(30) NULL,

[PROGRAMNAME] VARCHAR(200) NULL,

[SPIDINT] INT NULL,

--column added in SQL 2008--REMOVE FOR sql2005

[REQUESTID] INT NULL

)

INSERT INTO @RESULTS(SPID,Status,Login,HostName,BlkBy,DBName,Command,CPUTime,DiskIO,LastBatch,ProgramName,SPIDINT,REQUESTID)

EXEC sp_who2

select * from @results where dbname in(select NAME from sys.databases where user_access_desc = 'SINGLE_USER')

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Thinky Night SSCommitted Points: 1663 More actions · Answer 2

I can look at concurrent sessions like above.

But, i want to trace these events with like a profiler tool. I can't catch the missed event.