cannot connect to the database using sa or a new login

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 XXX
ociatied
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,
--
MitraThe 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 usin
g
>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 associ
atied
>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 X
P
>Professional system and there is no problem with connecting to any of its
>local machine databases.
>Please help!
>Thank you,|||Hi,
You change the authentication process from "Windows only" to "SQL+Windows"
with the following steps :
1- stop MSSQLServer service
2- edit the value
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\LoginMode to
assign it the value 2.
3- Restart the service
Note : the value LoginMode can be
1 for Windows authenticaton
2 for Mixed authentication
Rgds,
Chris
"mitra" <mitra@.discussions.microsoft.com> wrote in message
news:7A3CF1D3-892B-4054-8B72-FED592BE3FC7@.microsoft.com...
> 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,
> --
> Mitra