Distributed Replay Error: Failed to set proper database for the connection

Category: sql server distributed

Question

Mike Cui on Fri, 18 Jul 2014 21:40:53


Hi,

I captured a trace file using 'tsql_replay' template on a source machine and am rerunning it on a target machine using Distributed Replay.

I restored the DB from source to target server with the same db_id, also created the same users with the same permissions.

When I tried to run the trace file against the target box using Distributed Replay, I got following error

Failed to set proper database for the connection

However if I rerun the trace using Profiler it works fine.

Does anyone have the same issue and how to fix it?

Thanks a lot!

Replies

Kashif147 on Wed, 14 Dec 2016 17:08:04


Hi, 

I recently had this problem and that i was giving a different database name to what it was captured in the replace trace file.

i hope this will resolve the issue by correcting the db name to match the trace file.

Best Regards,

Kashif