Competition: What’s your favorite Redgate tool? Enter now.

SQL COMPARE XML argfile encrypt username/password????

mfischermfischer Posts: 4
edited May 22, 2007 10:53AM in SQL Compare Previous Versions
We have an automated build process that includes sqlcompare command line for syncronizing tables and sprocs. I have a couple of questions:

Can we encrypt username/password in the xml argfile?

Do you know how to have it pass credentials using local accounts in a MS Cluster server. ?

I get an error in SSMS when I try to add the local account from a clustered server, I can browse out to find the user, it displays for me, it allows me to assign a database to the account, it allows me to select what roles but as soon as I click OK, it pops up an error:
WindowsNT user or Group 'CLUSTERSERVERNAME\USERNAME' not found.
Melissa Fischer
Database Administrator
Business and Information Technology Unit
MN Department of Employment and Economic Development
1st National Bank Building
332 Minnesota Street, Suite E 200
St. Paul, MN 55101

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    The XML argfile for SQLCOMPARE.exe does not have the ability to store encrypted information. What you could do is use a SQL Compare project file and call it using the /pr argument. The project file will contain an encrypted password for SQL authentication users.

    I'm fairly certain that MSCS cluster servers can only use domain accounts, as long as you're connecting through the virtual IP address of the cluster. Using a local account wouldn't be such a great idea anyway, as you will have authentication problems if the server ever fails over.

    Hopefully this helps!
Sign In or Register to comment.