Search This Blog

Wednesday, March 3, 2010

Setup failed to install SMS Provider

Sometimes when you install SCCM and the database is located on remote server, you will get this error message "Setup failed to install SMS Provider".

Workaround:-
Execute this command on SCCM server.

setspn -A MSSQLSvc/myserver.mydomain.com:1433 mydomain\accountname


In this example, "myserver" is the host name of the server that is running SQL Server, "mydomain" is the Windows domain name, and "accountname" is the domain account under which SQL Server is running.