sql server express on domain controller

Oscar Troncoso
Oscar Troncoso used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
Have you tried to start the service manually...have you check the Event log for errors when you try to start the engine
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
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
Oscar TroncosoNetwork Administrator

Author

Commented:
The sql server express is not installed on RO DC
Attach Event viewer errorssql server express starting servicesqlserver express event viewer1sql server express event viewer1thks
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
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
Oscar TroncosoNetwork Administrator

Author

Commented:
Daniel_PL My system not have a Drive E: only C:
thanks for you reply, Anyway, I'm going to check the logs
DB Expert/Architect
Top Expert 2011
Commented:
How did you install this instance then? You can fix these paths by editing startup parameters. Simplest way is to go to SQL Server Configuration Manager, click on SQL Server Services. Right click you SQL Server Express Instance, choose properties, then pick startup paramters tab. Edit each by putting correct path to each folder. Please note there are no spaces between parameter and path.

Regards,
Daniel
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial