Re: Linked Server Access

I think you better create two Windows Global Groups and create a login for this group on the linked server and this group login.

And put the ones whom you don't want to login to the SQL Server to the second group. You do not need to deny or something this group. They don't already have login on the linked SQL Server. And do not forget to drop Domain Users from the login of SQL Server if it's existed so that only the first group will be able to reach resources on the linked server.

So, you will be able to manage your users easier.

If this does not work for you, please let me know.

Permissions of Fixed Server Roles:
http://msdn2.microsoft.com/en-us/library/ms175892.aspx

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



"Agho" <Agho@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A0BB28AF-3A1F-4396-ADFD-461107E4BDD0@xxxxxxxxxxxxxxxx
I have a linked server setup on a server. Is it possible to restrice who can
use the linked server? Can I create a role and just give users read only or
select permission to the linked server?

Thanks.

.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)