DSN用户名和密码-强制要求? [英] DSN User Name and Password - Mandetory?

问题描述

大家好，

我已经使用DSN在点网中创建了一个应用程序来访问sql.我想知道为什么有必要在已经在DSN中指定的应用程序中再次指定用户名和密码.

有没有一种选择，其中我们只能在应用程序中使用DSN名称，而用户名和密码除外.如果有任何建议，请.


在此先感谢，


问候，
Rahul Jain

Hi All,

I have created an application in dot net using DSN to access the sql. I want to know why is it necessary to again specify user name and password in the application which is already specified in the DSN.

Is there an alternative in which we can only use DSN name in the application excluding the user name and password. If any please suggest.


Thanks in Advance,


Regards,
Rahul Jain

推荐答案

再次真正不需要用户名和密码来建立数据库连接.

但是，如果您再次要求提供用户名和密码(以提高安全性)，那么在登录等过程中值得输入密码.

The user name and password is not really required again to setup a database connection.

However, if you are asking for the username and password again (for additional security), then it is worthwhile asking for the password during, say logon, etc.

不太清楚您要输入的用户名和密码是什么.在问.当您连接到数据库时，您需要进行身份验证.

在Sql Server中，您有两个选择(假设这是您使用的):
-Sql Server身份验证，必须指定有效的Sql Server用户名和密码
-Windows身份验证，将使用您当前的Windows凭据.

有关更多信息:
- http://msdn.microsoft.com/en-us/library/ms144284.aspx [ ^ ]
- http://www.connectionstrings.com/sql-server-2008 [

Not quite sure what you''re asking. When you connect to a database you need to authenticate.

In Sql Server you have two options (assuming this is what you use):
- Sql Server authentication, with this you have to specify a valid Sql Server username and password
- Windows authentication, with this your current windows credentials will be used.

For more info:
- http://msdn.microsoft.com/en-us/library/ms144284.aspx[^]
- http://www.connectionstrings.com/sql-server-2008[^]

这篇关于DSN用户名和密码-强制要求?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！