Solved

Server 2008 - can't add users to local admin

Posted on 2009-06-29
8
1,629 Views
Last Modified: 2012-05-07
i have a new 2008 network - 2 2008 DCs (64bit) and a few member servers.

I have a SQL server - running on a fresh 2008/64 install (fully patched)
I created a user SERVICESQL and added to all teh domain type admin accoutns.
i can log in to the server, but I can't run the sql setup as the user - I get a permissions error (can't access file)

If I log in as administrator@domain I can run setup fine.

during the sql setup -there is a place to add other admins - when I try to add the sql account I get 'SVC SQL: No mapping between account names and Security IDs was done"

I also can't add any domain accounts in the local users under Administrators - when I try to add domain admins - it complains they are already there...

0
Comment
Question by:erikwhiteway
  • 3
  • 2
  • 2
  • +1
8 Comments
 

Author Comment

by:erikwhiteway
ID: 24738953
Don't know if it matters - but all the machine are running in HV on 64 bit bases. (also on the domain)
0
 
LVL 59

Accepted Solution

by:
Darius Ghassem earned 300 total points
ID: 24739002
0
 
LVL 5

Expert Comment

by:CoSmismgr
ID: 24739050
So you created the user "SERVICESQL" in Active Directory and then added this user to the domain\Administrator group?

If so, go into SQL server mgmt studio, connect using Windows authentication and then make sure that user is a member of the BUILTIN\Administratoors under Security | Logins
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:erikwhiteway
ID: 24739083
i think it may be a problem with the server SID - the macheine is an export / import of a generic HV base (befoer added to the doamin) but looks LIKE HV did not redo the sid Ilike I thought it would.

Just looking for a SID tool now
0
 
LVL 5

Expert Comment

by:CoSmismgr
ID: 24739136
Logging into the server as that windows user should solve the SID issue.
0
 
LVL 10

Assisted Solution

by:Datedman
Datedman earned 200 total points
ID: 24739207
There's a program called NEWSID at http://technet.microsoft.com/en-us/sysinternals/bb897418.aspx

Might want to temp. disjoin the domain before using it.
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 24739231
That most likely is your underlining issue.
0
 

Author Comment

by:erikwhiteway
ID: 24739368
Looks lik ethe SID was the problem - export/import a generic HV install - renaming - and adding to the domain did not fix the SID.

I ran the tool - then removed and re-added to the domain (Shoudl have removed FIRST - then sid changed)

thanks
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question