Login fails

Question

Post reply

Login fails

Viewing 7 posts - 31 through 36 (of 36 total)

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

Dale Corey SSCrazy Eights Points: 9019 More actions · Answer 1

One last thought. I don't want to steer everybody helter skelter. Have you installed Desktop Engine SP3a?

http://www.microsoft.com/sql/downloads/default.asp

All the best,

Dale

Edited by - dalec on 07/11/2003 1:04:16 PM

All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio

zach_john SSCertifiable Points: 5922 More actions · Answer 2

Yeah I'll have to drag them out of the closet, first I want some NT gurus look at. It's too wierd. On the client that's not part of the domain I connect to one of the SQL servers but not the other, and on the one I connect to event log on that server keeps showing me failure audits event id 529 and 681, over and over again as if it keeps trying to win autheticate while being connected through SQL authetication, Very Wierd

quote:
A network trace would be real handy right now... Are you or do you have anyone capable of sorting through one? Is Network Monitor set up on the server in question?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

John Zacharkan

zach_john SSCertifiable Points: 5922 More actions · Answer 3

I'm must apologize, for something that has become second nature when I'm looking at this that I forget to relate it in discussing any issues.

My environment is an active/active cluster.

John Zacharkan

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

Both are set to mixed mode, right?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

zach_john SSCertifiable Points: 5922 More actions · Answer 5

yes

quote:
Both are set to mixed mode, right?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

John Zacharkan

zach_john SSCertifiable Points: 5922 More actions · Answer 6

Found the answer, coming from an untrusted domain is the problem.

Even though I register my Server with a SQL server user login my EM still uses NT authetication to do polling.

To stop polling - go to EM, options, and uncheck Server State Polling. This stopped all the errors in the NT Security event log.

Of course this means I'm blind using EM if a service goes down, but I use email and page notification on that anyway.

Here's a bit more about what I found

http://dbforums.com/arch/30/2002/9/492936

Other items that hindered

Lan Manager authetication level should be equal 2K and above, NTLMv2 gave me a problem on xp pro, on 2003 it didn't.

Also one of the servers was listing on a port other than 1433.

Any thoughts on my answer would be most welcome.

Thanks all,

John Zacharkan

Edited by - zach_john on 07/23/2003 10:17:54 AM

John Zacharkan

Dale Corey SSCrazy Eights Points: 9019 More actions · Answer 7

Very interesting conclusion, John. I was not aware that EM acts a client, but it actually makes sense. I suppose that's where EM separates you as the Database Administrator vs. the System Administrator for the server.

All the best,

Dale

All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio