Exact steps to setup a SQLOLEDB connection using a browser

Posted on 2007-11-13
Medium Priority
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?
Question by:saturation
LVL 25

Accepted Solution

imitchie earned 2000 total points
ID: 20277856
change to

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

Author Comment

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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

607 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