Not able to connect my MS sql server Database Source

Grafana MSSQL
21

Hi, I solved the problem by using answer from nasirtaha and turn off my firewall. Host port can be found from TCP/IP, that is 1433 for my case.

22

encrypt seems no problem.

23

image
image1137×242 65.9 KB
.
Running this service in SQL Server Configuration then you will able to connect. Hope you are success

24

this is server name. dont use that,
user Database name

25

Hi, please check <server>\<instance>:0 or <instance name>:0 it will work

1 Like
26

Hi

We have upgrade grafana from 6.5 to 7.3 version. However we are not able to connect to SQL Server and getting below error message.

Login error: mssql: Login failed for user ‘svc_grafana’.

It was working fine in Grafana 6.5. We are using SQL Server 2016 database to connection and we are able to ping the server from the server where we have configured grafana. Please help us with the solution.

27

Make sure you do as nasirtaha says above and
restart SQL Server service. i.e. from cmd.exe as administrator:

C:\Windows\system32>net stop mssqlserver
then
C:\Windows\system32>net start mssqlserver

28

I was able to connect with Dbeaver, so no firewall, configuration, etc, etc issues. This was the key. Thank you!

29

Hello, in case your MSSQL is running on docker for host value use
<your_container_db_name>:<port>

30

[sqleng.connectionError] failed to connect to server - Please try again. If the issue persists please open a support ticket that notes the time in UTC.

i got same error. my remote server is listening on 1433 and dbever and other machines can access the SQL Server. TCP and named both are enabled.

I just downloaded grafhana and learning things. Do i need agent?

How did you resolve the error?

31

Hello, this was the solution:

check <server>\<instance>:0 or <instance name>:0

1 Like
32

hello,
what is that thing and where to apply it ?

33

I use 2008 R2 Express edition

do you mean 192.168.1.12\sqlexpress:0 ?

1 Like
34

Is the address of the server. The trick is to add :0 at the end.

35

You are great man!

I tested it already and it worked.

yes added 0 and it worked exactly as following

192.168.1.12\sqlexpress:0

your responses are amazingly quick.

Thanks a lot.