Learn tips for administering SQL Server securely. Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

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 ...