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 |
|
born2acheive
Yak Posting Veteran
65 Posts |
 Posted - 2006-12-28 : 06:28:19
|
| hi,in i want to restrict others using my database using my system ip adress.how to block other using my sqlserver database,i am using sqlserver 2000. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-28 : 06:44:14
|
| If you do not want to others to access your SQL Server, don't give them access to it. Simple!In addition, you can set up Windows firewall or set up Active Directory Groups to restrict certain IPs from accessing your machine. Or better ask your network administrator to block them.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-28 : 07:59:42
|
| What environment are you running your MS SQL ? and over what frontend ? Are who are you looking to block out ? Your colleagues at work or the publicthis is a good way to start deploying your security. |
|
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-29 : 00:09:31
|
| hi afrika, i am working in c# asp.net.my collegues only using my system,so please tell me how to block others using my sqlserver database. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-29 : 01:19:48
|
| your problem is not clear at all.Block them how ? are you on the same network or what ?>>my collegues only using my systemDont understand that statement. However, if you change your SQL authentication to mixed mode. You will require a password before you login, else just put a password on your win machineAfrika |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-29 : 01:35:14
|
| But if others are SysAdmin on server / know SA password, you can not stop them accessing your database.---------------------------Sandesh - The Messenger |
|
|
|
|
|
|
how to block others using my database