It is very difficult to figure out what should be the inputs of the mentioned fields on this page.Can someone please explain what input should be given in each of these fields and especially on the "Connection String"?P.S: Don't give links to documentations.Your help will be highly appreciated.Thanks
Discussion posts and replies are publicly visible
Nowadays we prefer to configure a data source using a connected system instead of the admin console.
in connection URL the hidden part is my <hostname:portnumber>and username is what SQL server uses with Windows authentication and password is same as what i use for system. what am i doing wrong here.thanks for participating in my discussion.
What is the URL of the Appian instance?
but when i'm trying to go on the link to install appian on windows it's giving error 401 unauthorized
Can you please answer the question? :) I didn't say anything about installing an Appian instance.
Are you trying to access a local database from a cloud instance?
uh yes. i am trying to access local database from the appian designer tab in which im making my app
You never answered my question
But regardless, based on the limited information you provided, I'm assuming that you're probably trying to access a local database on your laptop from either a cloud or on-prem instance. In both cases, you need to make sure that your database is visible to the Appian instance.
Not sure what else to say beyond that if you're not willing to share more information.
i am using the cloud community environment and trying to configure the local DB installed on my laptop.Hope this will give you more insight
That won't work unless you can expose your local laptop database to the internet.
can you tell me how to do that or if you can drop a guide for doing the same?thanks for replying
You can simply search for it on Google. That requires taking a DB server on a hosting for the ease. Or it requires keeping your laptop connected to internet always and making it public (steps could be found on google or Bard or chatGPT)
Same issue i am facing. How to do settings where we can expose our sql server to appian instance?
I am using Appian community version and need to pick database tables from sql server installed on my machine.