SQL Login failed: Attempting to use an NT account with SQL Server Authentication
-
I'm trying to connect to an MS SQL Server for some application monitoring. This is my agent conf:
SubAgent = dbquery.nsm *DBQUERY Database = id=db1;driver=mssql.ddr;server=SQLSERVER;dbname=master;login=DOMAIN\Svc_User;password=secretpassword Query = ProcessMemory:db1:600:SELECT physical_memory_in_use_kb*1024 AS sql_physical_memory_in_use_MB FROM sys.dm_os_process_memoryThis is the error I get in agent log:
DBQUERY: cannot connect to database db1 ([Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'DOMAIN\Svc_User'.)And this is the error I see in the SQL Server log:
Login failed for user 'DOMAIN\Svc_User'. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: <local machine>]The SQL Server is set to "SQL Server and Windows Authentication mode", but I get the feeling nxagent tries to connect using an SQL account rather than an AD account.
Is it possible to connect with a domain user or do I have to use a local sql account?
(Using nxagent 4.2.461)
-
You should create local SQL account. It should be also possible to login with the same AD user NetXMS agent runs under (in that case you should specify * as login name and password is not needed).
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login