URGENTT：用户登录失败'（null）' [英] URGENTT: Login failed for user '(null)'
问题描述
我使用.NET 2.xx开发内部网站点，Server1（域控制器）上的IIS（我的应用程序）和Server2上的SQl服务器2000。 br />
和两台服务器都通过Windows 2003运行。
我做了以下步骤，
1-创建域帐户在域控制器上（Server1 \ASPNET）
2-在SQL上新登录，并在我想访问的数据库上创建新用户，然后我授予该用户访问我的存储过程的权限用户名：Server1 \ASPNET
登录名：Server1 \ASPNET
3-启用临时网络服务ASP.NET文件
实际上我做了很多其他的事情，我不记得只是为了使应用程序工作
我还有那个顽固的错误：
用户''（null）''登录失败。原因：与可信的SQL Server连接无关:(。
我想知道我是否应该使用NETWORKSERVICE替换ASPNET导致它成为Windows 2003 !!!
请回答我我花了4天试图发布这个网站没有用!!
实际上可能是你的连接字符串。文章可能有所帮助：
SQL SERVER - 修复：错误：18452
< blockquote class =post_quotes>
我使用.NET 2.xx开发内部网站点，Server1上的IIS（我的应用程序）（域控制器） Server2上的SQl服务器2000.
和两台服务器通过Windows 2003运行。
我做了以下步骤，
1-在域上创建域帐户控制器（Server1 \ASPNET）
2-在SQL上新登录，并在我想访问的数据库上创建新用户，然后我授予该用户访问我的存储过程和视图的权限。
用户名：Server1 \ASPNET
登录名：Server1 \ASPNET
3-启用临时ASP.NET中的网络服务文件
实际上我做了很多其他事情，我不记得只是为了让应用程序工作
我还有那个顽固的错误：
用户''（null）''登录失败。原因：与可信的SQL Server连接无关:(。
我想知道我是否应该使用NETWORKSERVICE替换ASPNET导致它成为Windows 2003 !!!
请回答我我花了4天试图发布这个网站没有用!!
你好kenobewan，
我不认为它是连接字符串，因为当我尝试使用visual studio时它运行良好，当我尝试远程连接到Server2上的Sql Server时它运行良好。
我在谷歌中没有使用过lotttttttt !!
我把我的头发拉了出来。：_（
嗨kenobewan，
我不认为它是连接字符串，因为它在我尝试时效果很好与visual studio合作，当我尝试远程连接到Server2上的Sql Server时，它运行良好。
我在goog中输入了一个lotttttttt le没有用!!
我把头发拉了出来。 ：_（
如果您正在运行使用网络服务的应用程序池，则可能会解析，否则不会。发布完整的错误消息，包括错误和行号（如果有）你在https下运行吗？你的连接字符串是什么？它在哪里？
Hi ,
I use .NET 2.xx for developing an intranet site, The IIS (my application) on Server1 (Domain controller) the SQl server 2000 on Server2.
and both servers running through windows 2003.
I did the following steps,
1- Create Domain account on the Domain controller (Server1\ASPNET)
2- Made new login on the SQL, and created new user on the database I want to access, then I gave that user permissions to access my stored procedure and views.
User Name: Server1\ASPNET
Login Name: Server1\ASPNET
3- enabled the Network Service in the Temporary ASP.NET Files
Actually I did many other things that i can''t remember just to make that application work
I still have that stubid error:
Login failed for user ''(null)''. Reason: Not associated with a trusted SQL Server connection :(.
I''m wondering Should I replace ASPNET with NETWORKSERVICE cause it windows 2003 !!!
Please answer me I''ve spend 4 days trying to publish this site with no use !!
May actually be your connection string. This article may help:
SQL SERVER - Fix : Error: 18452
Hi ,
I use .NET 2.xx for developing an intranet site, The IIS (my application) on Server1 (Domain controller) the SQl server 2000 on Server2.
and both servers running through windows 2003.
I did the following steps,
1- Create Domain account on the Domain controller (Server1\ASPNET)
2- Made new login on the SQL, and created new user on the database I want to access, then I gave that user permissions to access my stored procedure and views.
User Name: Server1\ASPNET
Login Name: Server1\ASPNET
3- enabled the Network Service in the Temporary ASP.NET Files
Actually I did many other things that i can''t remember just to make that application work
I still have that stubid error:
Login failed for user ''(null)''. Reason: Not associated with a trusted SQL Server connection :(.
I''m wondering Should I replace ASPNET with NETWORKSERVICE cause it windows 2003 !!!
Please answer me I''ve spend 4 days trying to publish this site with no use !!
Hi kenobewan,
I don''t think its the connection string, cause it worked well when I tried to work with the visual studio and it worked well when I tried to connect remotely to the Sql Server on Server2.
I serched a lotttttttt in google with no use!!
I''m pulling my hair out. :_(
Hi kenobewan,
I don''t think its the connection string, cause it worked well when I tried to work with the visual studio and it worked well when I tried to connect remotely to the Sql Server on Server2.
I serched a lotttttttt in google with no use!!
I''m pulling my hair out. :_(If you are running an application pool that uses network service this may resolve, otherwise not. Publish the full error message, include error and line number if available. Are you running under https? What is your connection string and where does it reside?
这篇关于URGENTT：用户登录失败'（null）'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
