I am experimenting with SharePoint Designer 2010 to create various data sources. When creating database connection using SQL user id and pwd, i get a prompt saying that the user id and pwd will be stored in clear text.
I created a connection to the Northwind database, selected a table and saved the connection. I then created a webpart page, inserted data source and display the data on the web part page.
My questions are-
Which file actually stores the user id and pwd details and where is this file located?
Where are the configured Database connections or rather all the Data sources (database, rest, xml, soap) physically stored?
In Data Sources section in SP Designer I see lists, libraries, and Database Connections. I do not see any library in the sharepoint portal that contains this information.