473,325 Members | 2,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How to synch renamed NT account with SQL Server 2005

We have NT accounts with access to our SQL Server 2005 database.

Infrastructure are going to rename the NT Accounts and I need to
secure a *no impact* scenario for our users. I'm reading here about
SIDs and syslogins but not 100% up on this area.
What is the best way to update / synch the NT account names within
SQL
Server?
Thanks!
Sep 8 '08 #1
1 1525
Jules (ju***********@james-chapman.co.uk) writes:
We have NT accounts with access to our SQL Server 2005 database.

Infrastructure are going to rename the NT Accounts and I need to
secure a *no impact* scenario for our users. I'm reading here about
SIDs and syslogins but not 100% up on this area.
What is the best way to update / synch the NT account names within SQL
Server?
Get new and old names into a mapping table. Then run:

SELECT 'ALTER LOGIN ' + quotename(oldname) + ' WITH NAME = ' +
quotename(newname)
FROM tbl

Copy, paste and run result. If the SID also changes, this too can be
addressed with ALTER LOGIN.

If you need to put this in a script, you can run a cursor over the
the result set and then EXEC() each row.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 8 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: Zeng | last post by:
Hi, I'm running ClrProfiler for the first time to profile my web app, and it keeps getting stuck at this msg box: "Waiting for Asp.net to start common language runtime - this is the time to load...
0
by: moko | last post by:
This is a bit long-winded. Can somebody read thru these 2 use cases, and tell me if it is feasible ? :- Use Case : Replication before Offline Synch Scenario 1 : Oracle Server , MSDE client ...
4
by: Brent White | last post by:
The aspx file was originally default.aspx, but I'm putting some other aspx files in that same virtual directory and I want to give it a more meaningful name. I renamed default.aspx in the IDE to...
0
by: CESAR DE LA TORRE [MVP] | last post by:
I am using WSE 3.0 with Visual Studio 2005, specifically I'm using Kerberos authentication and passing Kerberos ticket from Presentation Tier (VSTO.2005 client) to Server Tier through our Web...
5
by: rogersw8n | last post by:
Some how, some way the account that creates folders under Temporary Internet files has been changed to a domain account for VS 2003 and VS 2005. I recently installed VS 2005. All seemed to be ok...
2
by: DaBrain | last post by:
I am no DBA, but this is my task. I have an SQL Server 2000 Database that has an "SQL Account" that has execute permission on all Stored procedures. it is what was used by the company. This...
7
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I'm new to Visual Studio 2005. I'm creating a windows application using Visual Basic. After I added a control to a form and added some codings to the control, I want to rename the control. ...
2
by: Bill E. | last post by:
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...
3
by: Lauren Quantrell | last post by:
I recently upgraded to SQL Server 2005 from SQL Server 2000, and Access 2007 from 2003. When I run a ADP created in Access 2000 (which worked fine in Access 2002 and 2003) in Access 2007 everything...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.