Re: how can i make one password

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/26/03


Date: Sat, 26 Jul 2003 09:53:14 +0100


You need to log into the three servers separately. Having the same 'sa'
password for all three servers is not good either from security point of
view.

If you are looking for least hassle method to log into different servers in
the environment without keying in the passwords everytime, use Windows
Authentication.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"khalid" <khalidmahmood90@yahoo.com> wrote in message
news:072b01c35345$d22d5160$a101280a@phx.gbl...
As per my scenario - i have one NT domian and three
different SQL Servers on three saperate machines. I want
my SQL logins to be maintained from only one servers,
i.e. by only one 'sa' login and password i want to login
to three saperate servers.


Relevant Pages

  • Re: Remote disk space analysis
    ... Check the drive space on all of the servers listed in a text file and store the output like Server name, Drive Name, Disk Space and Free space information on a SQL Server table. ...
    (microsoft.public.scripting.vbscript)
  • Re: SQL Clustered Node restarting unexpectedly
    ... Found it to be a NMI that was caught by the system BIOS ... Mike Epprecht, Microsoft SQL Server MVP ... > Servers on 2 nodes connected to SAN Storage using Fibre ... > for network name resource SQL network name ...
    (microsoft.public.sqlserver.clustering)
  • Re: using windows authentication...
    ... SQL Server DOES NOT TALK TO WEB ... Web clients request access and data from database servers, ... Server security. ...
    (microsoft.public.sqlserver.server)
  • Re: Hiding MS SQL databases in Enterprise Manager
    ... > When I create a database in the Microsoft SQL Server, ... > security issue, I would like to set it up so that users can only see ... > databases for which they've been assigned a role. ... your SQL servers, not at preventing a list of them. ...
    (Focus-Microsoft)
  • how can i make one password
    ... different SQL Servers on three saperate machines. ... i.e. by only one 'sa' login and password i want to login ...
    (microsoft.public.sqlserver.security)