Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > SQL 2005: Renam...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 10944 of 11262
Post > Topic >>

SQL 2005: Renamed 'sa' account

by "Bill E." <billmiami2@[EMAIL PROTECTED] > Apr 7, 2008 at 06:38 AM

We have renamed the 'sa' account on a SQL Server 2005 machine.  When
we run

SELECT * FROM syslogins

it appears that 'sa' no longer exists as a valid SQL login.  However,
when we look at running processes through sp_who, we see that 'sa' is
still being used in various background operations, even when we shut
down and restart the SQL Server.  Can someone explain this?

Bill E.
Hollywood, FL
 




 3 Posts in Topic:
SQL 2005: Renamed 'sa' account
"Bill E." <b  2008-04-07 06:38:05 
Re: SQL 2005: Renamed 'sa' account
"Dan Guzman" &l  2008-04-09 07:43:29 
Re: SQL 2005: Renamed 'sa' account
"Bill E." <b  2008-04-09 17:30:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 2:58:06 CDT 2008.