Re: Authentication methods for connections to SQL Server in ASP Pa

I made the following changes:
cst = "Provider=SQLOLEDB;data source=X099789\Widgets;Database=Automotive;
Trusted_Connection=yes;Integrated Security=SSPI;"

Now I receive the following error message.
Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

Additionally,
My users have been place into Groups, 1, 2, and 3. With each group having
different permissions. How does SQL know when the user attempts to access
the db which group they belong to and to allow or deny them access?

Auntie.


"Dan Guzman" wrote:

Microsoft OLE DB Service Components error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.

These errors are probably because there is no 'Provider' keyword in your
OLEDB connection string. Try adding 'Provider=SQLOLEDB'.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"AuntieAuntieAuntie" <AuntieAuntieAuntie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:EE4C5259-1F64-4893-9AF1-657A1C03917B@xxxxxxxxxxxxxxxx
I am trying to access SQL Server via an ASP page using a Trusted
Connection,
but it is not working. When I run the page I receive the following error
message:
Microsoft OLE DB Service Components error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
line 35

My connection string is in a separate file: cst = "data
source=X099789\Widgets;Initial Catalog=Automotive; Integrated
Security=SSPI;"

My code snipet looks like the following:
set OBJRST = Server.CreateObject("ADODB.Recordset")
Set objComm = Server.CreateObject("ADODB.Command")

objComm.ActiveConnection = cst '****LIne 35
MotorsSQL = "usp_MotorAll"
UIPWSQL = "usp_UIPW '" & struserid &"', '"& strpassword &"';"

objConnAll.open cst

What is the correct coding to connect to the SQL Server using Windows
Authentication in an ASP page?
I have read the instructions on:
http://support.microsoft.com/default.aspx/kb/247931, made the changes,
however the page still will not work.

Kindly assist. I will be thankful.

AuntieAuntieAuntie




.

Relevant Pages

  • Re: .NET data provider or OLEDB provider?
    ... >I don't see where you see a built-in query engine. ... >service provider, ... >OLE DB providers don't have to support SQL however, ... > SQL Server linked server, SQL Server can handle the queries. ...
    (microsoft.public.data.oledb)
  • Re: simple question re DELETEing in linked DB
    ... Could not execute query against OLE DB provider 'SQLOLEDB'. ... >>If the remote table is a SQL Server table linked through the OLEDB ...
    (microsoft.public.sqlserver.programming)
  • RE: Linked server data length issue
    ... I've no experience with Postgres or its OLE DB provider, ... reasonable to assume that you were connecting to another SQL Server ... OLE DB provider for Postgres, of if you use the MSDASQL provider, OLE DB ...
    (microsoft.public.sqlserver.server)
  • Re: Oracle Linked Servers
    ... To use distributed transactions with the Oracle OLE DB Provider in your ... I created a blank database in sql server ...
    (microsoft.public.sqlserver.server)
  • Re: OLE DB Provider not found for SQL Compact edition even after installing
    ... it raises exception saying that particular OLE DB Provider is not found. ... MSSQL CE registry entry) with value "Microsoft SQL Server Compact OLE DB ...
    (borland.public.delphi.database.ado)