I have setup an SQL Server on a Windows 10 PC.
I was previously able to connect to it from another PC on the local network as well as offsite via VPN.
I have since encountered issues connecting, and need troubleshooting help.
I tried to redo the setup again from scratch, and it now does not work at all.
Issues are potentially relating to SSPI, active directory, kerberos, integrated security.
I have enabled tcp/ip, setup firewall inbound tcp 1433 and udp 1434, enabled remote connections,
Solution must be via windows authentication (not sql server authentication) e.g. server\sampleinstance, I do not want IP address login connection. Needs to work via SSMS and Excel.
Hello, I've experience of working with SQL servers and windows server. I am interested in your project and I'll solve the authentication issue. Best regards,