Logo GNT
Actualités Tests & Guides Bons Plans
Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11
Entraide Windows Windows Serveur SQL Serveur Impossible d'utiliser Surface Area manager

Impossible d'utiliser Surface Area manager

2 réponses
Avatar
Dimitri
Bonjour,

Voil=E0 , j'ai install=E9 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 :

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

Alter failed. (Microsoft.SqlServer.Smo)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=3DMicrosoft+SQL+Server&ProdVer=3D9.=
00.3042.00&EvtSrc=3DMicrosoft.SqlServer.Management.Smo.ExceptionTemplates.F=
ailedOperationExceptionText&EvtID=3DAlter+Configuration&LinkId=3D20476

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

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Could not load file or assembly 'Microsoft.SqlServer.BatchParser,
Version=3D9.0.242.0, Culture=3Dneutral, PublicKeyToken=3D89845dcd8080cc91'
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(Stri=
ng
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(Stri=
ngCollection
sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringC=
ollection
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=E9es en remote et en local ...
Si quelqu'un a une id=E9e.
Merci
Dimitri
Signaler un problème avec ce contenu

2 réponses

Supprimer
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
Avatar
Philippe TROTIN [MS]
SQL Browser est il démarré ?

Cordialement
_______________________________

Philippe TROTIN
Microsoft Services France
_______________________________
"Dimitri" a écrit dans le message de
news:
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 476

------------------------------
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‰845dcd8080cc91'
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
Avatar
Dimitri
Oui, il est démarré .
cdlt
Dimitri


SQL Browser est il démarré ?

Cordialement
_______________________________