1

I want to programmatically change built in account to local system of SQL Server 2008 R2. It will be executed in stored procedure.

I couldn't find any information.

Pang
  • 9,564
  • 146
  • 81
  • 122
Suleyman MA
  • 11
  • 3

2 Answers2

0

I will assume that you mean to say "change the SQL Server service startup account".

Manually follow the procedure described at Change the Service Startup Account for SQL Server. There is no supported programmatic way. You cannot do it in a stored procedure.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
0

yes i know this way but i have to do that. when i try execute this code

ALTER DATABASE db_stock SET READ_WRITE;

My project give me errors that are about

Operating system error 5: Access is denied.

So I have to change startup account programmatically.

Do you know how I can solve this problem with other ways?

MAXE
  • 4,978
  • 2
  • 45
  • 61
Suleyman MA
  • 11
  • 3