Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Making SA Work Expand / Collapse
Author
Message
Posted Tuesday, November 7, 2006 10:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
Comments posted here are about the content posted at temp
Post #320991
Posted Tuesday, November 14, 2006 6:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
In SQL 2005, you can also rename the 'sa' account. So if you renamed it to, say 'ss2k5guru', and someone tried to login as 'sa' they would receive the error that the login failed and not that there is no 'sa' account.
Post #322616
Posted Tuesday, November 14, 2006 11:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 15, 2007 12:12 AM
Points: 4, Visits: 1
good Article very well explaining pls keep it up

Your well wisher
Post #322917
Posted Tuesday, June 24, 2008 10:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184

what about the password after enabling the "sa" accout.
Can we just go to SECURITY>LOGIN>RIGHT CLICK ON SA > ENTER NEW PASSWORD THERE AND CLICK OK?

When i intalled SQL server it was in windows authentication so i don't remember if i have given any password to "sa" account myself..so can i just give password after enabling the "sa" account.
Post #522702
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse