RE: SQL permission problem when installing SMS2003 in 2003 network

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

Relevant Pages

  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
Loading