连接失败 [英] connection failure
问题描述
对不起这个交叉点（我昨晚在asp.db组上发布了这个）。但是因为我在那里没有回答，所以我希望能有更好的运气。我很漂亮
我尝试了很多东西。这就是问题：
我在工作中有一个基于Intranet的应用程序，我在那里有两个地方：一个
dev机器和一个生产箱。在这两种情况下，ASP文件和SQL
Server 2000数据库都在同一个盒子上。我在工作中的两个地方都能顺利运行。
然而，我一直试图在家中进行设置，并且不能使SQL
由于某种原因，服务器连接工作。几个星期以来，我一直在努力工作，而且我只是花了几个星期，而我只是没有得到我所缺少的东西。
首先，我的代码：
<！ - #INCLUDE FILE =" includes / dbinc.asp" - >
指向只包含以下行的页面：
=================== ====
<％
Dim strDBConnection
strDBConnection = _
" Provider = SQLOLEDB; " &安培; _
" Persist Security Info = False;" &安培; _
" Data Source = w2003\ticketlog;" &安培; _
" User ID = asp;" &安培; _
" Password = asp;" &安培; _
" Database = argonet;"
Dim objConnection
设置objConnection = Server.CreateObject（" ADODB.Connection"）
objConnection.Open strDBConnection
％>
==================== ==========
此时我应该补充一点，这段代码就像我的东西中的
工作代码一样工作。只有名称已被更改。我还要在家里添加这个，我正在处理的机器已经是名为W2003的
，所以当我设置SQL Server时，它命名为实例
W2003 \TICKETLOG。（Windows NT）。是的，它有括号中的那一部分。
我不认为斜线是问题。
无论如何，这是我看到的信息在浏览器中，当我尝试访问任何调用此连接代码的
页面时。
================= ===================
用于SQL Server的Microsoft OLE DB提供程序错误''80040e4d''
登录失败对于用户''asp''。
/ticketlog/includes/argodbinc.asp，第15行
=============== =====================
我想补充说我确实去了EP的服务器，去了安全然后
双击用户名为asp，然后转到数据库选项卡以确保确认了db_owner和其他所有内容的
。然后我为
INETUSER做了同样的事。
好的，所以假装我之前从未做过任何这样的事情。我需要采取哪些步骤来设置这个东西？b $ b在我的情况下，我确实添加了一个名为asp的用户并给出了完整的
权限，但我认为我没有这样做。也许有详细的
手持指令，我会看到我缺少的东西。
http://aspfaq.com/show.asp?id = 2138
http://aspfaq.com/ show.asp？id = 2126
这是你的其中一个吗？
http://www.issociate.de/board/post/1..._problems.html
-
问候
Steven Burn
Ur IT Mate Group
www.it-mate.co.uk
保持免费！
" middletree" < MI ******** @ HTOmail.com>在消息新闻中写道：uR ************* @ TK2MSFTNGP15.phx.gbl ...对于交叉点我很抱歉（我在asp.db组上发布了这个帖子）昨晚）。但是因为我在那里没有答案，所以我希望能有更好的运气。我很漂亮
我尝试了很多东西。这就是问题：
我有一个基于Intranet的应用程序在工作中，我在那里有两个地方：一个
开发机器和一个生产盒。在这两种情况下，ASP文件和SQL
Server 2000数据库都在同一个盒子上。我在工作的两个地方都能顺利运行。
然而，我一直试图在家中进行设置，并且无法使SQL服务器连接正常工作由于某些原因。我已经在这个问题上工作了好几个星期，我只是没有得到我所缺少的东西。
首先，我的代码：
< ！ - #INCLUDE FILE =" includes / dbinc.asp" - >
指向仅包含以下行的页面：
=================== ====
<％
Dim strDBConnection
strDBConnection = _
" Provider = SQLOLEDB;" &安培; _
坚持安全信息=假; &安培; _
数据来源= w2003 \ ticketlog;" &安培; _
用户ID = asp; &安培; _
" Password = asp;" &安培; _
" Database = argonet;"
Dim objConnection
设置objConnection = Server.CreateObject（" ADODB.Connection"）
objConnection.Open strDBConnection
％ >
==============================
它'在这一点上，我应该补充一点，这段代码就像我工作中的工作代码一样。只有名称已被更改。我还应该在家里添加，我正在处理的机器已经命名为W2003，所以当我设置SQL Server时，它命名实例
W2003 \ TICKETLOG。（Windows NT）。是的，它有括号中的那一部分。
我不认为斜线是问题。
无论如何，这是我在浏览器中看到的消息，当我试图得到到任何调用此连接代码的页面。
========================= ===========
用于SQL Server的Microsoft OLE DB提供程序错误''80040e4d''
用户''asp''登录失败。
/ ticketlog / includes /argodbinc.asp，第15行
====================================
我想补充一点，我确实在EP中去了服务器，去了Security，然后点击了用户名为asp的用户，然后转到数据库选项卡以确保
检查db_owner和其他所有内容。然后我为
INETUSER做了同样的事情。
好的，所以假装我之前从未做过任何这样的事情。我需要采取哪些步骤来设置这个东西？在我的情况下，我确实添加了一个名为asp的用户，并给予了完整的
权限，但我想我还没有这样做。也许有详细的手持指令，我会看到我所缺少的。
blockquote>
" Steven Burn" <所以******* @在-time.invalid>写了
http://aspfaq.com/show .asp？id = 2138
这个基本告诉我有混合身份验证，我已经
了。
< a rel =nofollowhref =http://aspfaq.com/show.asp?id=2126target =_ blank> http://aspfaq.com/show.asp?id=2126
这个有一些东西需要检查，但我的代码和设置与
完美结合了这篇文章的例子。
$ b这是你的其中一个还是btw？
http://www.issociate.de/board/post/1...setup_problems 。
html
是的。一个人回答说，这更像是一个评论，而不是任何我可以使用的b $ b。我放弃了这个项目几周，但我现在回到它了。
尝试打开查询分析器并使用asp / asp
凭据连接到该SQL Server。这有用吗？
Ray在家里
" middletree" < MI ******** @ HTOmail.com>在消息中写道
news：uR ************* @ TK2MSFTNGP15.phx.gbl ...<％
Dim strDBConnection
strDBConnection = _
" Provider = SQLOLEDB;" &安培; _
坚持安全信息=假; &安培; _
数据来源= w2003 \ ticketlog;" &安培; _
用户ID = asp; &安培; _
" Password = asp;" &安培; _
" Database = argonet;"
Dim objConnection
设置objConnection = Server.CreateObject（" ADODB.Connection"）
objConnection.Open strDBConnection
％ >
==============================
我想补充说我确实去了EP的服务器，去了安全，然后点击了用户名为asp，然后转到数据库选项卡，确保确认db_owner和其他所有内容都已经过检查。然后我为
INETUSER做了同样的事。
Sorry for the crosspost (I posted this on the asp.db group last night). But
since I had no answer there, I''m hoping for better luck here. I''m pretty
much tried everything I know. Here''s the problem:
I have an Intranet-based app at work, and I have it in two places there: a
dev machine and a production box. In both cases, the ASP files and SQL
Server 2000 database are on the same box. I have it running smoothly in both
places at work.
However, I''ve been trying to set it up at home, and cannot make the SQL
Server connection work for some reason. I''ve been working on this off and on
for weeks, and I just don''t get what I am missing.
First, my code:
<!-- #INCLUDE FILE="includes/dbinc.asp" -->
which points to a page contaning only the followig lines:
=======================
<%
Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ticketlog;" & _
"User ID=asp;" & _
"Password=asp;" & _
"Database=argonet;"
Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
%>
==============================
It''s at this point that I should add that this code is just like the
working code from my stuff at work. Only the names have been changed. I
should also add that here at home, the machine I am working on has been
named "W2003", so when I set up SQL Server, it named the instance
W2003\TICKETLOG.(Windows NT). Yes, it has that part with the parentheses.
I don''t think the slash is the problem.
Anyway, here is the message I see in the browser when I try to get to any
page which calls this connection code.
====================================
Microsoft OLE DB Provider for SQL Server error ''80040e4d''
Login failed for user ''asp''.
/ticketlog/includes/argodbinc.asp, line 15
====================================
I want to add that I did go to the server in EP, went to Security, then
doule-clicked the user called asp, and went to the database tab to make sure
that db_owner and everything else is checked. I then did the same for
INETUSER.
Ok, so pretend I have never done any of this before. What steps do I need to
set up this thing? In my case, I did add a user named asp and gave full
permissions, but assume I haven''t done that. Perhaps with detailed
hand-holding instructions, I''ll see what I am missing.
解决方案http://aspfaq.com/show.asp?id=2138
http://aspfaq.com/show.asp?id=2126
Is this one of yours aswell btw?
http://www.issociate.de/board/post/1..._problems.html
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"middletree" <mi********@HTOmail.com> wrote in message news:uR*************@TK2MSFTNGP15.phx.gbl...Sorry for the crosspost (I posted this on the asp.db group last night). But
since I had no answer there, I''m hoping for better luck here. I''m pretty
much tried everything I know. Here''s the problem:
I have an Intranet-based app at work, and I have it in two places there: a
dev machine and a production box. In both cases, the ASP files and SQL
Server 2000 database are on the same box. I have it running smoothly in both
places at work.
However, I''ve been trying to set it up at home, and cannot make the SQL
Server connection work for some reason. I''ve been working on this off and on
for weeks, and I just don''t get what I am missing.
First, my code:
<!-- #INCLUDE FILE="includes/dbinc.asp" -->
which points to a page contaning only the followig lines:
=======================
<%
Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ticketlog;" & _
"User ID=asp;" & _
"Password=asp;" & _
"Database=argonet;"
Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
%>
==============================
It''s at this point that I should add that this code is just like the
working code from my stuff at work. Only the names have been changed. I
should also add that here at home, the machine I am working on has been
named "W2003", so when I set up SQL Server, it named the instance
W2003\TICKETLOG.(Windows NT). Yes, it has that part with the parentheses.
I don''t think the slash is the problem.
Anyway, here is the message I see in the browser when I try to get to any
page which calls this connection code.
====================================
Microsoft OLE DB Provider for SQL Server error ''80040e4d''
Login failed for user ''asp''.
/ticketlog/includes/argodbinc.asp, line 15
====================================
I want to add that I did go to the server in EP, went to Security, then
doule-clicked the user called asp, and went to the database tab to make sure
that db_owner and everything else is checked. I then did the same for
INETUSER.
Ok, so pretend I have never done any of this before. What steps do I need to
set up this thing? In my case, I did add a user named asp and gave full
permissions, but assume I haven''t done that. Perhaps with detailed
hand-holding instructions, I''ll see what I am missing.
"Steven Burn" <so*******@in-time.invalid> wrote
http://aspfaq.com/show.asp?id=2138
This one basically told me to have mixed authentication, which I already
had.
http://aspfaq.com/show.asp?id=2126
This one had some things to check, but mine code and settings line up with
this article''s examples perfectly.
Is this one of yours aswell btw?
http://www.issociate.de/board/post/1...setup_problems.
html
Yes, it is. One person answered, and it was more of a comment than anything
that I could use. I dropped this project for a few weeks, but I am now
getting back to it.
Try opening up Query Analyzer and connecting to that SQL Server with asp/asp
credentials. Does that work?
Ray at home
"middletree" <mi********@HTOmail.com> wrote in message
news:uR*************@TK2MSFTNGP15.phx.gbl...<%
Dim strDBConnection
strDBConnection = _
"Provider=SQLOLEDB;" & _
"Persist Security Info=False;" & _
"Data Source=w2003\ticketlog;" & _
"User ID=asp;" & _
"Password=asp;" & _
"Database=argonet;"
Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open strDBConnection
%>
==============================
I want to add that I did go to the server in EP, went to Security, then
doule-clicked the user called asp, and went to the database tab to make
sure
that db_owner and everything else is checked. I then did the same for
INETUSER.
这篇关于连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
