MS SQL Server - Block remote login

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Block remote login

Benny

2005-06-22, 8:23 pm

How can I block users from using their SQL accounts to access SQL 2000 server
remotely thru enterprise manager or sql query analyzer? Appreciate any help.
Thanks.

Hari Prasad

2005-06-23, 3:23 am

Hi,

There is no methodology in SQL Server 2000 to restrict the remote access; if
the users have access to network. The only way to restrict
is by setting complex password to the SQL Account.

Thanks
Hari
SQL Server Mvp

"Benny" <Benny@discussions.microsoft.com> wrote in message
news:0EE6279A-1977-4B3E-A4AB- EC1719C2B447@microso
ft.com...
> How can I block users from using their SQL accounts to access SQL 2000
> server
> remotely thru enterprise manager or sql query analyzer? Appreciate any
> help.
> Thanks.

Sponsored Links