Making SA Work

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Raj Vasant » Making SA Work

Making SA Work

Rate Topic

Display Mode

Topic Options

Author

Message

Vasant Raj

Posted Tuesday, November 07, 2006 10:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:23 AM
Points: 199, Visits: 136

Comments posted here are about the content posted at temp

Post #320991

SA-1

Posted Tuesday, November 14, 2006 6:49 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 7:35 AM
Points: 1,140, Visits: 933

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

bijulsoni

Posted Tuesday, November 14, 2006 11:20 PM

Forum 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

ruchika thapa

Posted Tuesday, June 24, 2008 10:20 AM

Valued 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 »

Permissions