Re: Reinstall of SMS 2003 has no Status Messages

From: Luke Packard [MSFT] (lukep_at_online.microsoft.com)
Date: 01/14/05


Date: Fri, 14 Jan 2005 10:41:13 -0800

The user running SMS setup has admin rights to SQL as well correct? Please
send your smssetup.log to lukep@microsoft.com

-- 
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?
>>
>>
>> 


Relevant Pages

  • Cannot install SMS2003 Primary Site with SQL2000sp3a
    ... we got problems installing SMS 2003. ... it always pop a window say cannot locate the SQL Database or you dont have ... but we build that SQL Server 2000 sp3a right ...
    (microsoft.public.sms.setup)
  • Re: Moving SMS SQL Database
    ... We have a customer running SMS 2003 in Advanced Security with a remote SMS ... SQL database. ... They need us to move the database to a different server. ... groups and permissions referencing the OLD SQL Server ...
    (microsoft.public.sms.admin)
  • Re: SMS Maintenance Tasks missing
    ... Wait about 10 minutes and run ACLRESET (on both the SMS and SQL server). ... >>> installed SMS 2.0 with sp1 first which included the maintenance tasks? ...
    (microsoft.public.sms.setup)
  • Re: SMS 2003 & Remote SQL2000
    ... Be 100% positive, Kim, 'cause you're right. ... Check out the SMS Technical FAQ: ... but IIRC sms does not support named instances for sql. ... >>>> correct SQL server name." ...
    (microsoft.public.sms.setup)
  • Re: SMS and SQL intergration
    ... account/advanced security or service account/standard security) admin rights ... Check out the SMS Technical FAQ: ... > I am attempting to set up my SMS server using an SQL server that is ...
    (microsoft.public.sms.admin)