> I want to prevent windows users from accessing my database on SQL server
> express 2005
[quoted text clipped - 4 lines]
>
> For the life of me I can't seem to find how to do this
First of all, if you granted access to any Windows login or groups,
remove these. Second, also revoke access to BUILTIN\Administrators,
which gives permission to all Windows logins that have admin rights
on the machine.

Signature
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Steve - 26 Jul 2007 01:18 GMT
Erland
Thanks worked a treat
Regards
steve
>> I want to prevent windows users from accessing my database on SQL server
>> express 2005
[quoted text clipped - 9 lines]
> which gives permission to all Windows logins that have admin rights
> on the machine.
Steve
I think the following has been introduced in SP2 and I did not test on
Express Edition ,sorry
/*Create a very simple login trigger */
create trigger AuditLogin_Demo
/* server means instance level*/
on all server
with execute as self
/* We specify the logon event at this stage
– Issue a rollback*/
for logon
as begin
if exists (select * from sys.server_principals
where type_desc ='Windows_Login'
and name=original_login() )
begin
ROLLBACK;
end
end
go
For more details please
> Hi All
>
[quoted text clipped - 11 lines]
> Regards
> Steve