Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-11-12 : 10:48:59
|
| I have a query which uses openrowset using a system DSN to extract data from an Ingres database:SELECT a.* FROM OPENROWSET('MSDASQL','dsnName';'User';'Password', 'select * FROM TableName ') AS aIs it possible to encrypt the username / password.I found a reference to using a tilde (~) character after the forward slash but haven't got this working for openrowset.http://www.sqlusa.com/bestpractices/dtsrunpasswordencryption/Any advice? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-12 : 10:57:23
|
DTSRUN is an external command running a DTS package asynchronously.DTSRUN can decrypt the command easily.And we have all our opinions about the user and his abilities in your link.A better approach would be using "Trusted_Connection=Yes" in your connection string.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-12 : 11:32:32
|
| The database is on a unix box with an ingres database. How do I use Trusted Connection for the openrowset in this situation? |
|
|
|
|
|
|
encrypt the username / password