Moving a DB to a different domain and then connecting

If a thief yanks (technical term) a hard-drive containing a SQL Server 05 database from a server and then installs it on a server in a different domain, is there any way he could connect to it? This question assumes that a hacker didn't somehow transfer the domain logins.

Could the local admin even add himself as a user to the database without having the admin login information from the previous domain?

Thanks,

As the server is attached by a sysadmin (no matter if its a malicious domain :-) ) the sysadmin will have full access to the database. Thats why the access to the physical files also has to be secured rather than just the logical access through autorization.

See this recently answered post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=801002&SiteID=1

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Move logins with passwords

Hello!
I will reinstall my server who has SQL server 2000, containing a few
databases with logins.
Which is the easiest way to store these on disk and when I have reinstalled
my server, add these to SQL again, hopefully containing passwords as well.
Regards Magnushttp://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly
SQL Server MVP
"MB" <magnus.blomberg@.skanska.se> wrote in message
news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> Hello!
> I will reinstall my server who has SQL server 2000, containing a few
> databases with logins.
> Which is the easiest way to store these on disk and when I have
reinstalled
> my server, add these to SQL again, hopefully containing passwords as well.
> Regards Magnus
>|||Thank you. It helped
Regards Magnus
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OtBdL4w9DHA.1636@.TK2MSFTNGP12.phx.gbl...
> http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "MB" <magnus.blomberg@.skanska.se> wrote in message
> news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> reinstalled
well.
>