|
|
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 |