New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Microsoft SQL SERVER v2. Can not log in using the specified credentials!

Votes:

0

Your Vote:

Up

Down

I have a problem with the sensor MS SQL v2. I create the sensor to test it in action on my PC to test the sensor . On the computer installed Microsoft SQL SERVER 2012 Express. When i run the sensor then I displayed the following error: Can not log in using the specified credentials! . I check all configuration options but always i have this problem with the sensor. As SQL query i use default sql file:Demo serveruptime.sql. As Instance name i used: SQLEXPRESS, because that's it true instance name. i very need your help. thanks) P.S. sorry about my English)

error-messages mssqlserver sql

Created on Jun 1, 2016 11:57:47 AM by  vladimirIalama (0) 1



Best Answer

Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hi Vladimir,

Please log onto the machine where the probe is installed and manually start the SQLv2.exe file in the directory

C:\Program Files (x86)\PRTG Network Monitor\Sensor System

Fill in the credentials and the query and see if it works. Please do also test an administrative database user to preclude access write issues.

Best regards, Felix

Created on Jun 2, 2016 10:05:49 AM by  Felix Saure [Paessler Support]



6 Replies

Votes:

4

Your Vote:

Up

Down

whats the rest of the error say? I have been having issues with the sql sensors using the context of the probe service instead of the windows creds set in the settings.

Created on Jun 1, 2016 6:04:19 PM by  kube1984 (550) 3 1



Votes:

2

Your Vote:

Up

Down

Hi Vladimir,

Did you enter the credentials in the Device Settings > Credentials for Database Management Systems settings? If so, the tip to change the security context of the probe service might help.

Best regards, Felix

Created on Jun 2, 2016 5:06:53 AM by  Felix Saure [Paessler Support]

Last change on Aug 1, 2016 7:30:03 AM by  Luciano Lingnau [Paessler Support]



Votes:

0

Your Vote:

Up

Down

error message is only : Can not log in using the specified credentials!

Felix, i didn't enter the credendtials in the

Device Settings -> Credentials for Database Management Systems , but now i do it and result is the same((

Created on Jun 2, 2016 7:37:36 AM by  vladimirIalama (0) 1



Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hi Vladimir,

Please log onto the machine where the probe is installed and manually start the SQLv2.exe file in the directory

C:\Program Files (x86)\PRTG Network Monitor\Sensor System

Fill in the credentials and the query and see if it works. Please do also test an administrative database user to preclude access write issues.

Best regards, Felix

Created on Jun 2, 2016 10:05:49 AM by  Felix Saure [Paessler Support]



Votes:

0

Your Vote:

Up

Down

What is the resolution for this issue? I tryied to use the SQLv2.exe getting the same results. Can not log in using the specified credentials. Reviewing the SQL log, I encountered with this error: Login failed for user Domain\User. Reason: Attempting to use an NT account name with SQL Server Authentication. I used the proper fields to fill account information in the SQLv2 app My SQL version is 2016 Datacenter. My PRTG is trial version.

Created on Dec 12, 2017 3:02:24 PM by  rgacitua (0)



Votes:

0

Your Vote:

Up

Down

Hi there,

Did you enable the Use Kerberos setting after starting the SQLv2.exe? This will be required so that the Windows authentication gets enabled.

Best regards, Felix

Created on Dec 13, 2017 2:08:24 PM by  Felix Saure [Paessler Support]

Last change on Dec 13, 2017 2:08:39 PM by  Felix Saure [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.