Login failed for User

From: George (george.muzzi@sourcemed.net)
Date: 10/21/02 

From: "George" <george.muzzi@sourcemed.net>
Date: Mon, 21 Oct 2002 06:34:35 -0700

Hi,

I have a question about logging in to MSSQL Server. Our
users can log in to our app if they are logged in to the
machine as Admin but can not log in to our app if logged
in to the machine as a User. If we add the Windows User to
the local Admin group, that User can then log in to the
app.
If the user is logged in as a regular user the odbc fails
with the message "login failed for User U_UserName" if we
set the odbc to Windows Auth.
If we set the odbc to 'SQL and Windows', the odbc test
fails with 'Login failed fro User sa'.
This is MSSQL 2000 with SP2 and WIndows 2000 Server with
SP3.

Any ideas on what the permissions the Users are missing?
Should we just recreate the Windows accounts?

Thanks a million!

Relevant Pages

  • Re: Windows.. its like coming home!
    ... gradual transition, especially in going from OS 9 to OS X. ... They needed something that could compete with Windows, ... mean by the "2 of every app" comment before - Apple took whatever apps ... I've found that because the Dock shows applications rather than windows, ...
    (comp.sys.mac.advocacy)
  • Re: Windows.. its like coming home!
    ... gradual transition, especially in going from OS 9 to OS X. ... They needed something that could compete with Windows, ... mean by the "2 of every app" comment before - Apple took whatever apps ... I've found that because the Dock shows applications rather than windows, ...
    (comp.sys.mac.advocacy)
  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Frustration level with Windows -- ARG!
    ... I can have an app sieze and you can go take a ten ... That is MS-Outlook, not Windows. ... to the processes tab, not the applications tab. ... and it tries to stop them "gently" if it can, before resorting to kill -9. ...
    (comp.sys.mac.advocacy)
  • Re: DOS applications ?
    ... A DOS batch file runs dos programs sequentially and can run ... command prompt window and keep the second command ... Windows APIs to do it. ... A 16-bit DOS app running on pure MS-DOS cannot launch another app ...
    (microsoft.public.vc.mfc)