This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / PROBLEM：ASP.NET 和SQL SERVER
-henhen(哼哼~~,找工ing~~~~);
2002-7-19
{564}
(#646854@0)
-
try trust connection. Windows user can login to SQL Server automatically if it set to trust connection
-ludouya(绿豆牙);
2002-7-20
(#646885@0)
-
谢谢，总算可以中文了。it said lack of true connection.But I don't know how to set up,could you give me more details?Thanks.
-henhen(哼哼~~,找工ing~~~~);
2002-7-20
{102}
(#647261@0)
-
then whats the error msg?
-bigdesk(nothing);
2002-7-20
(#647239@0)
-
excuse me,I can't remember although I saw it many many times.it seems:login failed .....user "localhost\xxxx", not associate with any trust connection.
when it forward next to do enquiry.
-henhen(哼哼~~,找工ing~~~~);
2002-7-20
{123}
(#647257@0)
-
没有必要使用这种连接方法。因为ASP是在用户登录之前就已经在运行了。asp.NET使用一个叫"ASPNET"的用户名，可以使用信任连接，ASP.NET访问数据库就会使用这个LOGIN, 应在数据库内配置这个用户的权限
-miketany(MIKE老狼);
2002-7-20
(#647275@0)
-
谢谢，我以为还这个用户不用设置呢。:-)
-henhen(哼哼~~,找工ing~~~~);
2002-7-20
(#647304@0)
-
OK了，加了ASPNET用户，昨天用了Integrated Security 的，就是没在SQL SERVER中设。跟大家报告一下结果，以后有问题再问。 :-)
-henhen(哼哼~~,找工ing~~~~);
2002-7-20
(#647315@0)
-
这儿概念有点混淆.
1.you can't use the XP login ID to specify the conectionstring with sql server if you want to use non-trusted connection since the user info in the conectionstring is from sql authentication.2. To use the trusted connection, u have to add that user to the sql server security via windows authentication under the specific domain and set "tursted_connection=YES" in your connectionstring.
-yangn(Raymond);
2002-7-20
{198}
(#647291@0)
-
Thanks very much,我就是没找到你说的那句，再次感谢大家~~~ ^o*
-henhen(哼哼~~,找工ing~~~~);
2002-7-20
(#647307@0)