debugMinor
SSMS cannot determine if remote computer is connected to domain
Viewed 0 times
cannotssmsconnectedcomputerdetermineremotedomain
Problem
I've recently set up a new server with an SQL instance running on it (2017), I am able to connect to the server remotely using SSMS, but when I try to add a new login, I receive the attached error. Both machines are on the same domain.
I have already done some prior research and opened up ports 5002, 5001, 135 and 88 in the below configuration.
I have already confirmed that it is an issue with the firewall, as turning off the domain firewall allows access.
Am I missing something?
In case it's relevant, the server is hosted on Azure
I have already done some prior research and opened up ports 5002, 5001, 135 and 88 in the below configuration.
I have already confirmed that it is an issue with the firewall, as turning off the domain firewall allows access.
Am I missing something?
In case it's relevant, the server is hosted on Azure
Solution
This is an issue with the picker for selecting accounts when it cannot connect to the SMB port (or if NetBIOS isn't enabled, but you state that it works if you disable the firewall).
You can either try to open port 445 on the firewall or create the login using T-SQL.
There used to be a Microsoft KB Article for older versions of Windows but I believe this still applies.
You can either try to open port 445 on the firewall or create the login using T-SQL.
There used to be a Microsoft KB Article for older versions of Windows but I believe this still applies.
Context
StackExchange Database Administrators Q#248971, answer score: 5
Revisions (0)
No revisions yet.