No announcements
Found 266804 threads
-
0 VotesRenaming sa account
Hello, The only issue I know about renaming the sa account is the following supportAnswered | 2 Replies | 9903 Views | Created by MNRSPDev - Tuesday, May 29, 2012 11:44 AM | Last reply by Alberto Morillo - Tuesday, May 29, 2012 12:03 PM
-
0 Votes
SQL SERVER 2005 login failed message for sa login
attempt. With SQL Server 2005, you can make the unsuccessful attempts fail more efficiently by renaming the sa account. In addition to renaming it, you might ...Answered | 2 Replies | 7921 Views | Created by shitbhar - Monday, February 26, 2007 8:10 PM | Last reply by Raul Garcia - MS - Tuesday, February 27, 2007 1:04 AM -
4 Votes
will sql server still function after rename the computer host name?
One issue you might have is with Database Maintenance; sometimes when renaming a Server and/or moving it out of a domain the SA Account can be affected, therefore you may ...Answered | 7 Replies | 7274 Views | Created by George Zhou - Thursday, July 14, 2011 5:50 PM | Last reply by Anthony C-UK - Friday, July 15, 2011 10:05 AM -
9 Votes
Rename SA account
MASTER GO ALTER LOGIN sa WITH NAME = [your new-name]; GO 1.ensure before renaming the account ...Answered | 20 Replies | 20816 Views | Created by MandarAlawani - Tuesday, July 16, 2013 10:11 AM | Last reply by G Mallikharjuna Rao - Friday, March 9, 2018 6:57 AM -
0 Votes
Protecting The Master Database
Hello Forum I'm currently working on data security, so far I've been renaming the sa account, introducing TDE and introducing Backup ...Proposed | 3 Replies | 651 Views | Created by Anthony C-UK - Friday, December 8, 2017 9:51 AM | Last reply by Tom Phillips - Friday, December 8, 2017 12:56 PM -
0 Votes
SQL 2016 SA account - Backup database
Your colleagues are wrong. ...unless they have played the trick with renaming the original sa account and created a new account with that name as I discussed in my ...Answered | 11 Replies | 2326 Views | Created by Ahmed Abdulla Sallam - Saturday, November 23, 2019 4:33 AM | Last reply by Ahmed Abdulla Sallam - Saturday, November 23, 2019 5:03 PM -
2 Votes
SQL SERVER 2005 ( sa login disable automatically )
I would very strongly suggest renaming the sa account. That will stop anyone trying a brute force attack on it. Mike Hotek BlowFrog Software, Inc. ...Answered | 8 Replies | 8762 Views | Created by MSSQL DBA - Monday, April 20, 2009 11:01 AM | Last reply by MSSQL DBA - Wednesday, July 15, 2009 1:00 PM -
0 Votes
SA account
internalAnswered | 2 Replies | 6355 Views | Created by MF47 - Tuesday, November 6, 2012 9:02 AM | Last reply by MF47 - Tuesday, November 6, 2012 10:12 AM -
2 Votes
Login name logged as SA when running SQL Agent Jobs
kicks by sa. could you help me out with the following questions? 1)why the job steps are still executed as ...Answered | 2 Replies | 1678 Views | Created by MohanDakshin - Thursday, October 6, 2016 8:28 AM | Last reply by S_NO - Thursday, October 6, 2016 2:14 PM -
0 Votes
SA Account
out who is using SA account. EXEC xp_cmdshell 'SQLCMD' GO WAITFOR DELAY '00:00Answered | 2 Replies | 570 Views | Created by VijayKSQL - Wednesday, July 19, 2017 10:29 PM | Last reply by Teige Gao - Thursday, July 20, 2017 5:47 AM -
0 Votes
Disable Sa yesor not?
Whether disabling / renaming sa account really makes a server more secure always raises lots of discussion. It really is more for the "Answered | 6 Replies | 4753 Views | Created by Y_mrs - Monday, February 22, 2016 7:38 AM | Last reply by Hugo Shebbeare, SQL MVP - Monday, February 29, 2016 9:28 PM -
0 Votes
Brute force attack on sa account
to Ted's post linked above: after renaming sa, you could also create a new 'sa' account, with minimum privileges to distract would-be hacking attempts.HTHEwanAnswered | 6 Replies | 7817 Views | Created by muzzettemm1 - Monday, October 12, 2009 5:52 AM | Last reply by Amit Banerjee - Monday, October 12, 2009 11:49 PM -
0 Votes
Will disabling sa raise errors
Yes, they will run fine and continue to run fine. Renaming and disabling the sa account won't stop internal processes from being able to use the sa ...Proposed | 1 Replies | 770 Views | Created by Ed MoonXYZ - Friday, October 21, 2016 6:09 PM | Last reply by rvsc48 - Friday, October 21, 2016 6:22 PM -
0 Votes
Disable sa account error
Hi Baoyi, It seems that you use the sa account to connect the application. Suggest you create a new login and database user with only privileges which ...Answered | 4 Replies | 4480 Views | Created by Baoyi - Thursday, December 15, 2011 9:02 PM | Last reply by Baoyi - Tuesday, December 20, 2011 3:29 PM -
1 Votes
sa account disable
I agree with Dan. If you want to follow "good" practice, first you need to make sure that appications are not using sa account.Balmukund Lakhani | Please mark solved if ...Answered | 2 Replies | 6442 Views | Created by hellozishan - Tuesday, August 23, 2011 12:43 AM | Last reply by Balmukund - Tuesday, August 23, 2011 1:20 AM -
0 Votes
SQL SERVER SA Account
Tibor hits the major reason we avoid these accounts. From an audit and legal perspective, the issue is around non-repudiation. The sa account doesn't belong to a particular user, ...Answered | 8 Replies | 25354 Views | Created by SRKenney - Wednesday, February 23, 2011 6:02 PM | Last reply by StefDBA - Monday, February 28, 2011 9:42 AM -
0 Votes
sa user account info
Hi, if you are able to log in using Windows Authentication as Administrator then you can change the password of SA ...Answered | 4 Replies | 8503 Views | Created by nijen04 - Thursday, March 9, 2006 9:06 PM | Last reply by Hemantgiri Goswami - Monday, March 13, 2006 4:19 AM -
0 Votes
sa account recovery
Raul Garcia explains the workaround in his blog postAnswered | 3 Replies | 7163 Views | Created by J-rod1 - Tuesday, April 19, 2011 5:44 AM | Last reply by J-rod1 - Wednesday, April 20, 2011 3:18 PM -
0 Votes
Lost SA account password
http://www.mssqlcity.com/FAQ/Admin/forgot_sa_password.htmAnswered | 2 Replies | 6915 Views | Created by QuestionBoy - Monday, September 12, 2011 5:11 PM | Last reply by Fabrizzio Caputo - Monday, September 12, 2011 5:23 PM -
0 Votes
Enable SA account
The command "ALTER LOGIN sa ENABLE" should work. When you installed SQL 2008, you were asked to supply a Windows account that would ...Answered | 3 Replies | 5788 Views | Created by Chuck Sharp - Tuesday, November 29, 2011 9:45 PM | Last reply by - Wednesday, November 30, 2011 2:10 AM - Items 1 to 20 of 266804 Next ›
No announcements
