What SQL server 2014 features are mandatory?

[Former Member]

Hi All

I did SQL server 2014 installation for SAP B1 9.1, while installation there is stage feature selection i selected all features but due to domain controller was installed Analysis Services could't installed. What role these sql server features play for SAP and what features are necessary for SAP.

Please tell me what features are mandatory for SAP B1 9.1

Thanks & Regards]

Ankush

[former_member188586 · Accepted solution]

hi

here future installation > do Select All and Press next ,

for more about SQL server 2014 Post installation settings send me mail then i'll forward you one text file

Thanks

Ramudu

[Former Member · Accepted solution]

Thanks Ramudu for quick reply

I had installed sql server 2012 with all features on windows server 2008 R2 and then install SAP 9.0 all went fine even though domain controller was installed but while installing sql server 2014 it throws warning that it is not recommended to to install sql server with Analysis service on domain controller installed server. after that the feature Analysis service feature disabled.

please send me settings on ankush53@gmail.com.

Thanks & Regards

Ankush

[former_member188586 · Accepted solution]

hi

i sent, once check inbox ,if you installed 2012 means like same 2014 also , follow my attached file settings ,

[Former Member · Accepted solution]

Hi Andakondaramudu,

Hope you could also sent me the file which you mentioned above in you message.

Many thanks in Advance.

Pls. mail me on rahul.vaish1977@gmail.com

[frank_wang6]

It is not a good idea to install SQL over domain controller and specially for SAP database.

Frank

[Former Member]

Hi Frank Wang

yes it is not recommended but in INDIA generally some mid-size company clients doesn't afford separate server for domain controller so they want to manage all component on single server.

If there is any different configuration or setting to manage all on single server please refer any ideas.

Thanks

Ankush