New answers tagged sql-server
You can create a secondary dataconnection using the webservice and then populate a dropdown list by binding the dropdown field with any of the fields in that secondary dataconnection. If you still want to populate the dropdown in code then use the secondary dataconnection and follow the post here.
When you install SharePoint, you will have to specify the database containing SharePoint configuration. So one instance, multiple configuration databases.
At the very least, I would separate the server in two different instances on the same SQL Server, but I don't see it being completely impossible. Make sure that you create your config database as something else, and make sure all the databases are different than what is on the first farm. Use GUIDs wisely. I don't recommend this approach though.
Yes, You can One Sql Server with two Different SharePoint Farm. Currently i have two Dev farm(2013) sharing the Same Database server. As long as you have unique Names for yoru Config & content DBs. Having Enough hardware to support both farm I am positive you will not do this in production, big risk. IF DB server goes down...both farm will go down.
Moving to Azure SQL might make things simpler, but this technet article details a Hybrid BCS Solution for SharePoint Online. This picture details how the configuration ends up, in case the article goes away (unlikely)
SQL Reporting Services on SharePoint 2013 is a complex arrangement that also depends upon the version of SQL Server (2008/2012/2014). Reporting Services needs to be configured for the SharePoint integrated mode. Some links to get you started - Reporting Services with SharePoint Integration (TechNet) ...
BCS is the answer. Creating an External Content Type Open the Site in SharePoint Designer From left navigation click on External Content Types Now on the Ribbon you can see "External Content Type". Click on that to create a new ECT Provide a name, namespace To specify the SQL Server database for the external content type, click Click here to discover ...
Top 50 recent answers are included