Error while replay a SQL profiler trace file

• Raymond XU

  SSC Veteran

  Points: 299

  More actions

  January 28, 2005 at 8:29 pm

  #162465

  HI all,

  I generated a trace file and backed up the databases on production, and then I restored the databases with exact same DBID on a test server, and created user with exact same password. while I replay the trace file, I found many errors like,

  [Microsoft][ODBC SQL Server Driver]Communication link failure (State 08S01) (Code 0)

  most of them is generated by a user account used by Application, and this user is not administrator account.

  another one, the profiler captured many sp_reset_connection, same error raised during replay this statement. I think it is becasue this procedure can not be called by SQL explicitly. but almost all the application SQL will generate this error. Anybody can help me?

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  January 31, 2005 at 6:43 am

  #539723

  Assumming you are using Mixed Mode authentication.....

  When you re-created the user ID are you sure that the user ID has permission to the database?

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.