Link to home
Create AccountLog in
Avatar of Oscar Troncoso
Oscar TroncosoFlag for Argentina

asked on

sql server express on domain controller

Hi, I need install sql server express on domain controller.
The propose is install ADMT 3.2.
the installation finish, but cannot start the service.
Any idea?
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Have you tried to start the service manually...have you check the Event log for errors when you try to start the engine
Hi,

You can't use Network Service or Local Service account for your SQL Server, what account did you choose?

Additionally, SQL Server is not supported on ReadOnly domain controller:
https://support.microsoft.com/en-us/help/2032911/you-may-encounter-problems-when-installing-sql-server-on-a-domain-cont

Regards,
Daniel
Avatar of Oscar Troncoso

ASKER

The sql server express is not installed on RO DC
Attach Event viewer errorsUser generated imageUser generated imageUser generated imagethks
Hi,

Your service sid account doesn't have access to it's data folders. I suggest to start off on E: drive. Add NT SERVICE\MSSQL$SQLEXPRESS user to list. Then, it depends on an inheritance settings, but I suggest to grant aforementioned account read & execute, list folder contents, read (the same as on root E: drive). These should stay until you get into DATA and LOG directories, both should be granted under FullControl to the SQL Server account.

Regards,
Daniel
Daniel_PL My system not have a Drive E: only C:
thanks for you reply, Anyway, I'm going to check the logs
ASKER CERTIFIED SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Looks like SQL Server wasn't properly installed. If drive E: doesn't exists, it existed during the installation and now it's complaining about it.
Perhaps best thing to do is to reinstall.