How to prevent SQL Server registration????/ 1

[johnny123]

I need to prevent users registering a server on their machine but need them to have permissions on the DB - can I prevent someone registering the SQL server from a machine on the network and still allow them all capabilities??

Thanks

 

[rajeevnandanmishra]

Hi johnny,

You can not prevent users from registrating the server if they have access to any of the DB.
What you can do is to define their access only to require DB and only required level of access.
Howewer, in that case, user can register the SQL server, but can do anything only as per security rights.