Re: cannot connect to the database using sa or a new login
From: Chris V. (tophe_news_at_hotmail.com)
Date: 11/22/04
- Next message: Kevin McDonnell [MSFT]: "RE: SQL 2000 SSL"
- Previous message: Uri Dimant: "Re: Changing package's owner"
- In reply to: mitra: "cannot connect to the database using sa or a new login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 22 Nov 2004 16:41:48 +0100
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\MSSQLServer\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
- Next message: Kevin McDonnell [MSFT]: "RE: SQL 2000 SSL"
- Previous message: Uri Dimant: "Re: Changing package's owner"
- In reply to: mitra: "cannot connect to the database using sa or a new login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
