Sunday, February 19, 2012

How to HIDE SQL Server on LAN?

Hi everybodyIn my web application I am using SQL Server 2000. But as we all know, its presence in the network is visible to all the clients in the network. Anybody who has SQL Server client installed and knows the password of the database would be able to access DB remotely and this is what I don't want. I want user to access my database only when they are loggedon on physically (directly) on the machine on which SQL Server is installed.Your replies are awaited.Thanks in advance.Regards,Zulfiqar Dhuka

Go to Sql Server Enterprise Manager.
1. Expand Sql Server Group.
2. Select Server Node (local)
3. Right Click Select Properties, then select Security tab.
4. Select Authentication to Windows only, then OK

No comments:

Post a Comment