Accessing SQL Server remotely using Windows Authentication

0
votes

I have setup SQLExpress on a Windows 10 PC and trying to access it via another PC.

I also configured my setup using this guide.

I was able to connect using SQL Server Authentication. However, when I tried connecting using Windows Authentication, I received the following message:

The login is from an untrusted domain and cannot be used with integrated authentication.

Is there a step I might have missed?

1
sql-serverdatabase-connectionssmswindows-authenticationremote-access
Make an effort. You provide no context and no one knows anything about your network topology. That error (just search on the first part of the message) has been discussed MANY times. Review those discussions to help understand the problem and how to address it (or at least what information others need to help you). - SMor

1 Answers

0
votes

You may need to launch your SSMS under a different set of credentials (runas) in order for it to connect via windows authentication. One way to do this is to create a simple batch file (or shortcut) to do so.

Create a batch file on your desktop and name it something like:

AltSsms.bat

Add the following line to the AltSsms.bat file:

runas.exe /netonly /user:{domain}\{username} "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

Be sure to replace {domain} and {username} with the actual values expected by the remote computer, and provide the full path to your local SSMS installation. I've provided my SSMS path for reference.

Save the updates to the batch file and then double-click it to open it. You should be prompted to enter the password for the {domain}\{username} you specified in the batch file.

Once SSMS loads (and assuming you've entered proper credentials), attempt to connect to the SQL Server instance with Windows Authentication. I've had to do this with several SSIS setups.