--Text was encrypted - but it is not!

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

--Text was encrypted - but it is not!

Postby Ozzie » Wed Oct 08, 2008 9:52 pm

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
Ozzie
 
Posts: 18
Joined: Tue Jun 26, 2007 9:10 pm
Location: Havertown, PA, USA

Postby Chris Auckland » Fri Oct 10, 2008 10:51 am

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
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby aspnerd » Fri Mar 23, 2012 2:40 pm

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
aspnerd
 
Posts: 8
Joined: Wed May 04, 2011 5:03 pm
Location: Jacksonville, FL

Postby Chris Auckland » Fri Mar 23, 2012 2:41 pm

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
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby aspnerd » Fri Mar 23, 2012 2:45 pm

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!
aspnerd
 
Posts: 8
Joined: Wed May 04, 2011 5:03 pm
Location: Jacksonville, FL


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests