Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Server 2008 - can't add users to local admin

Posted on 2009-06-29
Medium Priority
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...

Question by:erikwhiteway
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1

Author Comment

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

Accepted Solution

Darius Ghassem earned 900 total points
ID: 24739002

Expert Comment

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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.


Author Comment

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

Expert Comment

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

Assisted Solution

Datedman earned 600 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.
LVL 59

Expert Comment

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

Author Comment

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)


Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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…

650 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