Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Philippe Pham Minh [MS]
Bonjour,
Es-tu dans la configuration ci-dessous?
"Error 14117. Distribution is not configured as the distribution database."
Cause: This is due to the fact that the local server name has been changed to reflect a virtual server name as required by the Veritas clustering software you are using. We were able to determine the problem by running the following query:
If the server has been configured properly both the above queries should return the same name. But they had returned different names due to the fact that the sysservers entries have indeed been modified by using sp_dropserver and sp_addserver to accommodate the virtual server name for Veritas. This configuration is not supported by Microsoft.
Resolution: We corrected the sysservers entry by doing the following:
sp_dropserver 'Name1' go sp_addserver 'Name2', local go
Stop and restart SQL Server.
Philippe
"jm" a écrit dans le message de news:91eb01c3ea5f$356107d0$
Bonjour, Lors de la configuration du distributeur, msg erreur 14 117 Et configuration impossible Quelle solution ? Merci jm
Bonjour,
Es-tu dans la configuration ci-dessous?
"Error 14117. Distribution is not configured as the distribution database."
Cause:
This is due to the fact that the local server name has been changed to
reflect a virtual server name as required by the Veritas clustering software
you
are using. We were able to determine the problem by running the following
query:
If the server has been configured properly both the above queries should
return the same name. But they had returned different names due to the fact
that the
sysservers entries have indeed been modified by using sp_dropserver and
sp_addserver to accommodate the virtual server name for Veritas. This
configuration is not supported by Microsoft.
Resolution:
We corrected the sysservers entry by doing the following:
sp_dropserver 'Name1'
go
sp_addserver 'Name2', local
go
Stop and restart SQL Server.
Philippe
"jm" <informatique@nse-groupe.com> a écrit dans le message de
news:91eb01c3ea5f$356107d0$a001280a@phx.gbl...
Bonjour,
Lors de la configuration du distributeur, msg erreur 14 117
Et configuration impossible
Quelle solution ?
Merci
jm
"Error 14117. Distribution is not configured as the distribution database."
Cause: This is due to the fact that the local server name has been changed to reflect a virtual server name as required by the Veritas clustering software you are using. We were able to determine the problem by running the following query:
If the server has been configured properly both the above queries should return the same name. But they had returned different names due to the fact that the sysservers entries have indeed been modified by using sp_dropserver and sp_addserver to accommodate the virtual server name for Veritas. This configuration is not supported by Microsoft.
Resolution: We corrected the sysservers entry by doing the following:
sp_dropserver 'Name1' go sp_addserver 'Name2', local go
Stop and restart SQL Server.
Philippe
"jm" a écrit dans le message de news:91eb01c3ea5f$356107d0$
Bonjour, Lors de la configuration du distributeur, msg erreur 14 117 Et configuration impossible Quelle solution ? Merci jm
