Error Test connection to Grafana Cloud with MSSQL

Grafana MSSQL
,
1

  • 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

2

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?

3

Hi thanks for replying.
Is the log file from \grafana\grafana-v10.3.3\data\log ?. I am using sql user

1 Like
4

Where is the sql server located at in relation to your grafana cloud?

5

The sql server and the grafana are on the same premise

6

Can you from SSMS connect to this server using that SQL User?

7

I can

8

Can you post this screen (obfuscate any confidential data)?

image
image801×787 68.8 KB

9

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.

10

Is that <myIP> local IP? Is it available from internet?

11

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.

1 Like
12

Check these settings out

13

Yes, it is available

14

TCP/IP is already enabled with port 1433, remote connections are allowed too, still cannot connect

15

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

Capture
Capture742×624 37.6 KB

But failed here
Capture1

16

Hey @radasarap4,
I have this same similar issue.

image
image1904×885 75.2 KB

I have successfully connected PDC.

after that i am going Data Source, connect my MSSQL and save & test button click

image
image1920×902 77 KB

How to solve this errors?

If any one can help me, it is really appreciated.
Thanks in advanced.

17

It is similar, but it can be absolutely different. It is not clear how are you connecting (IP, HOST), authenticating (SQL, Windows), PDC logs, …