May 26, 2016 at 8:19 am
Experts,
I'm begging for you help. I tried to install SQL Server 2014 on window server 2012 R2 but it failed when it tried to start the DB engine. Please give me the advice and thank you for your help. I will include the screenshot (attachment) and log error below.
Error:
The MSSQL$SQLSERVER2014 service was unable to log on as NT Service\MSSQL$SQLSERVER2014 with the currently configured password due to the following error:
This user isn't allowed to sign in to this computer.
To ensure that the service is configured properly, use the Services snap-in in Microsoft Management Console (MMC).
May 27, 2016 at 8:36 am
I would un-install what you were able to install (add/remove programs), if anything, reboot, and re-start the 2014 installation from scratch. Instead of using the default logins for the services seen when you are running the install wizard, I would either create a domain account or a local admin account and ensure that is in the admin group on the server and re-run the installation. It sounds and looks like there is some permission issue or problem with the account the error mentions. Of course when you rerun the installation, you will let this new account run some or all of the sql services. I would be interested if you still see your error after attempting the reinstall.
May 27, 2016 at 11:12 am
I log in as administrator, tried to uninstall and reinstall hundred of times, still got the same error. My best guess is permission issue but couldn't narrow down what's causing it.
May 27, 2016 at 11:29 am
Right, not the login you are using to login to the sql server to run the install, but, was referring to setting the logins for the sql services inside the installation wizard screen when it calls for them instead of using the defaults. You could still get that error you are getting even though you are logged into the server you are installing sql using an administrator account. Hope this makes sense...
May 27, 2016 at 11:35 am
...NT Service\MSSQL$SQLSERVER2014 with the currently configured password due to the following error:
This user isn't allowed to sign in to this computer.
The problem isn't your login. It's the service login.
The solution will be:
Use a different service login, one that has the necessary rights on that server
or
Fix the service login, either in local or AD permissions
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply