Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 015
Fifteen. It’s a one, followed by a 5. 15.
Credit for this one goes to my friend and teammate Matt Hester...
Q: Can you rename the SQL 2005 SA account?
A: Yes, as a matter of fact, you can! With the new security model there are some great ways to really secure the SQL Instance. You can rename the account with the ALTER LOGIN statement. This is a great way to reduce surface area for your SQL instances. Here is an example:
ALTER LOGIN sa WITH NAME = [new name here];
Additionally you can disable the account as well:
ALTER LOGIN sa DISABLE;
You can download a great presentation on the new Security enhancements for SQL 2005 here:http://download.microsoft.com/documents/australia/msdn/Session_2_Greg_Low.ppt
Got an IT question? Give me a comment, or contact me.