Oscar Troncoso
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?
The propose is install ADMT 3.2.
the installation finish, but cannot start the service.
Any idea?
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
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
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
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
ASKER
Daniel_PL My system not have a Drive E: only C:
thanks for you reply, Anyway, I'm going to check the logs
thanks for you reply, Anyway, I'm going to check the logs
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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.
Perhaps best thing to do is to reinstall.