x

Error logging with Windows Authentication from SSMS

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

alt text

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

10708.png (47.4 kB)
more ▼

asked Aug 07 at 08:28 AM in Default

avatar image

DBA01
1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 11 at 06:22 PM

avatar image

Adedba
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x111
x76

asked: Aug 07 at 08:28 AM

Seen: 17 times

Last Updated: 5 days ago

Copyright 2017 Redgate Software. Privacy Policy