Linked Server.

Question

Linked Server.

Sushant Yadav

SSCrazy

Points: 2780
More actions
February 26, 2014 at 4:04 am

#284008

Hi I need to configure linked server on SQL Server 2008.
I have some users with read only rights, and I don't want provide access to that logins on some linked server not all.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

check each of your linked servers, and make sure the option for this part is "not be made" or "be made using the logins current security context" if you are sure they do not have permissions on the other server.

For a login not defined in the list above connections will
[X] not be made

with that selected, if the user tries to use the linked server, it will fail with an error, most likely about Anonymous logins

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Sushant Yadav SSCrazy Points: 2780 More actions · Answer 2

Hi Lowell,

It is giving me following error,

TITLE: Microsoft SQL Server Management Studio

------------------------------

The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Access to the remote server is denied because no login-mapping exists. (Microsoft SQL Server, Error: 7416)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=7416&LinkId=20476

------------------------------

BUTTONS:

&Yes

&No

------------------------------

Lowell SSC Guru Points: 323518 More actions · Answer 3

the screenshot i provided is an example of where the only people using the linked server are explicitly defined in a list; my sa example int he first like is mapped, so sa would be able to create the linked server without error;

mydomain\lowell, even though he's a sysadmin, would fail, because a mapping specifically for my login doesn't exist.

you're falling into that category, i think.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!