Re: SQL permission problem when installing SMS2003 in 2003 network
- From: "Curtis Fray" <xxx@xxxxxxx>
- Date: Thu, 28 Apr 2005 12:52:05 +0100
Fantastic. That worked!!!
Thanks very much Kevin.
Curtis.
------------
"Kevin" <Kevin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3B3A442C-5CDC-43DF-A81C-C47C7B0048E9@xxxxxxxxxxxxxxxx
> Hey Curtis,
>
> I ran into that problem and this is what I did to fix it. The site
> server's computer name must be added as to the SQL server's local
> administrators group. Run this in the command prompt.
>
> "Net Localgroup Administrators <domain name>\<site server computer name>$
> /ADD"
>
> Best of Luck,
> Kevin
>
> "Curtis Fray" wrote:
>
>> Hi,
>>
>> I may need to put this post in an SQL newsgroup, but thought I'd start
>> here
>> first. Also, my SQL knowledge is practically zero, so please give as much
>> information as possible in any suggestions you have.
>>
>> I have a 2003 network. I've installed SQL2000 on ServerA. I'm trying to
>> install SMS2003 on ServerB. I'm installing it as Enterprise Admin so the
>> schema can be updated.
>>
>> When I try and install SMS2003 I get the following error:
>>
>> "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."
>>
>> All the server's are in AD so I'm guessing it's an SQL permissions
>> problem.
>> I'm not sure how, or where abouts in SQL I need to add these required
>> permissions. I've been trying to find the info in the manuals and help
>> files
>> without luck. I'm sure it's buried in there somewhere but I can't find
>> it.
>>
>> Thanks in advance.
>>
>> Curtis.
>> --
>> Please reply to news group only. Thank you.
>>
>>
>>
.
- References:
- Prev by Date: Client "Unable to retrieve AD site membership" error
- Next by Date: RE: SMS 2003, MSI Deployments
- Previous by thread: RE: SQL permission problem when installing SMS2003 in 2003 network
- Next by thread: Re: SQL permission problem when installing SMS2003 in 2003 network
- Index(es):
Relevant Pages
|
