GRANT ALTER ANY EVENT SESSION TO [Sparkhound\DB Administrators-Readonly] GRANT VIEW ANY DEFINITION TO [Sparkhound\DB Administrators-Readonly] GRANT SHOWPLAN TO [Sparkhound\DB Administrators-Readonly] ...

BR><BR>They also want their service to run as a local admin account on the machine.<BR><BR>I can't say I'm overly psyched about any of those terms.<BR><BR>IMHO an SQL Server should be very secure ...

SECURE your systems administrator log-in account with a non-NULL password. BLOCK port 1433 at your Internet gateways and/or assign SQL Server to listen on an alternate port. If port 1433 needs to ...

You may encounter the SQL Server Error 18456 if the server could not authenticate the connection and this can be caused by the non-availability of the administrator ...