I installed a SQL Server 2014 Developer Edition on a VM, because the Express Edition is limited to just 10GB. Now I've tried to conncet to that server remotely from my VM with SSMS. But I get an error that I cannot connec:
(provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (.Net SqlClient Data Provider)
On the Express Server there is an NT AUTHORITY\NETWORK SERVICE
login. So my conclusion was to add NT AUTHORITY\NETWORK SERVICE
to the logins, so I can access the server and databases with SSMS from a different PC, hoepfully.
I do find a NETWORK SERVICE
user when searching for it. It then shows up as VM-THIS\NETWORK SERVICE
. So no NT AUTHORITY
.
When I try to add the VM-THIS\NETWORK SERVICE
, on hitting OK, I get the following error:
Windows NT user or group 'VM-THIS\NETWORK SERVICE' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
Having a look at the error code couldn't help me solving this.
So on the one side I can find the user, but adding causes an error? What am I doing wrong?
NETWORK SERVICE
login to access the server on that VM from the VM I'm working on. – FredM Feb 7 '18 at 14:34