All Questions
Tagged with authentication linked-server
13 questions
3
votes
1
answer
170
views
Can I use a linked server that uses Windows Authentication when I'm logged in with SQL Authentication?
I'm using SQL Server 2016 (SP1) Standard Edition.
I have a linked server that uses Windows Authentication and needs to because it connects to a non-SQL Server database. It uses an OLE database ...
- 31
1
vote
1
answer
768
views
Can SQL Server OpenQuery/OpenRowSet to an LDAP Linked Server be used for Authentication?
I can fetch data back from LDAPS (port 636/3269) by first creating a Linked Server using sp_addlinkedserver and sp_addlinkedsrvlogin.
However, what I really need to do is to authenticate a Username/...
- 183
2
votes
2
answers
2k
views
When setting up security for linked servers, what does the Impersonate checkbox do?
Question:
what does this checkbox do?
- 2,668
1
vote
1
answer
447
views
Using linked server from Windows 10 PC [closed]
I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error:
Login ...
- 11
3
votes
1
answer
983
views
What sort of SPN / AD Computer Delegation do you need for delegation of credentials to a linked server that connects to a file share?
The idea here is to perform a double hop and delegate the credentials of the client ([email protected]), that have been sent to the SQL2.example.org server to SQL3.example.org (admittedly this is ...
- 1,722
2
votes
1
answer
5k
views
How to pass credentials to a linked server in another domain?
I am trying to link two SQL Servers (2008R2 and 2014) which are running in two separate (!) Active Directory domains.
The problem is that I can login into the remote server only with a Windows ...
- 393
2
votes
1
answer
4k
views
Running SQL job: The login is from an untrusted domain and cannot be used with Windows authentication
I have two databases in different servers (server1 , server2)
server1:
Login : login1 / password :123 /member of sysadmin (user user1,password:pass)
server2 :
Login :login1 / password :123 /...
- 153
5
votes
1
answer
13k
views
Create Linked Server to AlwaysOn Availability Group Listener
I have an alwayson availability group setup using SQL 2014 and Windows Server 2012 R2. There are 3 nodes in the group. The SQL Service is running as a Managed Service account on each node (1 MSA for ...
- 3,292
4
votes
1
answer
540
views
Change linked server login per-query
Given the situation below, can I specify that the pre-configured linked server login should not be used for a particular remote stored procedure call?
I have two SQL Server instances:
[LOCAL] running ...
- 173
1
vote
1
answer
103
views
Linked server in SQL Server 2005 using NT authentication impersonation
I am trying to Link a server using an NT authentication as the impersonated connection, but this connection will be static to a specific user instead of passing the currently logged-in user's ...
- 157
2
votes
1
answer
13k
views
How to run stored procedure in another database on the same server using a different login?
I have 2 databases (A and B) on the same server. Database A has user ua defined, and database B has user ub defined.
I have a stored procedure in A, running as ua, that needs to run a stored ...
- 21
25
votes
2
answers
98k
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
2
answers
433
views
Is there any way to connect to one server and utilize a linked server using Windows authentication and NTLM?
I currently have SQL Server 2005 (Server A) that has a SSAS 2005 linked server (Server B). The powers that be do not want to enable Kerberos authentication, so I'm stuck with NTLM.
The problem is ...