 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / April 2008Chaning login name
There have been some major changes here at work, and in order to keep up we need to change some of the Group names in Active directory. Will the changes that are made in Active Directory cascade down into SQL Server? What is the protocol for this type of change? Thanks, Drew No. On 2005, you can rename a login (to reflect the name change) using ALTER LOGIN.  SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > There have been some major changes here at work, and in order to keep up we need to change some of > the Group names in Active directory. Will the changes that are made in Active Directory cascade > down into SQL Server? What is the protocol for this type of change? > > Thanks, > Drew What is the protocol for SQL Server 2000? Thanks, Drew > No. On 2005, you can rename a login (to reflect the name change) using > ALTER LOGIN. [quoted text clipped - 6 lines] >> Thanks, >> Drew You can't change the name for a login in 2000. You'd have to delete and re-create the login... SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > What is the protocol for SQL Server 2000? > [quoted text clipped - 9 lines] >>> Thanks, >>> Drew |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.