Everyone is a member of...

This is mostly easily done on the network side with an Access Control List (ACL) on the switch. However, on the server itself you could put an IPSEC Policy restricting...

Are you using a Windows login to connect to the first SQL Server? How do you have the linked/remote server security set up? Also, when you say data extraction tools,...

fhanlon (10/9/2007)

---

I have removed the builtin account on my clusters and it works. The cluster account must be made sysadmin as is the account the runs SQL and SQL...

Make that 2 votes for the use of upgrade advisor. It'll do syntactical checking you'd otherwise have to do by...

Greg Charles (10/10/2007)

---

Use sp_srvrolemember to make a login a member of a server role and sp_adduser to add a user to a database and make it a member of a...

Louis' blog has a SQL script which will give you all the explicit permissions. From there you're going to need to check role membership. Also, if you're dealing with a...

You'll need to query sys.database_permissions to get the full list of permissions. The system stored procedure sp_helprotect will not return information on securables that weren't present in SQL Server 2000....

Another possibility is network I/O on the client side. If the client is buried under network I/O, you could see a difference. It depends on how big a difference there...

Remote Desktop: If they are making undocumented changes, yes, their access should be revoked. However, before doing so, you might want to audit that server to see what else changed.

SA...

vrkc (10/10/2007)

---

Thank you for your reply but i am working with SQL server 2000. To my knowledge only SQL server 2005 creates default *.trc files. Please correct me if i...

Theo Jacobs (10/10/2007)

---

That's what I thought. For now the client will have to be satisfied with workstation name as it was them that wanted std sql login instead of (our...

There sounds like there is a security issue with the SQL Server you are trying to protect.

In order to connect, the client must have a valid login. How is the...

And be sure to do the normal security audits, especially to check when SQL Server is stopped and started. When SQL Server is stopped, the database files are closed and...

It should be noted that if you're using a named instance, you'll have to modify MSSQLSERVER and SQLSERVERAGENT to the correct service names. Also, the sc command can be used,...