Red Gate forums :: View topic - Allow Windows Authentication with specified credentials
Return to www.red-gate.com RSS Feed Available

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

Allow Windows Authentication with specified credentials

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
paulo.morgado



Joined: 16 Aug 2006
Posts: 52
Location: Portugal

PostPosted: Mon May 04, 2009 8:42 am    Post subject: Allow Windows Authentication with specified credentials Reply with quote

My company is implementing a policy where all connections to databases must be made using Windows Authentication.

On top of that, there are, at least, two domains (Production and Quality Assurance).

Connecting to a database with a single set of credentials is easy (see Tip: Connecting To A Database Using Windows Authentication With Different Credentials Using SQL Server Management Studio - http://msmvps.com/blogs/paulomorgado/archive/2009/05/04/tip-connecting-to-a-database-using-windows-authentication-with-different-credentials-using-sql-server-management-studio.aspx).

Comparing databases across domains has been, so far, impossible.

It would be nice to be able to specify the credentials for Windows Authentication.
_________________
Paulo Morgado
Portugal
Web Site
Weblog
Twitter
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed May 06, 2009 8:26 pm    Post subject: Reply with quote

Thanks for your post.

I can see why you would want to do this, so I have added your suggestion as a feature request.

Hopefully it will be considered for a future version of SQL Data Compare.

For your reference the feature tracking code is SDC-939.

As an alternative - and if the user is valid on the client machine, you can start SQL Compare UI with 'run as' and specify a different user.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
paulo.morgado



Joined: 16 Aug 2006
Posts: 52
Location: Portugal

PostPosted: Wed May 06, 2009 11:10 pm    Post subject: Reply with quote

Thanks Chris.

The problem with SQL Data Compare (and SQL Compare, for that matter) is when I need to compare databases from diffrent servers with different Windows credentials.

Will it make SQL Data Compare 8? Very Happy
_________________
Paulo Morgado
Portugal
Web Site
Weblog
Twitter
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Thu May 07, 2009 11:15 am    Post subject: Reply with quote

This feature is unlikely to make SQL Data Compare 8.0, I'm afraid - we're already at our quota of extra features that need UI work.
Back to top
View user's profile Send private message
creatorbri



Joined: 16 Sep 2013
Posts: 4

PostPosted: Mon Dec 16, 2013 6:11 pm    Post subject: Reply with quote

Is this feature available in the latest version of SQL Compare?
Back to top
View user's profile Send private message
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