Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

It doesn't matter at this point whether the server login is a Windows or SQL Server account; they each need you to grant it access to the database. Returning to Enterprise Manager, drill down to the ...