sqloutsystems
Connection String test failed: Outsystems
I'm using Outsystems Service Studio to develop a web application. I need to configure a connection to access a local server database. I get "Connection String test failed:
Unable to connect to any of the specified SQL hosts.
But I am able to connect the same database via MS SQL Server Management Studio", what is wrong?.
Please find the below image for more details about the connection issue.
Solution
1.When we copy & paste, sometimes Unicode characters will there. So need to type and fill our server details instead of copy&paste.
2.And Application Name should be full server name and then the server name should be server Ip only as like below.
[![enter image description here][1]][1]
[1]: https://i.sstatic.net/ZOfhy.png
- Why 5.0 / 2 returns 2.5000000000000000 (scale of 16) instead of 2.5 (scale of 1)?
- SQL - How to SUM and use WHERE clause on this SUM using 4 tables?
- The best way of storing many to many hierarchical data in sql
- How to group and number SQL results?
- How to prevent PostgreSQL from altering my nicely formatted SQL definitions
- How to perform division in SQL Server?
- Table Primary Key and Foreign Key Relationship Design for Invoices with Summary and Detailed Sections
- How to put the select result (column) in an array in PL/SQL
- SQL Query to use a Case Statement within and Aggregate Function
- How to get date difference from a column?
- Prioritization of data in SQL
- Operand type clash: date is incompatible with smallint error in sql server
- Are GUIDs timely ordered ? If ORDER BY used with a GUID variable type, will records created lately come late?
- Find SQL Server Job Related to Existing SSIS Package in Visual Studio
- Normalize Google Sheet table (1st step)
- How to get column between two values as per user input
- Problems selecting multiple column
- SQL convert nvarchar to float
- MySQL Workbench edit data
- Combine overlapping date ranges
- How to use values from CTE in ON CONFLICT UPDATE
- Expand the date range between two dates
- pyspark statistical window function keeps calculating NULL values
- sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'
- Sum a record with its previous not-null ordered by timestamp
- Prevent redundant results in SQL query
- SQL Query in Snowflake - Calculate Days of Supply
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- How to extract column names from SQL query using Python
- Select on self-referencing table where all chains meet a condition