Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-25 : 20:46:23
|
| Catalina writes "Dear SQL Team, please help me to restrict the access to my SQL 7.0 server-SPack3 (on windows 2000 server platform-SPack3) to one computer. I created a SQL user with special permissions on my database and I want to be sure that this user will connect to the database only from a specific computer.Usually, somebody knowing the SQL user and his password can query the SQL server from any pc from the network (using ODBC/Access or Enterprise Manager, Query Analyzer or isql).I want to restrict the access and the SQL user to be able to connect to the SQL server only from one computer (specified by me).Tks a lot...Catalina" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-26 : 00:13:33
|
HiWell you could make sure nobody else knows your password  Or you could set up a firewall, there are a few third party ones that are reasonably easy to configure. Or, if you are feeling game, you could look into setting up packet filtering in Windows http://online.securityfocus.com/infocus/1559Damian |
 |
|
|
|
|
|
Restrict acces to SQL server