Install SQL Server 2012 issues
Posted on 2015-02-03
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....