Dimitri,
You wrote: "I installed an authority SQL server 2005 SP2 on a serverWindows
2003 SP1. When I launch Surface Area manager to configure my authority, I
need to activate xp_cmdshell, I have the error message as below."
The error message does not mean anything to me. Did anything get written to
your logs that might make to problem clearer?
RLF

[quoted text, click to view]
Bonjour,

Voilà , j'ai installé une instance SQL server 2005 SP2 sur un serveur
windows 2003 SP1.
Lorsque je lance le surface Area manager pour configurer mon instance,
j'ai besoin d'activer xp_cmdshell, j'ai le message d'erreur ci
dessous :

==================================

Alter failed. (Microsoft.SqlServer.Smo)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476

------------------------------
Program Location:

at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean
overrideValueChecking)
at Microsoft.SqlSac.Public.Smo.SetSetting(Credentials credentials,
DatabaseFeature feature, Int32 value)
at
Microsoft.SqlSac.MainPanel.UserControlSSxp_cmdshell.ProcessOK(HashKey
givenKey, String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.commitDBChanges()
at Microsoft.SqlSac.MainPanel.FormFeatures.commitChanges()

===================================

Could not load file or assembly 'Microsoft.SqlServer.BatchParser,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
or one of its dependencies. The system cannot find the file specified.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at
Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String
query, ExecutionTypes executionType, Int32& statementsToReverse)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection
queries)
at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.DoAlter(Boolean
overrideValueChecking)
at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean
overrideValueChecking)

Mon compte de service est bien administrateur de la machine. Les
connexions pipe et tcp/ip sont activées en remote et en local ...
Si quelqu'un a une idée.
Merci
Dimitri

Babel Fish English to French:
Le message d'erreur ne signifie rien à moi. Est-ce que quelque chose a
obtenu écrit à vos notations qui pourraient rendre au problème plus clair ?
[quoted text, click to view]
Bonjour,

Voilà , j'ai installé une instance SQL server 2005 SP2 sur un serveur
windows 2003 SP1.
Lorsque je lance le surface Area manager pour configurer mon instance,
j'ai besoin d'activer xp_cmdshell, j'ai le message d'erreur ci
dessous :

==================================

Alter failed. (Microsoft.SqlServer.Smo)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476

------------------------------
Program Location:

at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean
overrideValueChecking)
at Microsoft.SqlSac.Public.Smo.SetSetting(Credentials credentials,
DatabaseFeature feature, Int32 value)
at
Microsoft.SqlSac.MainPanel.UserControlSSxp_cmdshell.ProcessOK(HashKey
givenKey, String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.commitDBChanges()
at Microsoft.SqlSac.MainPanel.FormFeatures.commitChanges()

===================================

Could not load file or assembly 'Microsoft.SqlServer.BatchParser,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
or one of its dependencies. The system cannot find the file specified.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at
Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String
query, ExecutionTypes executionType, Int32& statementsToReverse)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection
queries)
at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.DoAlter(Boolean
overrideValueChecking)
at
Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean
overrideValueChecking)

Mon compte de service est bien administrateur de la machine. Les
connexions pipe et tcp/ip sont activées en remote et en local ...
Si quelqu'un a une idée.
Merci
Dimitri