Adding trusted relationship to SQL server that uses Kerboros AD Authentication for local pc account

John Calhoun 0 Reputation points
2023-07-25T14:46:16.53+00:00

I am trying to do SQL report queries in excel. I can't connect our remote SQL database through my computer due to this error. I am on a local account on a laptop that I use to travel/work offline so I cannot utilize an active directory account for this pc. With the active directory restrictions on our server - is there a way for me to do this without a directory account?  

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,155 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,470 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,757 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 116.7K Reputation points MVP
    2023-07-25T17:29:49.1366667+00:00

    One way out is persuade your DBA to enable SQL authentication and create an SQL login for you. Then you can login with username and password.

    Then again, I don't see why you cannot use an AD account even if you are travelling. You can log in with cached credentials and have an VPN connection to the corporate network.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.