Re: sa login
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/24/04
- Next message: Gordzilla: "Re: Login failed for user 'sa'."
- Previous message: Kevin McDonnell [MSFT]: "Re: strange sql-server login problem"
- In reply to: Before The Gods: "sa login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 24 Aug 2004 06:56:56 +0530
Hi,
1. Since my machines are not part of the same network, is it possible
for a machine X to connect to a machine Y by using a Windows account,
like X\the_username?
Did you meant different domain, if it is different domain , you could set
a trust relationship between domains. After that you
will be able to access sql server using the OS users
2. If I want to use SQL logins only, how can I rename the sa login?
You cant rename or remove SA user. Only way to restrict the SA user is to
set a complex password which can not be guessed.
Thanks
Hari
MCDBA
"Before The Gods" <before.the.gods@gmail.com> wrote in message
news:c1e81694.0408231344.6debc066@posting.google.com...
> Hello
>
> I am in the process of securizing several SQL2000 DB servers within a
> computer farm. Each machine within the farm operate as a stand-alone
> server (no domain, no workgroup, no ressources sharing, no netbios, no
> nothing)
>
> In my understanding, the connection to a SQL2000 server can be done by
> using a Windows account or a SQL account. Starting from there, I have
> 2 questions
>
> 1. Since my machines are not part of the same network, is it possible
> for a machine X to connect to a machine Y by using a Windows account,
> like X\the_username?
>
> 2. If I want to use SQL logins only, how can I rename the sa login?
>
> thanks
> BTG
- Next message: Gordzilla: "Re: Login failed for user 'sa'."
- Previous message: Kevin McDonnell [MSFT]: "Re: strange sql-server login problem"
- In reply to: Before The Gods: "sa login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
