encrypting data of config table

Hot Topic

Processing cube from SSAS - OLE DB error
Deleting a database
Identity field settings not copied by Import Wizard (2005)
Is it possible to remove fact data from a partition without doing a ProcessFull?
replication system stored procedures parameter defaults ?
username password
new to notifications services and want example of setting up email notifications
Setting up DotNetNuke am getting 18456 login failure
SQL Server Management Studio - 2005
Infinite Click-Through with SSRS 2005 Graphs?

SQL Server

Synchronizing Data Within SQLCE and SQL Server 2000
Simulate ROW_NUMBER () in SQL 2000
SubTotal
Restoring Analysis Services Database backup from SQL 2005 CTP June to SQL 2005 RTM
Frror: 4000 max string literal in Expression for datareader component
ETL using SSIS
Suppress email subscription for blank reports?
Linked Dimensions
SQL 2005 Standard CTP September asking for Disk 2
SQL 2005 64bit

encrypting data of config table

hi. i need some help please. i had a problem with using configuration files in april ctp so i moved to sql server configuration which i found as a better solution for storing connection info since it can encrypt the password. this as far as i know as i'm moving from beta 1 version.

when creating the database at the client's server, the configuration table needs to be created as well and the data manually inserted using insert statements.

in this case, how do i enter the data in a way that is encrypted

that's my question
thanks

Answer this question

encrypting data of config table

  • Stevenriz

    I'm not sure I understand your question, but I think the answer is you can't do this. We don't support encrypting SQL Server configurations.

  • Shan0315

    I believe the question is just about writing data to an encrypted column. In that case, you should be able to just write values as you were writing them before, SQL Server would take care of encrypting the contents.

  • encrypting data of config table
Answer this question