New answers tagged


Please try below mentioned code if it helps you. public override void Execute(Guid contentDbId) { try { // OpenSqlConnection(); using (SPSite site = new SPSite(SPContext.Current.Site)) { using (SPWeb currWeb = site.OpenWeb()) { ...


Given you did not reference your SQL Server by IP address when building the farm, the process is straight forward. Update the IP address. If you used the SQL Server hostname (computer name) on the farm, just wait for the IP address to update in DNS. If you used a custom A record, update the custom A record to point to the new IP address.


The best way to get the data from external SQL database into SharePoint would be through Business Connectivity Services. SharePoint 2013 has a new type of List called the External List which is used for displaying data that comes from Business Connectivity Services (BCS). You can connect with any external source (in your case it is a SQL database table) and ...


You can easily add SQL Server data to SharePoint list using one of the following way. Use BCS to insert data in SharePoint list from SQL Server table. Have a look at this link for better understanding. SharePoint List From SQL Server Table (External Content Type with SharePoint Designer) You can refer this article What is the best way to import SQL table ...


You do not have to do an inplace upgrade for SQL Server. That said, do keep in mind that SharePoint 2010 is only compatible with up to SQL Server 2012. SharePoint 2013 supports SQL 2014 with the May 2014 CU.

Top 50 recent answers are included