How can i give permission my local service to access database

To give your local service permission to access your SQL Server database, you can follow these steps:

Identify the SID of your local service account. You can do this by running the following command in a command prompt:

wmic service where name='LocalService' get sid

This will return the SID of your local service account.

Grant the local service account the necessary permissions on your SQL Server database. You can do this by using the SQL Server Management Studio (SSMS) or by running the following SQL statement:

GRANT CONNECT, SELECT, INSERT, UPDATE, DELETE ON database_name TO NT SERVICE\LocalService;

Be sure to replace database_name with the name of your SQL Server database.

Restart your SQL Server service. This will ensure that the changes you made take effect.
Restart your local service.

Once you have completed these steps, your local service should be able to access your SQL Server database.

Here is an example of how to grant the local service account the necessary permissions on a SQL Server database using SSMS:

Open SSMS and connect to your SQL Server instance.
Expand the Security node in the Object Explorer tree.
Expand the Logins node.
Right-click the NT SERVICE\LocalService login and select Properties.
On the Database Access page, select the database that you want to grant permissions to.
In the Permissions section, check the boxes for the permissions that you want to grant.
Click OK to save your changes.

Once you have granted the local service account the necessary permissions, you should be able to start your local service and it should be able to access your SQL Server database.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sarthak Varshney2y ago
To give your local service permission to access your SQL Server database, you can follow these steps:
1. Identify the SID of your local service account. You can do this by running the following command in a command prompt:
```
wmic service where name='LocalService' get sid
```
This will return the SID of your local service account.
1. Grant the local service account the necessary permissions on your SQL Server database. You can do this by using the SQL Server Management Studio (SSMS) or by running the following SQL statement:
```
GRANT CONNECT, SELECT, INSERT, UPDATE, DELETE ON database_name TO NT SERVICE\LocalService;
```
Be sure to replace database_name with the name of your SQL Server database.
1. Restart your SQL Server service. This will ensure that the changes you made take effect.
2. Restart your local service.
Once you have completed these steps, your local service should be able to access your SQL Server database.

Here is an example of how to grant the local service account the necessary permissions on a SQL Server database using SSMS:
1. Open SSMS and connect to your SQL Server instance.
2. Expand the Security node in the Object Explorer tree.
3. Expand the Logins node.
4. Right-click the NT SERVICE\LocalService login and select Properties.
5. On the Database Access page, select the database that you want to grant permissions to.
6. In the Permissions section, check the boxes for the permissions that you want to grant.
7. Click OK to save your changes.
Once you have granted the local service account the necessary permissions, you should be able to start your local service and it should be able to access your SQL Server database.
+1
Aymen Amri2y ago
Hello Ishika

Maybe you could check following points :
- The connection string to the database
- The access of the db user configured in the service to access the database.
- It could be also the communication between the services and the db (ports, firwall ...)
I would recommend that you trace the execution of the service into a log file in order to have more details about the issue.

You can also run the installed service then debug your code from VS using the Debug ==> Attach to process
+1