There is no conflict. ...

tannguyen00 (5/14/2008)

---

Hi All,

Thanks for all the replies. Unfortunately the people that I'm working with will not add the nonsa user to the sysadmin role to the test enviornment or...

True but then why are you creating a SQL Login, just for installation,...

What on earth made you think this is a security problem?

Okay, I'd advise against trying to lock access to an application rather than a user. In general I take the security stance that if you are happy to grant...

So, ignoring all the rest; you're trying to prevent a Domain Administrator accessing "your" SQL Server?

Forget it.

It's a contradiction in terms, not to mention you are trying to fix a...

First off you need to know if the features of SQL comply with you "TOPSECRET" requirements.

With the Operating System holding the soft encryption keys, it's unlikely to meet many people's...

You guys have quoted supposition to make it sound like root cause.

By quoting this in the databaseweekly email:

"'Every DBMS in the world has these tools for database administrators. I would...

Greg's advice is technically correct, but why do it?

You are right to be concerned about 3rd party access to your live systems. Get them to script the job creation,...

Speak to the some1 who deleted builtin\administrators. Perhaps they had a reason.

The best solution to protect data in transmission is to use a VPN of some sort.

Otherwise, have you considered an HTTP endpoint with SSL?

You need to look outside the SQL process for best results, so something like Profiler or an IP related tool such as NetMon.

There is also the ODBC trace utility in...

Ewans given a lot of good info there, but if I may add my two cents...

Stripping? Well I've never seen anyone stripping in a datacentre, but the youth of...

Well users shouldn't be installing anything in a well managed environment, but this is a seperate issue, let's see if we can get it working by manually setting this up,...

Try it with a new local account - it should not be more than fifteen minutes work. Create the account, add appropriate user rights for a service (log in...