Windows Forum

Ask something
Discussion Locked

SQL login funkyness

0 helpful
5 replies

by nsteere

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Has anyone ever seen this:

User getting an RTE saying that their "domain/username" authentication failed.

This is strange because the server is set to only use SQL user authentication, not both SQL and NT domain authentication.

Note * This only happens to a few users and is intermittent in nature.
"Help me Spock.....help me"

5 replies

by jmiller1

It sounds like the client(s) are using Named Pipes to connect to the server. Check the enabled network protocols: Start->Programs->SQL Server->Client Network Utility. Set TCP/IP to be the default. ALso, is this happening in a client application or with SQL Server's tools?

by nsteere

That was pretty close--different protocol, same utility. Right on! BTW-Client app

by nsteere

Thanks jmiller1, it is happening from within a client app that connects to SQL for data. The app uses a SQL user account to authenticate, which works to the point of SQL authentication, then once they are in the app and try to querry the DB, they get denied based on domain redentials. I have seen errors where the SQL account fails and the RTE mentions the sql account. I have never seen the RTE mention a domain account before now.

This discussion is closed to new replies.