Storing And Using Microsoft User Account Credentials in SQL Server 2008 database

Posted by user337501 on Stack Overflow See other posts from Stack Overflow or by user337501
Published on 2010-04-26T17:10:32Z Indexed on 2010/05/21 8:10 UTC
Read the original article Hit count: 240

Filed under:

password-protection

|

user-accounts

|

sql

|

sql-server

I'm not exactly positive how to word this for the sake of the title so please forgive me. Also I can't seem to figure out how to even google this question, so I'm hoping that I can get a lead in the right direction.

Part of my software(VB.NET App) requires the ability to access/read/write a shared network folder. I have an option for the user to specify any credentials that might be needed to access said folder.

I want to store these credentials given in the SQL Server database as part of the config (I have a table which contains configuration).

My concern is that the password for the user account will be unencrpyted. Yet, if I encrypt the password the VB.NET App And/Or database will be unable to use the credentials for file i/o operations unless the Password is unencrypted before use.

I'm fishing for suggestions on how to better handle this situation.

© Stack Overflow or respective owner

Related posts about password-protection

How good is PDF password protection?

as seen on Super User - Search for 'Super User'
It appears that Word's password protection is not really good, at least until Office 2003, if I read this SU entry correctly. I'm under the impression that Acrobat's PDF password protection should be better (it says 128-bit AES for Acrobat 7 and higher). Is that true? Of course, it depends on the… >>> More
How to remove password protection from compressed files

as seen on Super User - Search for 'Super User'
This has always been a problem for me for a long time. Let's see if any SuperUser can solve this: I have a directory in which there are lots of password protected .RAR files of which I know the passwords. I want to remove the password protection from all of them without extracting the contents… >>> More
How good is Word's password protection?

as seen on Super User - Search for 'Super User'
Hi, I have a password protected MS-Word 2007 file that needs to stay private. How good is Word's protection? If it's not very good, can you suggest a better method for keeping the file protected? EDIT: my goal is to send the protected file to a recipient (who knows the password). I assume this recipient… >>> More
Password protection by .htaccess file not working after deployment on a new server

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I migrated my application to a new server (from a VPS to a dedicated) yesterday and the password protection which was working correctly on the previous server (using .htaccess file - asking username/pass) doesn't work anymore : anyone can access the website without being asked to enter a username… >>> More
PHP password protection question?

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I use the sha512 function for PHP? Can I replace all my md5 funtions with the sha512 function? Do I have to download something if so what? Can any one provide examples? Thanks! >>> More

Related posts about user-accounts

Prevent Windows 7 User Accounts from accessing files in other User Accounts

as seen on Super User - Search for 'Super User'
I'm trying to set up another User Account on my Windows 7 Professional laptop for use by another person. I do not want that person to have access to any of the files in my User Account on the same machine. This machine has a single hard disk formatted with NTFS. User accounts data is stored in the… >>> More
JPA entities -- org.hibernate.TypeMismatchException

as seen on Stack Overflow - Search for 'Stack Overflow'
Environment: JDK 1.6, JEE5 Hibernate Core 3.3.1.GA, Hibernate Annotations 3.4.0.GA DB:Informix Used reverse engineering to create my persistence entities from db schema [NB:This is a schema in work i cannot change] Getting exception when selecting list of basic_auth_accounts org.hibernate.TypeMismatchException:… >>> More
List of Hidden / Virtual Windows User Accounts

as seen on Super User - Search for 'Super User'
I’m trying to find a way to get a comprehensive list of user accounts on a Windows 7 system, including hidden ones. The User Accounts dialog (>control userpasswords2) only shows the normal user accounts, and even the Local User and Groups editor only shows normal user accounts and standard hidden/disabled… >>> More
Creating Limited User Accounts on Ubuntu Server

as seen on Server Fault - Search for 'Server Fault'
Using Ubuntu server, I need to create some user accounts that have the following limitations: (1) User may only view and manipulate files in their home directory. (2) User may only execute commands related to rsync and sftp. I want users to be able to backup files using rsync, and I want them to… >>> More
Active Directory using Samba/Open LDAP for user accounts

as seen on Server Fault - Search for 'Server Fault'
I know this is the wrong way round... but Is it possible to use AD in front of Samba for our PC clients, so that the user accounts are in Samba/Open LDAP. Managing our fleet of Windows PC's is becoming more and more difficult with just Samba v3 - until Samba v4 comes along, it would be great if… >>> More