Attempting to use an NT account name with SQL Server Authentication

Logon Login failed for user . Reason: Attempting to use an NT account name with SQL Server Authentication.

I have a Windows domain account like gooled\solarexpert that is set as sysadmin on mssql database, connect to Solarwind application.  The application connection is not successful. I check the database log, it is "....Reason: Attempting to use an NT account name with SQL Server Authentication."

I use this account gooled\solarexpert  on other database with same setting, it's no issue to connect. Most are nnncet5ed successfully, only few of them is with this error message.

Any advice?

I have tried almost all suggestions posted from web about this error, it still doesn't work.

My server is mssql 2012
wasabi3689Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
This sounds like an issue with your connection string: can you post it (taking out sensitive information)?
wasabi3689Author Commented:
where to get the connection string? from mssql or solarwind?
David Johnson, CD, MVPRetiredCommented:
A Sql Server Account is not a windows account. the SA account should just be solarexpert
a SA account authenticates against the database itself and not via windows authentication
Free and Easy Network Configuration

Network Configuration Generator is designed to make it easy to configure network devices, including Virtual LANs and other advanced features without opening the Command-Line Interface (CLI)! Help boost your network performance, run advanced network scripts, and bypass the CLI.

wasabi3689Author Commented:
If I use sql server account to connect, no issues. If I use Winodws domain account, that error message popped up in sql server log.


gooled\solarexpert

gooled is domain or host, this is just makeup.
solarexpert is the account name.
wasabi3689Author Commented:
We want to use Windows domain account to connect by Windows authentication, not allow sql server account by sql authentication
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
If you want to use Windows Authentication, you do not need to supply a user name and password. Specifying "Integreated Security=true" or trusted connection in the connection string would tell the SQL Server that you intend to use Kerberos/Windows Authentication. It would automatically fetch the user context of the user who initiated the connection and authenticate.
Leon AdatoHead GeekCommented:
Silly question, but are you certain that domain account has permissions to the solarwinds database? Typically when you set up SolarWinds you specify an account (either a SQL account or a domain account, but not both) and that's the one the polling engine (solarwinds server) uses to connect. Very few people give other accounts additional access to the db.

So I just want to verify that you are sure this account was given access at the outset.
Vitor MontalvãoMSSQL Senior EngineerCommented:
The application connection is not successful
How are you setting the connection in the application?
I'm second Nakul in his suggestion to check if you connection string has the Integrated Security set to yes.
Vitor MontalvãoMSSQL Senior EngineerCommented:
wasabi, a feedback will be appreciated.
Cheers.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.