Post reply

Windows Authentication Failing

  • December 4, 2007 at 9:44 am

    #757037

    Just a quick update ... the Failover / Reboot / Failover didnt reolve anything, but did add more information.

    I can connect to the instance with Windows Auth when its on a different node, just not when it's on it's home node. So it seems to be a combination of my laptop with the instance on the home node, every other combination seems to work.

    Going to open a ticket with MS - I hate these unresolved issues. I will post back here when I get something new.

  • December 19, 2007 at 7:06 am

    #761378

    Final update for this thread - I called in a ticket to MS, who provided some assistance until the tech noticed we are still on SP3 (there could be a whole other converstion about that and management restrictions on applying service packs). However, I re-installed SQL on my laptop to fix problems with running Profiler, and now my SSMS connection works just fine with Windows Authentication.

    The conclusion is that the problem was local to my instance of SSMS, and that the re-install of SQL (and installing SP2 - I control what version is running on my laptop!) was the resolution. What the actual problem was though, I will probably never determine.

    Thanks to everyone who provided input.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply