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 |
|
smousumi
Starting Member
19 Posts |
 Posted - 2004-03-03 : 01:55:13
|
| Hii,I have a Querry regarding DSN?While creating DSN for SQL Server database, we are providingLogin ID and Password to connect to particular db.Then Why is it necessary to pass userid and pwd in the connectString of connection object?mousumi |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-03 : 07:40:55
|
| Passwords are never stored in a DSN. When the DSN setup prompts you, it is only so that it can connect to the database server to get the additional information like database name, collations, etc. The user id is only stored so that it will prompt with the same name when connecting...you can override it with a different user name. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-03 : 08:56:09
|
| If you are on a Domain though, you can set up Windows security which is much more secure. You then pass nothing for the username and password. It will default to trusted connection security. Have you explored this option?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
smousumi
Starting Member
19 Posts |
Posted - 2004-03-04 : 05:06:59
|
| Thanks..what is trusted connection security?I dn't have info abt that.How should we achive this setting?mousumi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-04 : 12:37:58
|
| Trusted connection means to use Windows authentication rather than SQL authentication. This is the preferred method as it is more secure.Tara |
|
|
|
smousumi
Starting Member
19 Posts |
Posted - 2004-03-05 : 02:05:17
|
| ok, Thanks to all...I will try using Windows Authentication, where no need to supply uid and pwd in my application.thanksmousumi |
|
|
|
|
|
|
Using DSN