SQLServerCentral / Discuss Content Posted by Raj Vasant / Article Discussions / Article Discussions by Author / Making SA Work / Latest Posts

RE: Making SA Work

ruchika thapa — Tue, 24 Jun 2008 10:20:52 GMT

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.

RE: Making SA Work

bijulsoni — Tue, 14 Nov 2006 23:20:00 GMT

good Article very well explaining pls keep it up Your well wisher

RE: Making SA Work

SA-1 — Tue, 14 Nov 2006 06:49:00 GMT

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.

Making SA Work

Vasant Raj — Tue, 07 Nov 2006 10:21:00 GMT

Comments posted here are about the content posted at temp