Re: Linked Server


"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C79A468B-070B-48C7-9075-E48FCDE866E6@xxxxxxxxxxxxxxxx
It appears that you want pass through authentication, i.e. you want the
first
SQL instance to be able to delegate on your behalf to the 2nd SQL Server
via
the linked server. In that case, you need to enable Kerberos
authentication
support on these SQL Server instances.

I thought you could impersonate using my Window Credentials (which I am
logged on to my local sql server with).

Not sure how to set up Kerberos authentication for this.

Thanks,

Tom


Linchi

"tshad" wrote:


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9C4B49BE8896Yazorman@xxxxxxxxxxxx
tshad (toms@xxxxxxxx) writes:
If I am trying access DEVSqlServer (the name of the server that has
the
default Sql Server instance), how would I change the
sp_addlinkedserver
to
use this Servers name?

In many casess when you set up a linked server, all you say like:

EXEC sp_addlinkedserver 'DEVSqlServer'

However, a linked server name is really an alias, and you could say:

EXEC sp_addlinkedserver 'Fritz', '', 'SQLOLEDB', 'DEVSqlServer'

With the reservation that I'm doing this from memory. There is a
parameter
@datasource (or @datasrc) which specifies the server, and which
defaults
to be the same as the alias.

Whether you will actually be able to use linked server remains to see.
Working with linked servers is a good method to increase your amounts
of grey hair.

Plenty of grey hair.

I did get the linked server set up but it won't connect. It is not
passing
Authentication.

I would like to connect using my Windows Login for the office since both
servers are in the office. Using the GUI, I set up a a local Login and
set
it to my Windows Login (which was in the list) and then set it to
impersonate.

I tried using all the 4 buttons at the bottom (putting my Windows
Credentials in the last button - Remote Login).

But it still wouldn't connect.

It kept saying:

Login failed for user "NT Authority\Anonymous Logon". (Microsoft Sql
Server,
Error 18456

How do I get it to use the Logins I input?

Thanks,

Tom

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx






.

Quantcast