We recently configured a SQL Server 2014 Cluster env. successfully
All services are up and running
TCP port was changes from default port
We are unable to connect from the local host to SQL Server using "Windows Authentication" for "ip,portnumber" from SSMS we face the following error
but we can connect SQL Server using "Windows Authentication" for "ip,portnumber" using SQL CMD
Except that we can connect to SQL Server from the client using SQL Logins for "ip,portnumber" or "named instance"
Thank you in advance
asked Aug 07, 2017 at 08:28 AM in Default
I would be inclined to have a look at the security log in event viewer to see if there is anything a bit more meaningful logged there, it would seem as though there is a login based issue rather than configuration based on the screenshot. Event viewer tends to offer a bit more detail at times. We recently had Sspi errors and in sql the errors were not so good but event viewer lead us to the fix.
answered Aug 11, 2017 at 06:22 PM