<div>
check the eventviewver for any errors ? also are you able to rightclick and start the service ?<br />

</div>


check the eventviewver for any errors ? also are you able to rightclick and start the service ?


<div>
Yes I'am able to rightclick and start and stop the service.<br />
<br />
There is no errors when running &nbsp;exec master..xp_cmdshell 'NET START SERVICE_NAME' <br />
<br />
This is the output:<br />
<br />
- System error 5 has occurred.<br />
- NULL<br />
- Access denied.<br />
- NULL<br />
- NULL<br />
<br />
&nbsp;
</div>


Yes I'am able to rightclick and start and stop the service.

There is no errors when running  exec master..xp_cmdshell 'NET START SERVICE_NAME'

This is the output:

- System error 5 has occurred.
- NULL
- Access denied.
- NULL
- NULL

 

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
How can I start a &nbsp;windows service with SQL SERVER. ? I used this command;<br />
<br />
exec master..xp_cmdshell 'NET START SERVICE_NAME' but the service still inactive.<br />
<br />
How shall I do please ?<br />
<br />

</div>
</div>


Hi

How can I start a  windows service with SQL SERVER. ? I used this command;

exec master..xp_cmdshell 'NET START SERVICE_NAME' but the service still inactive.

How shall I do please ?



How can I start windows service with SQL SERVER ?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.