No announcements
Found 330623 threads
-
0 VotesRenaming sa account
Hello, The only issue I know about renaming the sa account is the following support ...Answered | 2 Replies | 10194 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
Confirming if SA account is renamed.
Another mechanism you can use to quickly verify if the SA account has been renamed & disabled is the following: SELECT ...Answered | 3 Replies | 2640 Views | Created by Abid_S - Thursday, May 22, 2014 2:50 AM | Last reply by Erland Sommarskog - Thursday, May 22, 2014 9:29 PM -
0 Votes
disable the SA account
I always create another account on my instances that I use in case of emergencies.Answered | 3 Replies | 3922 Views | Created by muzzettemm1 - Thursday, January 21, 2010 7:24 PM | Last reply by muzzettemm1 - Thursday, January 21, 2010 7:46 PM -
0 Votes
SA Account
Follow the script below and you’ll find out who is using SA account.Answered | 2 Replies | 770 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
Brute force attack on sa account
And to add 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.Answered | 6 Replies | 8051 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
SQL SERVER SA Account
The sa account doesn't belong to a particular user, like a Windows user account should.Answered | 8 Replies | 26013 Views | Created by SRKenney - Wednesday, February 23, 2011 6:02 PM | Last reply by StefDBA - Monday, February 28, 2011 9:42 AM -
1 Votes
Database ownership and sa account
Just as an observation: I really dislike whenever the account "sa" is used.Answered | 6 Replies | 16354 Views | Created by srs007 - Monday, February 14, 2011 6:28 PM | Last reply by TiborK - Tuesday, February 15, 2011 7:00 PM -
1 Votes
sa account disable
If you want to follow "good" practice, first you need to make sure that appications are not using sa account.Answered | 2 Replies | 6606 Views | Created by hellozishan - Tuesday, August 23, 2011 12:43 AM | Last reply by Balmukund - Tuesday, August 23, 2011 1:20 AM -
0 Votes
Lost SA account password
QuentionBoy, If you don´t have any other SysAdmin account, you can try ...Answered | 2 Replies | 7219 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
change password for SA account
To know how to reset password you can follow this ...Answered | 2 Replies | 1696 Views | Created by Wallace Chan - Friday, October 4, 2013 5:57 AM | Last reply by Anuj Koundal - Friday, October 4, 2013 6:43 AM -
1 Votes
Ways of unlock sa account
Check this link http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx Thanks & ...Answered | 5 Replies | 10701 Views | Created by Kan Tse - Monday, May 13, 2013 2:18 AM | Last reply by Kan Tse - Friday, May 17, 2013 7:31 AM -
3 Votes
sa account lockedout
You can turn off 'enforce password policy' for login SA alter login [sa] with check_policy=OFFAnswered | 4 Replies | 7340 Views | Created by joo123 - Thursday, December 23, 2010 10:42 AM | Last reply by joo123 - Tuesday, December 28, 2010 8:06 AM -
0 Votes
Unable to enable SA account
Please log on to Windows using that account so that you should be able to create new SQL Server login account and enable SA account.Answered | 9 Replies | 22791 Views | Created by bdanby - Friday, September 17, 2010 11:00 PM | Last reply by Alex Feng (SQL) - Wednesday, September 22, 2010 5:53 AM -
0 Votes
Emulating "sa" account?
You will have supplied the logical server credentials when you created it (equivalent to SA).Answered | 1 Replies | 1012 Views | Created by edm2 - Tuesday, September 1, 2015 1:52 PM | Last reply by Guy Haycock [MSFT] - Thursday, September 3, 2015 8:54 PM -
0 Votes
Lost SA account password
Okay, I logged in with straight up local admin account, logged into SQL management studio with the local admin account.Answered | 11 Replies | 2304 Views | Created by Josh Gfeller2 - Monday, June 13, 2016 8:49 PM | Last reply by Josh Gfeller2 - Tuesday, June 14, 2016 7:06 PM -
0 Votes
sa account password is changed.
Reference: How to reset SQL Server sa password using Microsoft SQL Server Management Studio ...Answered | 7 Replies | 1498 Views | Created by Kalyan Chakravarthi (MCP) - Thursday, September 17, 2015 8:28 AM | Last reply by pituach - Sunday, September 20, 2015 3:20 PM -
4 Votes
unfortunately i deleted SA account in sql server?
You cannot delete sa account.Answered | 5 Replies | 6408 Views | Created by TSRam - Thursday, February 7, 2013 2:56 PM | Last reply by Ahmed Ibrahim - MSFT - Friday, February 8, 2013 4:02 AM -
0 Votes
Issues with Disabling the SA Account - SQL 2005
The recent only issue I remember related to SA is if you renamed SA for a 2005 or early version and try to upgrade that instance to ...Answered | 3 Replies | 9260 Views | Created by Ravi Velpula1 - Wednesday, December 22, 2010 7:58 PM | Last reply by SQLMojoe - Wednesday, January 5, 2011 10:32 PM -
10 Votes
Attaching MDF using sa account
Hi I am trying to attach the adventure works database with the 'sa' account but can not do so.Answered | 9 Replies | 1395 Views | Created by DigitalFM - Thursday, March 20, 2014 8:29 AM | Last reply by RAJU RG - Sunday, March 23, 2014 12:45 PM -
1 Votes
Accessing a Azure storage account SAS
A client who is in possession of a SAS can use the SAS to authenticate a request against a storage account for which they do not possess the account keys.Answered | 2 Replies | 1114 Views | Created by The real Slartibartfast - Tuesday, May 22, 2018 2:20 PM | Last reply by The real Slartibartfast - Wednesday, May 23, 2018 11:21 AM - Items 1 to 20 of 330623 Next ›
No announcements
