Re: SQL permission problem when installing SMS2003 in 2003 network
- From: "Cathy Moya [MS]" <camoya@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Apr 2005 09:02:12 -0700
And in case you want more information about security, see:
Scenarios and Procedures for SMS 2003: Security
available here:
http://www.microsoft.com/smserver/techinfo/productdoc/default.asp#G
There are several checklists to help you get all your security configured
properly.
--
Cathy Moya, CISSP, MCSE: Security
Technical Writer, Windows Enterprise Management Division User Assistance
Check out the SMS 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.
"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: Unable install client successfully
- Next by Date: Re: Unable install client successfully
- 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
|
