SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do you get into the Central administration page and create a secure store application ID?

I am trying to connect to an external database and cannot do so with my current credentials. I have a username and password for the external database but would like to access it through sharepoint.

I've tried going into Sharepoint Designer -> External Content Types -> Add connection -> SQL -> And I have filled in my credentials and still cannot connect.

We use office 365.

Thanks, Catherine

share|improve this question

If I'm not wrong, you cannot connect to the SQL DB from oficce 365, but you can try to solve this issue as described in this solution.

share|improve this answer

You can use 3rd party to secure connect your SQL to O365. See here how it works for ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), RSS / XML feeds, SQL databases like MS SQL, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint (lists and libraries), local file system, Exchange, Active Directory, Dynamics NAV/CRM, Navision, SAP and many more. More complex data sources, web services, custom COM or .NET objects, can be connected using 3rd party add-ons. Cloud-to-cloud connections e.g. to, Twitter, Facebook, Google etc.

Cloud Connector Architecture

You can download here:

Thanks, Frank

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.