June 30, 2022 at 9:19 pm
I have a target server that I have read-only access to with Windows authentication. We'll call this Server01.
I need to aggregate some data and do some analytics that isn't always easy in-session so I need to store some data more permanently than in temp tables. I also need to correlate with other data from other servers and database types. In order to resolve this, I installed a local instance of SQL Server Express on my workstation and created a linked server to Server01. We'll call the workstation local01.
From local01 logged in with windows authentication, I can query on the linked server.
I have a debian web server we'll call Server02 that has a lot of data tools on it and utilizing jdbc connection drivers.
I need the web application on Server02, utilizing a JDBC driver for SQL Server to be able to get data from Server01 using the only credentials I have access to which are my workstation Windows credentials.
Server01 is NOT running mixed mode and I have no control over it. The only thing I have control over are the debian web server and full admin rights on my workstation.
What are my options?
I have tried to lookup a way for JDBC to connect utilizing Windows credentials and if I was running the website on my workstation, Local01 instead of the debian webserver Server02, this would work, but that's not the case and I'm told Impersonation via connection string is NOT a thing.
I have tried using sp_addlinkedsrvlogin to map a user from mixed mode to windows authentication, but that fails. I have a feeling this might work and that I might be missing a step or something, but so far, no go. I have found numerous guides on how to do this in the opposite direction, local windows creds to remote SQL login, but I can't seem to find anything on how to go the direction I need to go.
I have tried Windows Creds on my debian server, but I need to add it to the domain first and while that's not impossible, I have to jump through some significant hoops to get it done and I'm trying to meet a deadline.
Any assistance would be greatly appreciated.
July 1, 2022 at 10:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 5, 2022 at 5:40 am
This was removed by the editor as SPAM
July 6, 2022 at 3:37 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply