• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

How to encrypt a SQL Server password ?

Hello Expert,

I've got an application, it use a SQL server password to work.
The login/password is in the configuration file.
Is it possible to encrypt the password ?

thanks !
0
Carlito985
Asked:
Carlito985
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
hax1Commented:
What type of Application is it? (In what language is it written)

If it's compiled you could put it into the application directly, or encrypt the configuration file and put the decryption key into the application itself.
0
 
Carlito985Author Commented:
the application is written in .NET, it use a xml configuration file with differents parameters (connection string, login, password ...)

0
 
grayeCommented:
If this is an ordinary "windows form" application, then take a look at this article:

http://www.emmet-gray.com/Articles/EncryptConnectionStrings.htm
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
hax1Commented:
simply encrypt the connection string and decrypt it in the program itself and you're done?
0
 
Carlito985Author Commented:
ok it can be possible.
Let me have a look,

Thanks !
0
 
grayeCommented:
Simple encryption works well when you're using the "low level" ADO.Net components...  however, if you're using any of the wizard-based features (such as TableAdapters or Entity Framework), then you'll have trouble.   This issues is discussed in the article...
0
 
TolomirAdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now