|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
Hello
I can't seem to get my testsetup working with the WH Backup Wizard. My setup is one webserver with two shares dbbackup and dbupload, as described in the manual. Then i have 4 SQL Server 2005 instances running on a cluster. Each instance have unique sa passwords.
The WH Backup works fine on the first instance as it have the correct password for the sa account configured in web.config.
But what do I do about the remaining 3 instances where myLittleSQLAdmin have the wrong password. I have tried the following.
In web.config added a SysAdminLogin_2 and SysAdminPassword_2 but that crashes the application. Do I have to configure all SQL instances with the same sa password?
Regards Bo
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
You should be able to define each sa password. In the config xml, you must specify a unique sysadminconnectionid for each server. Then in the web.config, you can add SysAdminLogin_ id and SysAdminPassword_ idFor instance: config.xml Code: <sqlservers> <sqlserver address="Srv1\Inst" name="SQL 001" sysadminconnection="true" sysadminconnectionid="1" /> <sqlserver address="Srv2\Inst" name="SQL 002" sysadminconnection="true" sysadminconnectionid="2" /> </sqlservers>
web.config Code: <add key="SysAdminLogin_1" value="sa" /> <add key="SysAdminPassword_1" value="pwdABCD" /> <add key="SysAdminLogin_2" value="sa" /> <add key="SysAdminPassword_2" value="pwd1234" />
|
|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
Thanks for the quick answer.
Do you have a place where I could see a list of possible key value pairs and their usage in the different configuration files?
|
|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
Here I'm thinking about the sysadminconnection key as you clarified the purpose of the sysadminconnectionid key.
|
|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
I have an additional question regarding the guide for translating myLittleAdmin.
In the guide you mention the Resourcer for .NET by Lutz Roeder. I have downloaded the program but it wont let me edit a .resources file.
What am I missing here?
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Supergoof wrote:Here I'm thinking about the sysadminconnection key as you clarified the purpose of the sysadminconnectionid key. This parameter has to be set to true if you want to use a sysadmin connection with the backup and restore wh wizards.
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Supergoof wrote:I have an additional question regarding the guide for translating myLittleAdmin.
In the guide you mention the Resourcer for .NET by Lutz Roeder. I have downloaded the program but it wont let me edit a .resources file.
What am I missing here? Weird... this is the resource editor we use and never had any trouble with it. Our version is 4.1.0.0 Anyway, you can use another resource editor if you prefer.
|
|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
My version is the latest 5.1.3.0 and I can't find a way to edit the file. I discovered that Lutz Roeder wrote an application that is directly aimed at .resources files here: http://www.lutzroeder.com/dotnet/ called Resourcer for .NET That works.
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Supergoof wrote:I discovered that Lutz Roeder wrote an application that is directly aimed at .resources files here: http://www.lutzroeder.com/dotnet/ called Resourcer for .NET That works. This is the one we were talking about, nope?
|
|
Rank: Member Groups: Member
Joined: 9/15/2008 Posts: 9 Points: 27 Location: Denmark
|
My bad.
I picked the Reflector
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
No prob...
|
|
Guest |