Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11

install Server SQL 2005 en échec

3 réponses
Avatar
big
Bonjour,
mon installtion échoue et dans les logs j'ai :
SQL Server is terminating in response to a 'stop' request from Service
Control Manager. This is an informational message only. No user action is
required.
2010-02-10 12:03:34.05 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2010-02-10 12:03:34.07 Server The SQL Network Interface library could
not deregister the Service Principal Name (SPN) for the SQL Server service.
Error: 0x54b. Administrator should deregister this SPN manually to avoid
client authentication errors.

Merci pour votre aide.

3 réponses

Avatar
Med Bouchenafa
Google un peu sur "Setspn.exe"

Il faut ensuite utiliser cet outil pour derengistrer ton instance SQL Server

Bien cordialement
Med bouchenafa

"big" wrote in message
news:
Bonjour,
mon installtion échoue et dans les logs j'ai :
SQL Server is terminating in response to a 'stop' request from Service
Control Manager. This is an informational message only. No user action is
required.
2010-02-10 12:03:34.05 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2010-02-10 12:03:34.07 Server The SQL Network Interface library could
not deregister the Service Principal Name (SPN) for the SQL Server
service.
Error: 0x54b. Administrator should deregister this SPN manually to avoid
client authentication errors.

Merci pour votre aide.


Avatar
big
merci. J'ai téléchargé mais il l'execute pas :
C:Program FilesSupport Tools>Setspn -D optim65-win
Usage: Setspn [switches data] computername
Where "computername" can be the name or domainname

Switches:
-R = reset HOST ServicePrincipalName
Usage: setspn -R computername
-A = add arbitrary SPN
Usage: setspn -A SPN computername
-D = delete arbitrary SPN
Usage: setspn -D SPN computername
-L = list registered SPNs
Usage: setspn [-L] computername
"Med Bouchenafa" wrote:

Google un peu sur "Setspn.exe"

Il faut ensuite utiliser cet outil pour derengistrer ton instance SQL Server

Bien cordialement
Med bouchenafa

"big" wrote in message
news:
> Bonjour,
> mon installtion échoue et dans les logs j'ai :
> SQL Server is terminating in response to a 'stop' request from Service
> Control Manager. This is an informational message only. No user action is
> required.
> 2010-02-10 12:03:34.05 spid5s SQL Trace was stopped due to server
> shutdown. Trace ID = '1'. This is an informational message only; no user
> action is required.
> 2010-02-10 12:03:34.07 Server The SQL Network Interface library could
> not deregister the Service Principal Name (SPN) for the SQL Server
> service.
> Error: 0x54b. Administrator should deregister this SPN manually to avoid
> client authentication errors.
>
> Merci pour votre aide.



Avatar
Med Bouchenafa
Lorsque je disais qu'il fallait faire une recherche Google sur "SETSPNEXE"
je voulais surtout dire qu'il fallait se documenter comment l'utiliser
Car lá, il est mal utilisé dans ta commande Setspn -D optim65-win
Il manque le nom de service SPN que tu peux retrouver avec SETSPN -L

Demande de l'aide á ton administeur de domaine

Bien cordialement
Med bouchenafa

"big" wrote in message
news:

merci. J'ai téléchargé mais il l'execute pas :
C:Program FilesSupport Tools>Setspn -D optim65-win
Usage: Setspn [switches data] computername
Where "computername" can be the name or domainname

Switches:
-R = reset HOST ServicePrincipalName
Usage: setspn -R computername
-A = add arbitrary SPN
Usage: setspn -A SPN computername
-D = delete arbitrary SPN
Usage: setspn -D SPN computername
-L = list registered SPNs
Usage: setspn [-L] computername
"Med Bouchenafa" wrote:

Google un peu sur "Setspn.exe"

Il faut ensuite utiliser cet outil pour derengistrer ton instance SQL
Server

Bien cordialement
Med bouchenafa

"big" wrote in message
news:
> Bonjour,
> mon installtion échoue et dans les logs j'ai :
> SQL Server is terminating in response to a 'stop' request from Service
> Control Manager. This is an informational message only. No user action
> is
> required.
> 2010-02-10 12:03:34.05 spid5s SQL Trace was stopped due to server
> shutdown. Trace ID = '1'. This is an informational message only; no
> user
> action is required.
> 2010-02-10 12:03:34.07 Server The SQL Network Interface library
> could
> not deregister the Service Principal Name (SPN) for the SQL Server
> service.
> Error: 0x54b. Administrator should deregister this SPN manually to
> avoid
> client authentication errors.
>
> Merci pour votre aide.