Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 lost sheep

Author  Topic 

acollins74
Yak Posting Veteran

82 Posts

Posted - 2009-09-04 : 08:19:07
Windows 2003 server cluster sp2
SQL Server EE SP3 CU4

This week I moved a named instance from one drive to another drive.
Everything went well as expected.

But I found later that One NT ID, (of course a very important one), out of several lost its permissions to 60% of its databases.
The most odd thing that I found was that the id was not orphaned in the databases. Just gone.

Note: I did detach and reattach the user databases before moving the system databases. Also, the move was just across drive letters not servers.

Any info or experiences shared would be great.
   

- Advertisement -