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?
Oscar TroncosoNetwork AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Have you tried to start the service manually...have you check the Event log for errors when you try to start the engine
0
Daniel_PLDB Expert/ArchitectCommented:
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
0
Oscar TroncosoNetwork AdministratorAuthor 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
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Daniel_PLDB Expert/ArchitectCommented:
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
0
Oscar TroncosoNetwork AdministratorAuthor Commented:
Daniel_PL My system not have a Drive E: only C:
thanks for you reply, Anyway, I'm going to check the logs
0
Daniel_PLDB Expert/ArchitectCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.