-
What Grafana version and what operating system are you using?
Grafana v11.0.0-67348 (778d80f922) -
What are you trying to achieve?
Successful connection from agent to cloud -
How are you trying to achieve it?
Following the instructions in configuration details -
What happened?
Error at the last “Test Connection”, it returned ‘An unexpected error occurred. Please try again.’ -
What did you expect to happen?
Successful Connection
welcome @radasarap4
please post the error from your grafana log file. Also what kind of user are you using for mssql connection?
a sql user or a domain user?
Hi thanks for replying.
Is the log file from \grafana\grafana-v10.3.3\data\log ?. I am using sql user
Where is the sql server located at in relation to your grafana cloud?
The sql server and the grafana are on the same premise
Can you from SSMS connect to this server using that SQL User?
I can
Host
<myIP>:1433
Database
SKEP_TEST
Encrypt
False
Authentication
SQL Server Authentication
sa
No PDC
failed to connect to server - Please try again. If the issue persists please open a support ticket that notes the time in UTC.
Is that <myIP>
local IP? Is it available from internet?
Also, in the above statement you state that Grafana is 'on the same premise" as SQL server, but elsewhere (in the title of the forum post) you stated that Grafana Cloud is running. Please clarify exactly how each is set up and accessed, as it could be a networking issue.
Check these settings out
Yes, it is available
TCP/IP is already enabled with port 1433, remote connections are allowed too, still cannot connect
I’m sorry for the misunderstand, the Grafana i meant is the agent.
Every set up (SQL server, grafana, etc) is done from the same computer.
The problem right now is that the “Test Connection” for the agent runs, but it does not run when i “Test Connection” to the cloud.
I successfully run the first connection test, which is
But failed here
Hey @radasarap4,
I have this same similar issue.
I have successfully connected PDC.
after that i am going Data Source, connect my MSSQL and save & test button click
How to solve this errors?
If any one can help me, it is really appreciated.
Thanks in advanced.
It is similar, but it can be absolutely different. It is not clear how are you connecting (IP, HOST), authenticating (SQL, Windows), PDC logs, …