Windows authentication on SQL server

From: Bonj (Bonj_at_discussions.microsoft.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 03:53:02 -0700

Hello
In making an extended stored proc, I am trying to use a wizard-generated ATL
OLEDB consumer class to access data. I've tested this and it works fine when
run from a standard windows application.
When I debug the extended stored proc, it connects fine (it is connecting to
a remote SQL server).
However, when I deploy it to SQL server and run it from SQL when SQL is
running as a service, then trying to connect using ATL produces "IDispatch
error #3149", and an ADODB connection just returns the generic 'Access
violation occurred' error.
However I think I know why this is: when debugging, it is working fine
because it is logged in as me, and I can log in with windows authentication
to the SQL server on the other machine, but the SYSTEM account can't, which I
believe is the cause of why it is failing.

My question is, how can I add the SYSTEM account on my development machine
to the list of people trusted by the windows authentication of SQL server on
the other machine? It's MSDE so I'm an admin on it, so I can do this - if I
knew what to do!

Failing this I will create a limited account and hardcode its name into the
application, but I'd rather not do this if it's possible with windows
authentication.

Thanks

Relevant Pages

  • Windows authentication on SQL server
    ... In making an extended stored proc, I am trying to use a wizard-generated ATL ... OLEDB consumer class to access data. ... when I deploy it to SQL server and run it from SQL when SQL is ... to the list of people trusted by the windows authentication of SQL server on ...
    (microsoft.public.sqlserver.programming)
  • Windows authentication on SQL server
    ... In making an extended stored proc, I am trying to use a wizard-generated ATL ... OLEDB consumer class to access data. ... when I deploy it to SQL server and run it from SQL when SQL is ... to the list of people trusted by the windows authentication of SQL server on ...
    (microsoft.public.vc.language)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)