Re: Windows authentication on SQL server

From: Jeff Dillon (jeff_at_removeemergencyreporting.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 09:18:42 -0700

Control Panel, Administrative tools, Services. Right click on the SQL
service, and change the login user from System to a domain user account

Jeff

"Bonj" <Bonj@discussions.microsoft.com> wrote in message
news:2324EB8B-0082-4E6A-9095-0F32D0F34FED@microsoft.com...
> 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

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: Trying to get a VB.net sample working with SQL Server.
    ... SQL server can have two types of logins. ... You can setup SQL to run in mixed mode (SQL and Windows) or Windows only. ... ASPNET is a windows account.. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Integrated Authentication (Kerberos) Problem
    ... Verify the SPN for the SQL service account is registered such as the ... >Thread-Topic: Integrated Authentication Problem ... A Windows XP SP1 with IE6 client machine ...
    (microsoft.public.inetserver.iis.security)