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
Solved

Install SQL Server 2012 issues

Posted on 2015-02-03
11
180 Views
Last Modified: 2016-02-18
I had many issues trying to install SQL Server 2012 on Windows 2012 VM. My first issue was trying to setup Data and Log files on different drives on the server. I was able to get past that issue but now I am getting permission issues. I am an Administrator on the domain, so I should have all permissions to do everything. I log into SQL Server with Windows Authentication and the Database Engine comes up fine but when I try to connect to SSAS or SSIS I get a permission denied error. I looked st the Analysis Services Service and tried to start it and I cannot. It gives me a generic error that says that it stops when its not being used. I have a feeling that during the install I should have done a mixed mode for the logins. I dont really know what to do or what will be the best way to do this but I need FULL access for my login, or create a group, with me in it,  with full permissions to do everything. Can someone simplify this for me? I can uninstall and re install if I need to so any help would really help me out big time....
Thanks everyone
John
0
Comment
Question by:jknj72
  • 6
  • 4
11 Comments
 
LVL 5

Expert Comment

by:R. Toby Richards
ID: 40586741
You do need mixed mode login for this. If, after re-installing with mixed  mode your domain account doesn't have the access that you need, then login as "sa", and grant yourself or your group whatever permissions you wish.
0
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40586795
integration services require  that you are a LOCAL admin on the machine
0
 
LVL 5

Expert Comment

by:R. Toby Richards
ID: 40586807
Domain Admins are automatically local admins... unless the machine is not in the domain.
0
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.

 

Author Comment

by:jknj72
ID: 40586982
I have admin privs on everything. I had a problem with my install and because it is a VM setup he had to fix a setting that would allow me the access. Now I am having similar issues because if Im admin and my login in SQL, using Windows Authentication, I set myself up with sa permissions and the ability to do anything I need but somehow I cant run certain things. Would the system Services accounts have to be setup to run? Would I need to configure      
NT Service\MSSQLServerOLAPService account(or any of them for that matter) for it to run the service?
0
 
LVL 5

Expert Comment

by:R. Toby Richards
ID: 40586990
Just set the services to automatic. After that, you may have to log into SSAS and SSIS with sa to give yourself rights to those modules as well.
0
 

Author Comment

by:jknj72
ID: 40587006
Im not sure how to login as sa because im using windows auth and didnt install in mixed mode. Is this something I would do? I am able to start the Analysis service if I do it with local instead of network service(?) Also, I gave my login  every permission that sa has but I wanna get this right so let me know what you think I should do
0
 

Author Comment

by:jknj72
ID: 40587007
and the service is set to auto its just the logon that I am questioning
0
 
LVL 5

Accepted Solution

by:
R. Toby Richards earned 500 total points
ID: 40587075
Yeah. You really should re-install with mixed mode.
0
 

Author Comment

by:jknj72
ID: 40587108
ok Im uninstalling now. I will let you know when I get to that point
0
 

Author Comment

by:jknj72
ID: 40587275
ok well I installed it in Mixed mode and created an sa password and looged into SQL Server with sa and everything works...The OLAP service started without a hitch too so I think Im on my way here. Thanks Toby
0
 

Author Closing Comment

by:jknj72
ID: 40587277
thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

809 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