Ryfujk

Can anything be seen from the center of the Boötes void? How dark would it be?

How does the math work when buying airline miles?

What is a fractional matching?

What does it mean that physics no longer uses mechanical models to describe phenomena?

What's the meaning of "fortified infraction restraint"?

How to write the following sign?

How could we fake a moon landing now?

Is there any word for a place full of confusion?

How do I find out the mythology and history of my Fortress?

Can a new player join a group only when a new campaign starts?

SF book about people trapped in a series of worlds they imagine

Is there hard evidence that the grant peer review system performs significantly better than random?

How much damage would a cupful of neutron star matter do to the Earth?

Question about debouncing - delay of state change

What initially awakened the Balrog?

Most bit efficient text communication method?

Hangman Game with C++

Do any jurisdictions seriously consider reclassifying social media websites as publishers?

Significance of Cersei's obsession with elephants?

Why does the remaining Rebel fleet at the end of Rogue One seem dramatically larger than the one in A New Hope?

Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?

Generate an RGB colour grid

What would you call this weird metallic apparatus that allows you to lift people?

What do you call the main part of a joke?

Rename the wsus database susdb before install (SQL Database)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

1

is it possible to rename the wsus database, on a SQL Server, before install the role?

In our company we have two wsus server, one for the client laptops and pc's and the other for our datacenter server. The problem is that i cannot have two databases named 'SUSDB'. Is there a way that i can rename the Database before deploying the Database onto the SQL Server. I know that i can rename the database in the registry after the installation but this is a dirty way and can cause problems.

Thanks and kind regards

Thommy

sql wsus

share|improve this question

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

bumped to the homepage by Community♦ 9 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a reason you don't have one WSUS and two WSUS groups?
  
  – mzhaase
  Sep 21 '16 at 11:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  We simply dont want to have it at one server because the administration is separated as well. So should the two servers be separated. Thanks for your reply
  
  – Thomas42
  Sep 21 '16 at 11:45
  
  
  

  
  
  
  

add a comment | 

1

is it possible to rename the wsus database, on a SQL Server, before install the role?

In our company we have two wsus server, one for the client laptops and pc's and the other for our datacenter server. The problem is that i cannot have two databases named 'SUSDB'. Is there a way that i can rename the Database before deploying the Database onto the SQL Server. I know that i can rename the database in the registry after the installation but this is a dirty way and can cause problems.

Thanks and kind regards

Thommy

sql wsus

share|improve this question

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

bumped to the homepage by Community♦ 9 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a reason you don't have one WSUS and two WSUS groups?
  
  – mzhaase
  Sep 21 '16 at 11:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  We simply dont want to have it at one server because the administration is separated as well. So should the two servers be separated. Thanks for your reply
  
  – Thomas42
  Sep 21 '16 at 11:45
  
  
  

  
  
  
  

add a comment | 

is it possible to rename the wsus database, on a SQL Server, before install the role?

In our company we have two wsus server, one for the client laptops and pc's and the other for our datacenter server. The problem is that i cannot have two databases named 'SUSDB'. Is there a way that i can rename the Database before deploying the Database onto the SQL Server. I know that i can rename the database in the registry after the installation but this is a dirty way and can cause problems.

Thanks and kind regards

Thommy

sql wsus

share|improve this question

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

share|improve this question

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

share|improve this question

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

asked Sep 21 '16 at 11:00

Thomas42Thomas42

62

3 Answers
3

active

oldest

votes

0

I don't know of any way to change the default name during install. You're probably stuck with renaming the database later.

I'd install the second server onto WID and move the new database onto SQL with a new name to avoid any downtime for the existing WSUS server.

(You'd need to edit the registry on the new server to change HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlServerName to be your SQL Server and HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlDatabaseName to be the second database, but it sounds like you know that.)

share|improve this answer

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

add a comment | 

0

1.Install the first WSUS sever and use MSSSQL with default SUSDB name.

2.Install the second WSUS server and use the WID database as a store.

3.Setup second as you wish (Central Management-replica, Distributed or Independent like you wish)

share|improve this answer

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

add a comment | 

0

I know this is an old post, but another option that increases the administration separation of the two servers is ask for a new instance on the SQL server and point the new WSUS install to the new instance. No moving of DBs or messing with the registry, keeps it clean all the way around.

share|improve this answer

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f804431%2frename-the-wsus-database-susdb-before-install-sql-database%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I don't know of any way to change the default name during install. You're probably stuck with renaming the database later.

I'd install the second server onto WID and move the new database onto SQL with a new name to avoid any downtime for the existing WSUS server.

(You'd need to edit the registry on the new server to change HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlServerName to be your SQL Server and HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlDatabaseName to be the second database, but it sounds like you know that.)

share|improve this answer

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

add a comment | 

0

I don't know of any way to change the default name during install. You're probably stuck with renaming the database later.

I'd install the second server onto WID and move the new database onto SQL with a new name to avoid any downtime for the existing WSUS server.

(You'd need to edit the registry on the new server to change HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlServerName to be your SQL Server and HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlDatabaseName to be the second database, but it sounds like you know that.)

share|improve this answer

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

add a comment | 

I don't know of any way to change the default name during install. You're probably stuck with renaming the database later.

I'd install the second server onto WID and move the new database onto SQL with a new name to avoid any downtime for the existing WSUS server.

(You'd need to edit the registry on the new server to change HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlServerName to be your SQL Server and HKLMSOFTWAREMicrosoftUpdateServicesServerSetupSqlDatabaseName to be the second database, but it sounds like you know that.)

share|improve this answer

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

share|improve this answer

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

answered Oct 7 '16 at 22:07

Katherine VillyardKatherine Villyard

17.9k42857

0

1.Install the first WSUS sever and use MSSSQL with default SUSDB name.

2.Install the second WSUS server and use the WID database as a store.

3.Setup second as you wish (Central Management-replica, Distributed or Independent like you wish)

share|improve this answer

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

add a comment | 

0

1.Install the first WSUS sever and use MSSSQL with default SUSDB name.

2.Install the second WSUS server and use the WID database as a store.

3.Setup second as you wish (Central Management-replica, Distributed or Independent like you wish)

share|improve this answer

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

add a comment | 

1.Install the first WSUS sever and use MSSSQL with default SUSDB name.

2.Install the second WSUS server and use the WID database as a store.

3.Setup second as you wish (Central Management-replica, Distributed or Independent like you wish)

share|improve this answer

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

share|improve this answer

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

edited Oct 10 '16 at 21:03

Citizen

9391718

edited Oct 10 '16 at 21:03

Citizen

9391718

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

answered Oct 6 '16 at 14:36

Slawomir BilinskiSlawomir Bilinski

1

0

I know this is an old post, but another option that increases the administration separation of the two servers is ask for a new instance on the SQL server and point the new WSUS install to the new instance. No moving of DBs or messing with the registry, keeps it clean all the way around.

share|improve this answer

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

add a comment | 

0

I know this is an old post, but another option that increases the administration separation of the two servers is ask for a new instance on the SQL server and point the new WSUS install to the new instance. No moving of DBs or messing with the registry, keeps it clean all the way around.

share|improve this answer

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

add a comment | 

I know this is an old post, but another option that increases the administration separation of the two servers is ask for a new instance on the SQL server and point the new WSUS install to the new instance. No moving of DBs or messing with the registry, keeps it clean all the way around.

share|improve this answer

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

share|improve this answer

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11

answered Feb 22 '18 at 19:03

David KenneyDavid Kenney

11