M
middletree
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.
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.