IIS中的SQL Server身份验证 [英] SQL Server Authentication from IIS
问题描述
你好，
我已经阅读了关于这个问题的一堆主题但似乎没有一个
解决了我的问题。我在我的SQL服务器
数据库中设置了一个用户帐户。例如用户：TheUser密码：密码并将其指定为
datareader，能够在一个表上发出SELECT语句。
在单独的IIS服务器上，我是运行一个与此数据库建立连接的页面。我已经尝试了一堆连接字符串，虽然我可以使用.net 2003 Interdev中的SQLDataConnection向导连接，
Windows ODBC等。当我实际浏览到测试时使用
相同连接字符串的页面我得到的消息是：
SQL Server不存在或访问被拒绝。
我不想冒充和现有帐户。我在IIS中启用了
匿名访问。我不想要Windows集成安全性。
我在.net studio中工作的连接字符串的示例
（开发）但现在通过访问ASP页面时实现
localhost是：
" workstation id = myworkstation; packet size = 4096; user id = TheUser; data
source = myserver; persist security info = True; initial
catalog = MyDB; password = password"
我做错了什么？
谢谢，
Ryan
< ry ***** *******@kp.org>在消息中写道
news：11 ********************* @ g14g2000cwa.googlegro ups.com ...
< blockquote class =post_quotes>（开发）但是现在当通过
访问ASP页面时实际操作我做错了什么？
首先，你在错误的新闻组发帖...
对于与数据库连接特别相关的ASP问题，你需要：
microsoft.public.inetserver。 asp.db
你需要打开sqlserver盒子上的混合安全性，你可以实际使用标准登录来实现
。
- 布鲁斯（sqlwork.com）
< ry ************ @ kp.org>在消息中写道
news：11 ********************* @ g14g2000cwa.googlegro ups.com ...你好，
我已经阅读了很多关于这个问题的主题，但似乎没有人解决我的问题。我在我的SQL服务器数据库中设置了一个用户帐户。例如用户：TheUser密码：密码并将其指定为
datareader，能够在一个表上发出SELECT语句。
在单独的IIS服务器上，我运行的页面连接到这个数据库。我已经尝试了一堆连接字符串，虽然我可以使用.net 2003 Interdev中的SQLDataConnection向导，
Windows ODBC等进行连接。当我实际浏览以使用
测试页面时相同的连接字符串我收到的消息是：
SQL Server不存在或访问被拒绝。
我不想冒充和现有帐户。我在IIS中启用了匿名访问。我不想要Windows集成安全性。
我在.net studio
（开发）中工作的连接字符串示例，但现在通过
localhost访问ASP页面时实现的是：
" workstation id = myworkstation; packet size = 4096; user id = TheUser; data
source = myserver; persist security info = True; initial
catalog = MyDB; password =密码
我做错了什么？
谢谢，瑞安
打开混合安全性。我将在新闻中重新发布这个消息
组马克建议。如果您能想到其他原因，那么
，请您回复我！谢谢布鲁斯！
Hello,
I have read a bunch of topics on this issue but none seems to have
resolved my problem. I have set up a user account in my SQL server
database. e.g. User: TheUser Password: Password and assigned it as a
datareader with the ability to issue SELECT statements on one table.
On a separate IIS server I am running a page that makes a connection to
this database. I have tried a bunch of connection strings and though I
can connect using the SQLDataConnection wizard in .net 2003 Interdev,
Windows ODBC, etc. When I actually browse to test the page using the
same connection string I get the message that:
SQL Server does not exist or access denied.
I do not want to Impersonate and existing account. I have enabled
Anonymous access in IIS. I do not want Windows Integrated Security.
An example of a connection string I that works within .net studio
(development) but now actuall when the ASP page is accessed via
localhost is:
"workstation id=myworkstation;packet size=4096;user id=TheUser;data
source=myserver;persist security info=True;initial
catalog=MyDB;password=password"
What am I doing wrong?
Thanks,
Ryan
<ry************@kp.org> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
(development) but now actuall when the ASP page is accessed via What am I doing wrong?
For a start, you''re posting in the wrong newsgroup...
For ASP issues specifically related to database connectivity, you need:
microsoft.public.inetserver.asp.db
you need to turn on mixed security on the sqlserver box, you you can
actually use a standard login.
-- bruce (sqlwork.com)
<ry************@kp.org> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...Hello,
I have read a bunch of topics on this issue but none seems to have
resolved my problem. I have set up a user account in my SQL server
database. e.g. User: TheUser Password: Password and assigned it as a
datareader with the ability to issue SELECT statements on one table.
On a separate IIS server I am running a page that makes a connection to
this database. I have tried a bunch of connection strings and though I
can connect using the SQLDataConnection wizard in .net 2003 Interdev,
Windows ODBC, etc. When I actually browse to test the page using the
same connection string I get the message that:
SQL Server does not exist or access denied.
I do not want to Impersonate and existing account. I have enabled
Anonymous access in IIS. I do not want Windows Integrated Security.
An example of a connection string I that works within .net studio
(development) but now actuall when the ASP page is accessed via
localhost is:
"workstation id=myworkstation;packet size=4096;user id=TheUser;data
source=myserver;persist security info=True;initial
catalog=MyDB;password=password"
What am I doing wrong?
Thanks,
Ryan
Mixed security is turned on. I am going to repost this in the news
group Mark suggested. If you can think of some other causes for this
can you please respond to me there! Thanks Bruce!
这篇关于IIS中的SQL Server身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
