The Proxy can then be used instead of the SQL Server Agent Service Account when running, for instance, an SSIS package in a Job. So in our CDW case, we could create a Credential (under SSMS Security ...

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

I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.

Setting up your own proxy server may sound like a task reserved for IT pros or cyberpunks in movies, but the reality is much more accessible than that. Whether you’re looking to enhance your online ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...