SQLTeam.com | Weblogs | Forums

Hi everyone How Securing a SQL Server instance?

As part of the installation of my program, SQL Server Express gets installed as a prerequisite. In the initial setup settings, a password is defined for the SA. Once the installation is completed, a configuration routine creates a SQL Login which is used exclusively by my program.

Question #1 : is there a way using TSQL to zap all other logins including SA, thus leaving only my SQL login capable of accessing the databases through the software (or SSMS if need be)?

Question #2: is there a way using TSLQ to ensure that nobody can copy the database files and reattach them on another SQL server instance?

Thanks!

this same questions
are answered by Scott Pletcher

previously
in a different post
if i remember correctly !!!!