Solved

Server 2008 - can't add users to local admin

Posted on 2009-06-29
8
1,634 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
[X]
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
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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

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…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

737 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