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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 EM for local server only

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2006-07-02 : 07:30:29
I need to install SQL server for a user in his pc. How to make EM only for local SQL server only? That is: disable all connection to another SQL servers in network?

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2006-07-02 : 09:22:37
For more detail, in EM, register sql server wizard, in "Available servers" panel, how to list local server only and not allow user to type another server's name or IP?
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-02 : 09:57:42
many ways...
the fastest would be to define this definition in firewall

or do not provide him access to the servers, if he has no access via login then even if he can see the servers, he won't be able to register them or make successful connection

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -