--Text was encrypted - but it is not!

Ozzie

Hey Red Gate,

I am comparing 3 servers together. Server B, in one compare against Server A, has all of my column default constraint values visible. However when I compare Server B to Server C , it says all of Server B's default column constraints are encrypted.

This happened today in 7.0 - and is still happening with the 7.1 update I downloaded a moment ago after a reboot and a prayer. What can I do to correct this - this is a pretty impactful situation for me?

Thanks,
Doug

Chris Auckland

Thanks for your post.

In both scenarios, are you connecting to server B using the same account and project options?

Also, what account are you using to connect to the other databases?

It might be worth checking the permissions; we have a kb document to outline the minimum permissions required for SQL Compare:
http://www.red-gate.com/supportcenter/C ... 000072.htm

aspnerd

Chris Auckland wrote:

Thanks for your post.

In both scenarios, are you connecting to server B using the same account and project options?

Also, what account are you using to connect to the other databases?

It might be worth checking the permissions; we have a kb document to outline the minimum permissions required for SQL Compare:
http://www.red-gate.com/supportcenter/C ... 000072.htm

So where is this KB article? it's a dead link

Chris Auckland

Sorry about that. The article was retired quite some time ago.

This is the current one:
http://www.red-gate.com/supportcenter/C ... quired.htm

aspnerd

Chris Auckland wrote:

Sorry about that. The article was retired quite some time ago.

This is the current one:
http://www.red-gate.com/supportcenter/C ... quired.htm

Thank You!