I have done all the steps but there is an issue.
- you have not told me the instance name of your SQL Server
- you have not told me port number as identified in the SQL log (like i showed)
And what is that?
What does your config look like now?
As I said...
Oh dear. One last try.
Please answer every question...
-
WHAT IS THE INSTANCE NAME OF YOUR SQL SERVER
-
WHAT PORT NUMBER IS YOUR SQL INSTANCE USING
If you do not answer, I can not help.
instance name: sqlexpress
port number:1433
Then use that in the Server field
Did you get that from the SQL Log? If not, it probably wont work!
Try deleting it. If that doesnt work, then look in the SQL Log (as I have pointed out a few times)
1 Like
Start simple.
Does SELECT 1 as Test work?
// i am sending this data to
SELECT TOP (2) [ID]
,[dataItemId]
,[timestamp]
,[name]
,[sequnce]
,[subType]
,[Position_Text]
FROM [NodeRed2022].[dbo].[Position]
Your answer was ambiguous ...
Yes mate
and there is another message
Is that a YES or NO, IT MADE AN ERROR?
Did SELECT 1 as Test work?
ALSO
You only need 1 MSSQL Config
... Delete ALL configs except for 1 (so we can avoid complications)
- Delete ALL configs, leaving only 1 config (so we can avoid complications)
- Using SQL Server Manager (or opening the SQL Log) find the PORT number for SQLEXPRESS03 instance
-
Show me a screenshot of the LOG or SSMS where the PORT number is shown
I have asked for this sooooo many times! (how to get port number of instance) - Try that PORT number in the MSSQL Config
Good, that is what I needed to see. Port number IS 1433 
However, you have hidden the INSTANCE name - not sure why (this is not sensitive info and just confuses matters for me while trying to instruct you)
So what do you have now in the MSSQL Config Node? (screenshot please)
