Allow Windows Authentication with specified credentials

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Allow Windows Authentication with specified credentials

Postby paulo.morgado » Mon May 04, 2009 8:42 am

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/ar ... tudio.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
paulo.morgado
 
Posts: 52
Joined: Wed Aug 16, 2006 3:41 pm
Location: Portugal

Postby Chris Auckland » Wed May 06, 2009 8:26 pm

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

Postby paulo.morgado » Wed May 06, 2009 11:10 pm

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? :D
Paulo Morgado
Portugal
Web Site
Weblog
Twitter
paulo.morgado
 
Posts: 52
Joined: Wed Aug 16, 2006 3:41 pm
Location: Portugal

Postby Michelle Taylor » Thu May 07, 2009 11:15 am

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.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Postby creatorbri » Mon Dec 16, 2013 6:11 pm

Is this feature available in the latest version of SQL Compare?
creatorbri
 
Posts: 4
Joined: Mon Sep 16, 2013 7:15 pm


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests