Red Gate forums :: View topic - --Text was encrypted - but it is not!
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Compare Previous Versions
SQL Compare Previous Versions forum

--Text was encrypted - but it is not!

 Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Ozzie



Joined: 26 Jun 2007
Posts: 9
Location: Havertown, PA, USA
PostPosted: Wed Oct 08, 2008 9:52 pm    Post subject: --Text was encrypted - but it is not! Reply with quote
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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
PostPosted: Fri Oct 10, 2008 10:51 am    Post subject: Reply with quote
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/Content.aspx?p=SQL%20Compare&c=knowledgebase/SQL_Compare/KB200707000072.htm
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
aspnerd



Joined: 04 May 2011
Posts: 6
Location: Jacksonville, FL
PostPosted: Fri Mar 23, 2012 2:40 pm    Post subject: Re: Reply with quote
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/Content.aspx?p=SQL%20Compare&c=knowledgebase/SQL_Compare/KB200707000072.htm


So where is this KB article? it's a dead link
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Chris Auckland



Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
PostPosted: Fri Mar 23, 2012 2:41 pm    Post subject: Reply with quote
Sorry about that. The article was retired quite some time ago.

This is the current one:
http://www.red-gate.com/supportcenter/Content?p=SQL%20Compare&c=SQL_Compare/knowledgebase/SC_Permissions_Required.htm
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
aspnerd



Joined: 04 May 2011
Posts: 6
Location: Jacksonville, FL
PostPosted: Fri Mar 23, 2012 2:45 pm    Post subject: Re: Reply with quote
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/Content?p=SQL%20Compare&c=SQL_Compare/knowledgebase/SC_Permissions_Required.htm


Thank You!
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group