0
votes
1answer
202 views

Kerberos Authentication Issue

I'm getting these errors when testing a linked server from SQL Server 2012 to SSAS 2012 (both servers are Windows 2012 and clustered) "An error was encountered in the transport layer" and "The peer ...
1
vote
1answer
2k views

How can I get my linked server working using Windows authentication?

I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
0
votes
1answer
189 views

BUILTIN\Administrators allowing access via linked server but not locally

We have two servers: LYNDB01 & LYNDB02 On LYNDB01 we have a database called db_ExampleDatabase We have created a Linked Server on LYNDB02 to LYNDB01 using no mappings and the "Be made using the ...
0
votes
0answers
908 views

SQL Server 2012 SSIS\SharePoint Kerberos auth [closed]

I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =) GOAL: Use Kerberos to avoid double-hop issue. USAGE: User logs onto ...
5
votes
1answer
1k views

Kerberos authentication not working with Linked Servers in SQL Server 2012

I am setting up a DEV/TEST environment using 2 SQL Servers running SQL Server 2012 on Windows Server 2012. We are moving from SQL Server 2005 on Windows Server 2008, where we already have this ...