I am trying to set up roundhouse deployment scripts. I am running into a little trouble with remote logins. We need to login with an sql account (not machine or domain - this is against MSSQL 2008R2 on Server 2008 R2 SP1) when creating the database on remote servers. Is there any way to provide different credentials for roundhouse to connect and run scripts as, I am not seeing it in the documentation? Thanks.
Asked
Active
Viewed 1,429 times
1 Answers
4
If you specify the connection string instead of the server name and db name, you can then set the credentials as well.
From: https://github.com/chucknorris/roundhouse/wiki/ConfigurationOptions
There is the --connectionstring (or -c for short):
-c, --cs, --connstring, --connectionstring=VALUE
ConnectionString - As an alternative to ServerName and Database - You can provide an entire connection string instead.
So you could do something like this:
-c=server=localhost;uid=SomeUser;pwd=Secret;database=MyDB;
Joel Beckham
- 18,254
- 3
- 35
- 58
-
I don't know how I missed that page. Thanks, that is exactly what I was looking for. – JMorgan Aug 03 '11 at 14:39
-
No worries. It took me forever to even realize that there was documentation. – Joel Beckham Aug 03 '11 at 15:44
-
Documentation used to only be in the word document files that were included in the source. Started moving it to a wiki back in June. – ferventcoder Aug 11 '11 at 04:48
-
@ferventcoder - Thanks for moving it to the wiki. It's much easier to use there. – Joel Beckham Aug 11 '11 at 18:08