Re: Reinstall of SMS 2003 has no Status Messages
From: Luke Packard [MSFT] (lukep_at_online.microsoft.com)
Date: 01/15/05
- Next message: Cathy Moya [MS]: "Re: Site Assignment for VPN-Remote Advanced Clients"
- Previous message: Roderick: "Re: Can't set SMS Service account, optionis greyed out."
- In reply to: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Next in thread: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Reply: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 16:07:34 -0800
The site server machine account cannot authenticate with the SQL server.
Verify the SQL SPN is correctly registered in AD.
http://support.microsoft.com/default.aspx?scid=kb;en-us;829868.
If that isn't the problem test the connectivity by attempting to connect
from the site server to the admin$ share on the SQL server under the machine
account context. I do this by opening a cmd prompt under the machine account
context using the cmdasuser tool which you can find on the web. Then try to
net use to the SQL admin$ share. If this fails you may have a Kerberos or
DNS issue. If still fails test connectivity by the site server machine
account to other systems admin$ share that the account has admin rights to.
Then also test other machine account access to the SQL server in question.
This will determine if the problem is with the site server or the SQL
server. You may end having to unjoin and rejoin the problem machine from/to
the domain.
-- Luke Packard [MSFT] SMS 2003 Technical FAQ: http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/default.mspx This posting is provided "AS IS" with no warranties, and confers no rights. "OJM" <OJM@discussions.microsoft.com> wrote in message news:2BC1FDBB-BC01-4FD9-A912-014802C261EB@microsoft.com... > This is the error message recieved after clicking Finish during setup: > "The error is: > Either the SQL Server is in a Windows NT 4 domain or this computer's > machine > account does not have Administrator's privileges on the SQL Server. To > install a site in advanced security, all servers must be in Active > Directory > and the site server's machine account must have Administrator's privileges > on > the SQL Server. > > "Luke Packard [MSFT]" wrote: > >> Errors accessing SQL usually mean the SMS Service account does not have >> admin rights to the SQL server. Is the SMS site server and SQL server on >> the same box? Are you getting an error during SMSSetup (in the >> smssetup.log >> file) or post-setup in other log files? If so, please attach log >> excerpt. >> >> -- >> Luke Packard [MSFT] >> >> SMS 2003 Technical FAQ: >> http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/default.mspx >> >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> "OJM" <OJM@discussions.microsoft.com> wrote in message >> news:1BFFE101-9337-4B72-8124-C2C13325B6F7@microsoft.com... >> >I may be missing the obvious but I installed SMS 2003 and got some >> >unusual >> > errors so I uninstalled and reinstalled it and now I am not getting any >> > status messages. There are however multiple attempts in the log files >> > to >> > access the SQL database resulting in error. Is there something else >> > that >> > needs to be done on the server besides just doing the uninstall from >> > SMS >> > setup? >> >> >>
- Next message: Cathy Moya [MS]: "Re: Site Assignment for VPN-Remote Advanced Clients"
- Previous message: Roderick: "Re: Can't set SMS Service account, optionis greyed out."
- In reply to: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Next in thread: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Reply: OJM: "Re: Reinstall of SMS 2003 has no Status Messages"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
