Solved

Exact steps to setup a SQLOLEDB connection using a browser

Posted on 2007-11-13
2
838 Views
Last Modified: 2008-02-01
I have an ASP web application that I have created using an Access database, but I recently upgraded to SQL Server and imported the data using Enterprise Manager.  Now, however, I cannot seem to get past the following error:

*******
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'JTLAPTOP\jt'.
*******

My connection string is
CONST strDataSourceName="Provider=sqloledb;Data Source=JTLAPTOP,1433;Initial Catalog=myDB;User ID=JTLAPTOP\JT;Password=xxxxxxxx;"

Here are some other setups I have:
1) LOCAL SQL Server registration--Mixed Mode with the System account as the "Startup Service Account."
2) Added JTLAPTOP\JT as a User to my "myDB" database through Enterprise Manager and given full access to the tables.
3) I have given access through IIS to the IUSR_JTLAPTOP account.  Lastly, I have added the "myDB" database to the ODBC "System DSN" as a SQL Server database (although I'm not sure I need to do this).

I'm stuck.  What exactly do I need to do from start to finish (from after creating the database and some tables to ) to get even the simplest ASP page I have setup to test the connection (a "hello world" test)--or just to get this thing up and running?
0
Comment
Question by:saturation
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20277856
change to

CONST strDataSourceName="Provider=sqloledb;Data Source=JTLAPTOP,1433;Initial Catalog=myDB;Integrated Security=SSPI"
0
 

Author Comment

by:saturation
ID: 20279391
I tried that, but now logging in is timed out by IIS.  
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question