INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL 2012 - SQL Analysis Service issue on install

SQL 2012 - SQL Analysis Service issue on install

(OP)
I am installing SQL 2012 for the first time. When I get to the Server Configuration section, all the services have preselected NT service accounts to run them except for the SQL Analysis Service. Looking at another existing SQL 2013 Server, it is using the NT Service\MSSQLServerOLAPService account. So I tried to manually enter this and when I try to move on to the next step of the installation, I get the error:

The username 'NT Service\MSSQLServerOLAPService' cannot be used in the domain controller.

What am I supposed to put here? I can easily create my own service account and use it, but I have never once in 8 years of working with SQL Server had to do this. I am assuming this is something new to SQL 2012. Any insights appreciated.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: SQL 2012 - SQL Analysis Service issue on install

Domain controllers are different in a number of ways. The problem is that you would need to create an account that is a local administrator. But on a domain controller, there are no local administrators, only domain administrators. Any way you can get a different machine?

RE: SQL 2012 - SQL Analysis Service issue on install

(OP)
No, the domain controller and the SQL server are one and the same.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: SQL 2012 - SQL Analysis Service issue on install

Can you select something like localservice, or network service?

RE: SQL 2012 - SQL Analysis Service issue on install

(OP)
No, I get the same error - cannot be used in the domain controller.

Having the SQL server also be the domain controller is a first for me while using SQL 2012. I wonder if that is an issue?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close