Preventing [sa ] to login via Query analyzer [SQL Server 2005]

I am implementing the security and add different windows domain group and also assign then appropriate rights and permission.

No i want that if some knows the "sa" password and want to connect to sql server 2005 via query analyzer then message should display to user that u can not login with sa login while using SQL Server Query analyzer.

How i can identify and can display the message?

Thanks a lot in advance.

I don't think you can block sa access only for query analyser. The identity of the application connecting to SQL Server is spoofable so it really can't be trusted.

If you want to prevent the sa from accessing at all you can disable it with

ALTER LOGIN sa disable

and this will prevent sa from connecting.

hth,

-Steven Gott

S/DET

SQL Server