Problem connecting to MS SQL Server

Im new in outsystem

When trying to connect to a SQL Server Express I get this error: 

Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Hi Mark,

If you're new to OutSystems, trying to connect to an external SQL database is typically not the easiest thing to do. In what way are you trying to connect? Via Integration Studio? Is it inside Integration Studio you get this error?

Hi Mark;

That is a personal account correct? and your sql server express is on your computer correct? If this is the case the personal account that is on the web it cant access your sql server express.

Regards,

Marcelo

HI Guys, 

Even  i am also facing same issue. Mine is SQL Server installed into server ( Not an local Mechine). and Out sytems acocunt installed into Cloud. 


but still i am facing the isssue while connecting. 


Mark Anthony Gonzales wrote:

Im new in outsystem

When trying to connect to a SQL Server Express I get this error: 

Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 

 hy mark,

if you want to make database you can also make in built database in outsystems.

in data option part and create static entity or entity.

rohan goyal wrote:

Mark Anthony Gonzales wrote:

Im new in outsystem

When trying to connect to a SQL Server Express I get this error: 

Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 

 hy mark,

if you want to make database you can also make in built database in outsystems.

in data option part and create static entity or entity.

 

 Hi Rohan,

I am using MS SQL server 2017 Enterprise Edition, Not an Express Edition.