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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.


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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

765 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