Connection to microsoft SQL dB

Hello,
I have been working some time on creating a transaction group that sends to a Microsoft SQL database. I have done it successfully with a mySQL database, but I cannot seem to establish a valid connection with microsft SQl.
here are my details:

port is 1433 which is default
The data name is RTOdata, so would this be the instance name or the extra connection property.

Have you tried putting RTOData after the \ in your URL like it suggests?

What's the error you're getting?

Do you mean database name?

If it is a SQLExpress Server it will require you to have SQLExpress as the instance name. You would connect to this the same way you would connect to it through SSMS in terms of the path. Most standard SQL Server Installations come as MSSQLSERVER as the instance name (you can check the instance name based on the name of the service that is running typically)

1 Like

I solved a similar problem just by defining the port in the connection URL, even if using the default.

With SQL Express you'll also have to enable TCP connections. Search the forums and watch the Inductive University video on how to set up MS SQL. Do be aware of the limitions of the express version as it has a limited database size.

1 Like