Re: Cannot install anything on server as SA?
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/24/03
- Next message: Ray Higdon: "Re: Truncating the log"
- Previous message: TipTop: "what encryption is used in DTS"
- In reply to: Anon: "Re: Cannot install anything on server as SA?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Nov 2003 09:42:36 -0700
What is the authentication mode of the server? If the rest
of the error is something like "not associated with a
trusted SQL Server connection" then it's likely set to use
Windows Authentication only and you can't logon with a SQL
login (sa). You to connect using Windows authentication or
if needed, you can change the authentication mode to Windows
and SQL authentication.
-Sue
On Mon, 24 Nov 2003 10:09:26 -0500, "Anon" <anon@anon.com>
wrote:
>This is the message I receive...
>
>SQL Server registration failed. Login failed for user 'sa'.
>
>Thanks again!
>
>Luis
>
>"Anon" <anon@anon.com> wrote in message
>news:#c8LEfpsDHA.3744@TK2MSFTNGP11.phx.gbl...
>> Hello all!
>> I have a strange problem, we need to install a few pieces of software on
>our
>> SQL 2000 sp3 server but either of them will not take sa as a DB login to
>> create the DB's! If I install one software remotely, which is an option
>for
>> one, but not the other, it works fine, but if I physically try from the
>> server it will not install or login!
>>
>> Any help would be appreciated!
>>
>> Luis
>>
>>
>
- Next message: Ray Higdon: "Re: Truncating the log"
- Previous message: TipTop: "what encryption is used in DTS"
- In reply to: Anon: "Re: Cannot install anything on server as SA?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
