Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1101
  • Last Modified:

sqlcmd encrypted password

Hello,

We are now connecting to  DB with clear text password and we would like to use encrypted password. How we can do it?
0
mokkan
Asked:
mokkan
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
the best way is to use a trusted connection, you need to use windows authentication for this. or you can use set the username and password and env variables as mentioned on the post below, but it is still not the best option.

http://zainuvk.blogspot.ca/2011/09/hise-username-and-password-with-sqlcmd.html
0
 
ste5anSenior DeveloperCommented:
There's no such thing.

What do you want really? Encrypt the the connection to SQL Server? Then you need to setup your server correctly. See Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)

Another option would be using Integrated Authentication.
0
 
mokkanAuthor Commented:
Thank  you
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now