|
 |
asp_database_setup thread: Connection Errors
Message #1 by "Kevin D. Hammond" <khammond@l...> on Thu, 18 Oct 2001 17:31:17
|
|
New ASP programmer here.
I continually get the following error message if I try to connect to a SQL
database either on my local SQL server or on our Network.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user 'KEVINH102\IUSR_KEVINH102'.
/projects/TryItOut-2.asp, line 92
I have checked all my setting for this Logon for the SQL table.
I have deleted and recreated the DSN.
Nothing seems to change.
If any one has any ideas please let me know.
Thank you
Kevin
Message #2 by Eli Schilling <eschilli@t...> on Thu, 18 Oct 2001 12:54:56 -0400
|
|
You might try a DSN-less connection:
set conn = server.CreateObject("ADODB.connection")
conn.Open "Provider=SQLOLEDB.1;Driver={SQL
Serrver};Server=MYSERVER;Database=MYDB;UID=USER;PWD=PASSWORD;"
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 19 Oct 2001 17:37:55 +1000
|
|
Does IUSR_KEVINH102 have permission to login to the SQL Server?!? (this is
before any permissions to the database, and the table are evaluated)
Cheers
Ken
Message #4 by KEVIN HAMMOND <KHammond@l...> on Fri, 19 Oct 2001 08:38:08 -0500
|
|
Ken
THANK YOU A THOUSAND TIMES!
That worked.
I have been so frustrated with this error message and not getting any where
with it.
Thank you again.
Kevin Hammond
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Friday, October 19, 2001 2:38 AM
To: ASP Database Setup
Subject: [asp_database_setup] Re: Connection Errors
Does IUSR_KEVINH102 have permission to login to the SQL Server?!? (this is
before any permissions to the database, and the table are evaluated)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Kevin D. Hammond" <khammond@l...>
Subject: [asp_database_setup] Connection Errors
: New ASP programmer here.
: I continually get the following error message if I try to connect to a SQL
: database either on my local SQL server or on our Network.
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
: user 'KEVINH102\IUSR_KEVINH102'.
: /projects/TryItOut-2.asp, line 92
:
: I have checked all my setting for this Logon for the SQL table.
: I have deleted and recreated the DSN.
: Nothing seems to change.
: If any one has any ideas please let me know.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$subst('Email.Unsub')
|
|
|
View Cart
