Hi Everyone!
     I'm trying to use ASP.Net to access a SQL Server 2000 database through internet explorer using the asp file
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=t"
objConn.Open
%>

     I have my DSN set to my local server which uses Windows authentication to access the database but when I try to run the asp file I get the following error:
      Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
/SQLtoXML/connectionTemplate2.asp, line 3

       I know it is a very broad error but any thoughts would help. Thanks!

First question, while this code will compile in ASP.NET, are you sure you arent using classic??

Second, this could be a couple of reasons. 1 you haven't set the application directory up in IIS for integrated windows authentication AND you are allowing anon access to the application. What does your web.config look like and how is your application setup in IIS?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

How would I know if I am using classic? All I have been trying to do is pullit up through IE by typing out the path with the asp file being placed in another file located on the local host.
  I have checked the app directory in IIS and did ensure that integrated windows authentication has been enabled. I'm really new to ASP and am really not sure what needs to be done just yet. Would it matter if I am using notepad to write the code and placing .asp as the extension?

Ok. If your files have .asp extension they are Classic ASP pages. In so far as Notepad is concerened no it does not matter that you are using it, albeit, it is a bit tiedious.

In IIS, on the same tab that contains the check box for Integrated Windows Authentication, do you have the box checked that is associated with Anon logins? If you do, uncheck it.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Thanks for your response! I did what you told me to do and I get the same error. I have ASP.NET located in VB 8 and I would much rather use that than simply .asp files constructed in Notepad. Any simple tutorials to learn how to create a simple application in ASP.NET that you know of? I greatly appreciate your help!

One is not like the other in that ASP is much different then .NET.

First about your original problem, show me your DSN.

Second you may also want to check out
http://www.connectionstrings.com/?carrier=sqlserver

Third, read this article on impersonation
http://support.microsoft.com/kb/248187

Lastly Wrox publishes some great book on .NET, specifically this one seems geared to what you want to learn how to do:
http://www.wrox.com/WileyCDA/WroxTit...471781347.html

You can also check out these following resources
www.asp.net
www.asp101.com
www.4guysfromrolla.com

One of the Wrox Authors also maintains an informative site
http://imar.spaanjaars.com/

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Cool, thanks alot for all the information.

No problem.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========