Thanks for all suggestions and for trying to help.

New instance it wasn't migration. System DBs were not migrated.

Instances are new (user databases were migrated/restored from another environment).

Note: issue is not persistent. It happens randomly. Also it also hits different instances.

Lets say I am connecting to InstanceA, while it will always show as if connected to InstanceA,

the actual instance would be InstanceB and at some time "C", "D" or other. It is random and very strange.

"Sounds to me like someone migrated an instance incorrectly. For example, when we move from an existing machine to a new one we rename the server. Someone did not do this in your case. Was this server once a production server? Was the master database moved from another production server to this one?

Thanks,

Jared

SQL Know-It-All

"