What is the best way to save username and password for windows service?

Question

What is the best way to save username and password for windows service?

The service must have access to the MS SQL Server database on the remote computer. We must support MS SQL Server authentication (mixed mode) instead of NT Authentication.

Answer 1

The DP API is the standard way to store sensitive data locally on Windows. You did not specify the programming language that you are using, but in .NET it is shown in the System.Security.ProtectedData class .

Answer 2

Assuming .Net, you can encrypt your configuration file. See this .

Answer 3

, , , , , . CryptProtectData. . , LsaStorePrivateData .

Answer 4

Windows, , , SQL Server, , ..

: , - , .

Answer 5

.

?

, , .

, , , NT Authentication . , , , , .

Answer 6

:)

, , , , : System.Security.Cryptography.ProtectedData

: Windows

Answer 7

- . - , . , .

, - (wikipedia for rainbow table). , , . - , .

, :

• , .
• .
• .
• Compare the calculated hash with the database. If they match, give access!