Re: cannot connect to the database using sa or a new login

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/18/04 

Date: Wed, 17 Nov 2004 16:03:06 -0700

The error indicates you are trying to access the server with
SQL logins but the server is configured for Windows
Authentication only. So try changing the Authentication mode
to SQL Server and Windows.
You can find this by right clicking on the server in
Enterprise Manager, select properties and go to the security
tab.

-Sue

On Wed, 17 Nov 2004 14:48:02 -0800, "mitra"
<mitra@discussions.microsoft.com> wrote:

>Hi,
>
>I have problem connecting to any of the databases on the local machine using
>the "sa" or any of the logins that I had created and gave database access. I
>have SQL Server 2000 Developer Edition installed on XP Professional OS.
>
>I am getting the following error:
>
>Java.sql.SQLException: []Login failed for user ‘sa’. Reason: Not associatied
>with a trusted SQL Server connection
>
>I have never seen this error message.
>
>I have the same SQL Server 2000-Developer edition installed on this other XP
>Professional system and there is no problem with connecting to any of its
>local machine databases.
>
>Please help!
>
>Thank you,

Relevant Pages

  • 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: Windows Authentication and software in a hosted environment.
    ... What type of authentication are you using for the VPN? ... If you are using something like ISA server then the user is passing windows ... In my experience with hosted DB solutions almost always SQL auth is used. ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL Without Windows Authentication
    ... Are you connecting to the SQL ... Server via named ... >> I have a Windows 2000 server ... If I connect using SQL Authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL / IIS Application Pool Identity
    ... Set the authentication tag in web.config to "windows" (this way it actually ... to sql, which will obviously be different for each user. ... I want to use the application pool identity to make the> connection to the SQL server database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... Windows Integrated Authentication as that is what our network runs on. ... > of authentication are you using on SQL Server - Windows? ...
    (microsoft.public.dotnet.distributed_apps)