How to prevent my Co-Workers from accessing my SQL

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to prevent my Co-Workers from accessing my SQL

Author

Topic

ZarrinPour
Yak Posting Veteran

66 Posts

Posted - 2008-05-17 : 23:19:49

Hi all

In our office we have simple Network (LAN) and for some reason in each workgroup Computer in this network we have installed SQL-Server 2000.

So far everything was ok but recently i noticed that my co-workers can easily access my Sql Server Instance through their Enterprise manager installed on their computers and then they can open my tables,view...and manipulate other objects.

for better illustration i have created a Flash Movie from this process , please check the following Link :

[url]http://www.Parsisoftco.com/movie/Sql/Sql.htm[/url]

How can i prevent others from doing so?
Any help greatly Appreciated.
Kind Regards.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-18 : 02:55:39

Revoke his login to SQL server - security.