SPN Configuration
OK, I've done this several times before and have had no issues... so the command I think is correct. However I have no idea why it's failing. It says unknown parameter but the -A is used for adding and I think the syntax after that is correct. Help greatly appreciated! Thanks! C:\Users\Administrator>setspn.exe -A MSSQLSvc/serverA:1433 serverA\sqladmin Unknown parameter MSSQLSvc/VAUSSQL:1433. Please check your usage. Usage: setspn.exe [modifiers switch] [accountname] Where "accountname" can be the name or domain\name of the target computer or user account
July 12th, 2011 11:46pm

Have you tried using the FQDN for your SQLbox name? Miguel Rodriguez
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2011 11:53pm

I did... and odd I kept pasting the line in there, which I've done before and it failed. I had to type the whole thing out. Now I'm getting an error FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0 x0000054B; unable to locate account xyz which is odd that it can't find the account because it's local to the box.
July 13th, 2011 12:10am

You can't use a local user for an SPN. SPNs are used for mutual authentication in kerberos which requires a central authority like AD. You need to swicth your SQL Server service account to a domain one or better yet, if the instance is dedicated to ConfigMgr, just change it to local SYSTEM. The best practice does not apply in this case because there is no user interaction with the DB.Jason | http://myitforum.com/cs2/blogs/jsandys | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2011 12:27am

Thanks Jason, problem resolved. I know I've used domain accounts prior and it worked but I thought I read that it could use local authentication as well. Thanks for your help
July 13th, 2011 5:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics