Cloud and Microsoft technologies enthusiast architect in Switzerland RSS 2.0
# Monday, July 04, 2005

Une fois un SQL-Server et un BizTalk Server 2004 installés, il est loin d'être trivial, ensuite, de modifier le nom du serveur hébergeant ces services.

Le service de Single Sign-On est d'ailleurs le plus embêtant à remettre sur ses pieds. Le plus simple restant encore à rechercher les occurences de l'ancien nom du serveur dans la base de registre et de les remplacer par le nouveau nom (en tout cas là où cela est pertinent...).

En revanche, l'exécution de l'outil de configuration de BTS2004 (ConfigFramework.exe) va échouer sur la modification des jobs que BTS2004 installe dans SQL-Server. La cause de l'erreur provient du fait que le serveur ayant généré ce job n'est plus le même que celui qui essaye de le modifier. Pour éviter ceci, il est possible d'exécuter la commande SQL suivante (dans le cas où il n'y aurait que des jobs BizTalk. Dans le cas contraire, il faudra filtrer la requête) :

UPDATE msdb.dbo.sysjobs SET originating_server = @@SERVERNAME WHERE
originating_server <> @@SERVERNAME

Ceci à pour effet de changer le nom du serveur original du job.

A noter que changer le nom d'un serveur hébergeant déjà des services tels que BizTalk n'est pas recommandé et ceci fait donc déjà partie des bidouilles...

 

Once SQL-Server and BizTalk Server 2004 installed, it is very hard to change the server name.

The Single Sign-On is one of the most difficult to fix afterward. The way I found is to search-and-replace all occurences of the old server name by the new one in the registry.

On the other hand, running the BTS2004 configuration tool (ConfigFramework.exe) will fail on the update of the BTS2004 SQL jobs. The root cause of this is that the server which generated these jobs is not the same as the one attempting to update them. To avoid this, it is possible to run the following SQL command (in the case of all jobs are Biztalk jobs. If not, you have to add a filter to your request) :

UPDATE msdb.dbo.sysjobs SET originating_server = @@SERVERNAME WHERE
originating_server <> @@SERVERNAME

This will change all originating server of all jobs.

Please notice that to change the server name hosting services like SQL-Server or BizTalk is absolutely not a recommended way...

Monday, July 04, 2005 2:54:29 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] -
BTS2004 | Programming | Technical
All comments require the approval of the site owner before being displayed.
OpenID
Please login with either your OpenID above, or your details below.
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

Live Comment Preview
Google Cloud Platform Certified Professional Cloud Architect
Ranked #1 as
French-speaking SharePoint
Community Influencer 2013
Navigation
Currently Reading :
I was there :
I was there :
I was exhibiting at :
I was there :
I was a speaker at :
I was a speaker at :
I was a speaker at
(January 2013 session):
I was a speaker at :
I was a speaker at :
United Nations (UN) SharePoint Event 2011
I was a speaker at :
I was there !
I was there !
I was there !
I was there !
Archive
<October 2021>
SunMonTueWedThuFriSat
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2021
Yves Peneveyre
Sign In
Statistics
Total Posts: 290
This Year: 0
This Month: 0
This Week: 0
Comments: 20
Themes
Pick a theme:
All Content © 2021, Yves Peneveyre
DasBlog theme 'Business' created by Christoph De Baene (delarou)