Category: sql server distributed
Mike Cui on Fri, 18 Jul 2014 21:40:53
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!
Kashif147 on Wed, 14 Dec 2016 17:08:04
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.