验证问题仍然存在 [英] Authentication problem continued
本文介绍了验证问题仍然存在的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好，
我仍然无法让我的应用程序正确验证。
我已阅读以下提示：
http://www.devhood.com/messages/mess ... hread_id = 72204
我仍然无法正确发生这种情况。这是我的
设置。
需要SQL Server 2005数据库访问
网页
匿名访问被转换在IIS中关闭。
< identity impersonate =" true" />
< impersonate =" true" />
连接字符串是：
包大小= 4096; Trusted_Connection = True;数据源= NTserver;持久
安全信息=错误;初始目录= MyTest"
我将用户名和密码传递给：
用户ID =我;密码= mypassword
当我拿出用户ID和密码的东西并放入：
综合安全= SSPI
我登录了，但只在我的开发机器而不是另一个盒子上。
当用户名和密码在连接字符串中传递时，我得到了
登录失败，用户ID = me
我是这个sql server数据库的dbo，所以我应该能够登录。
但是，我需要能够从我的开发盒以外的机器访问这个网页。
任何人都可以帮我这个吗？谢谢
S
Hello,
I''m still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204
and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />
Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"
I pass in my user name and password as:
User Id=me;Password=mypassword
When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI
I get logged in, but only on my developement machine and not another box.
When the user name and password is passed in the connection string I get the
login failed for User Id=me
I''m the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other than
my development box also.
Can anyone help me with this? Thanks
S
推荐答案
根据你的意见，我可以想到2个问题
1）SQL Server仅配置为Windows身份验证而不是混合
身份验证
2）使用的帐户设置应用程序池的安全上下文
您的网站无法访问另一个框'SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
SAL < SA ** @NoNo.com写信息
news：ur **************** @ TK2MSFTNGP04.phx.gbl ...
Going by your input there could be 2 problems that I can think off
1) SQL Server is configured for Windows Authentication only and not mixed
authentication
2) The account used to set the security context for the application pool of
your web site has no access to the other box'' SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
您好，
我仍然无法让我的应用程序正确验证。
我已阅读提示at：
http：// www。 devhood.com/messages/mess...hread_id=72204
我仍然无法正确发生这种情况。这是我的
设置。
需要SQL Server 2005数据库访问
网页
匿名访问被转换在IIS中关闭。
< identity impersonate =" true" />
< impersonate =" true" />
连接字符串是：
包大小= 4096; Trusted_Connection = True;数据源= NTserver;持久
安全信息=错误;初始目录= MyTest"
我将用户名和密码传递给：
用户ID =我;密码= mypassword
当我拿出用户ID和密码的东西并放入：
综合安全= SSPI
我登录了，但只在我的开发机器而不是另一个盒子上。
当用户名和密码在连接字符串中传递时我得到了
登录失败，用户ID =我
我是这个sql server数据库的dbo，所以我应该能够登录。
但是，我需要能够从其他机器上访问这个网页，而不是我的开发盒。
有谁可以帮我这个？谢谢
S
Hello,
I''m still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204
and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />
Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"
I pass in my user name and password as:
User Id=me;Password=mypassword
When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI
I get logged in, but only on my developement machine and not another box.
When the user name and password is passed in the connection string I get
the login failed for User Id=me
I''m the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.
Can anyone help me with this? Thanks
S
Gabriel，
谢谢你你的回复。
我现在已经建立了SQL Server登录，我可以登录我的开发
机器，但是我收到匿名登录失败在我的测试盒上。
我的machinename\ASPNET是数据库的用户，是
服务器的用户，它看起来像我。
可能还有哪些其他帐户用于设置
应用程序池的安全上下文？我不确定这一部分。
S
" Gabriel Lozano-Morán" < ab *** @ frontbridge.com写的消息
news：u7 ************** @ TK2MSFTNGP03.phx.gbl ...
Gabriel,
thank you for your reply.
I have a SQL Server login established now and I can log in on my development
machine but I''m getting the Anonymous login failure on my test box.
my machinename\ASPNET is a user of the database and is a user for the
server, it looks like to me.
What other account might be being used to set the security context for the
application pool? I''m not sure about this part.
S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
根据您的输入，我可以想到2个问题
1）SQL Server仅配置为Windows身份验证而不是混合
身份验证
2）用于设置应用程序池安全上下文的帐户
您的网站没有访问另一个框''SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
" SAL" < SA ** @NoNo.com写信息
news：ur **************** @ TK2MSFTNGP04.phx.gbl ...
Going by your input there could be 2 problems that I can think off
1) SQL Server is configured for Windows Authentication only and not mixed
authentication
2) The account used to set the security context for the application pool
of your web site has no access to the other box'' SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>您好，
我仍然无法让我的应用程序正确进行身份验证。
我已阅读以下提示：
http://www.devhood.com/messages/混乱... hread_id = 72204
我仍然无法正确地实现这一点。以下是我的
设置。
需要SQL Server 2005数据库访问
网页
在IIS中关闭匿名访问。
< identity impersonate =" true" ; />
< impersonate =" true" />
连接字符串是：
数据包大小= 4096; Trusted_Connection = True;数据源= NTserver;持久
安全信息= False;初始目录= MyTest"
我传递了我的用户名和密码：
用户ID =我;密码= mypassword
当我拿出用户名和密码时并且输入：
集成安全性= SSPI
我登录了，但只能在我的开发机器而不是另一个盒子上。
当用户名和密码在我得到的连接字符串中传递
登录失败的用户ID =我
我是这个sql server数据库的dbo所以我应该能够登录。但是，我需要能够从其他机器上访问这个网页，而不是我的开发盒。
任何人都可以帮我这个吗？谢谢
>Hello,
I''m still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204
and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />
Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"
I pass in my user name and password as:
User Id=me;Password=mypassword
When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI
I get logged in, but only on my developement machine and not another box.
When the user name and password is passed in the connection string I get
the login failed for User Id=me
I''m the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.
Can anyone help me with this? Thanks
S
这里的另一条信息是，如果我在我的开发上运行应用程序
框，然后转到我的测试框并访问网页：
我的机器名/ ClarkCategory / Startfrm1.aspx它将打开并且工作
正确。但是，一旦一定时间过期，登录
将再次在我的测试盒上失败。
S
Gabriel Lozano-Morán < ab *** @ frontbridge.com写的消息
news：u7 ************** @ TK2MSFTNGP03.phx.gbl ...
Another piece of information here is that if I run the app on my development
box, then go to my test box and access the web page as:
my machinename/ClarkCategory/Startfrm1.aspx it will open up and work
correctly. However, once a certain amount of time has expired, the login
will fail on my test box again.
S
"Gabriel Lozano-Morán" <ab***@frontbridge.comwrote in message
news:u7**************@TK2MSFTNGP03.phx.gbl...
根据您的输入，我可以想到2个问题
1）SQL Server仅配置为Windows身份验证而不是混合
身份验证
2）用于设置应用程序池安全上下文的帐户
您的网站没有访问另一个框''SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
" SAL" < SA ** @NoNo.com写信息
news：ur **************** @ TK2MSFTNGP04.phx.gbl ...
Going by your input there could be 2 problems that I can think off
1) SQL Server is configured for Windows Authentication only and not mixed
authentication
2) The account used to set the security context for the application pool
of your web site has no access to the other box'' SQL Server
Gabriel Lozano-Morán
http://www.pointerx.net
"SAL" <SA**@NoNo.comwrote in message
news:ur****************@TK2MSFTNGP04.phx.gbl...
>您好，
我仍然无法让我的应用程序正确进行身份验证。
我已阅读以下提示：
http://www.devhood.com/messages/混乱... hread_id = 72204
我仍然无法正确地实现这一点。以下是我的
设置。
需要SQL Server 2005数据库访问
网页
在IIS中关闭匿名访问。
< identity impersonate =" true" ; />
< impersonate =" true" />
连接字符串是：
数据包大小= 4096; Trusted_Connection = True;数据源= NTserver;持久
安全信息= False;初始目录= MyTest"
我传递了我的用户名和密码：
用户ID =我;密码= mypassword
当我拿出用户名和密码时并且输入：
集成安全性= SSPI
我登录了，但只能在我的开发机器而不是另一个盒子上。
当用户名和密码在我得到的连接字符串中传递
登录失败的用户ID =我
我是这个sql server数据库的dbo所以我应该能够登录。但是，我需要能够从其他机器上访问这个网页，而不是我的开发盒。
任何人都可以帮我这个吗？谢谢
>Hello,
I''m still having trouble getting my app to authenticate correctly.
I have read the tips at:
http://www.devhood.com/messages/mess...hread_id=72204
and am still having trouble making this happen correctly. Here are my
settings.
SQL Server 2005 db access is required
Web page
Anonymous access is turned off in IIS.
<identity impersonate="true" />
<impersonate="true" />
Connection string is:
packet size=4096;Trusted_Connection=True;data source=NTserver;persist
security info=False;initial catalog=MyTest"
I pass in my user name and password as:
User Id=me;Password=mypassword
When I take out the User Id and Password stuff and put in:
Integrated Security=SSPI
I get logged in, but only on my developement machine and not another box.
When the user name and password is passed in the connection string I get
the login failed for User Id=me
I''m the dbo of this sql server database so I should be able to log in.
However, I need to be able to access this web page from machines other
than my development box also.
Can anyone help me with this? Thanks
S
这篇关于验证问题仍然存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
