Questions tagged [sql-server-2012]

Add this tag, when your issue pertains to SQL Server 2012 or an error occurred in SQL server 2012.

Filter by
Sorted by
Tagged with
1
vote
1answer
991 views

Restoring the Existing Sharepoint farm using different SQL server instance

How to change the Database server instance of the the existing sharepoint 2013, when its current SQL server database instance is corrupt? Explanation; ->Sharepoint 2013 server lost all the ...
1
vote
1answer
3k views

Error configuring PowerPivot 2012 on SharePoint 2013. New-PowerPivotSystemServiceInstance - The PowerPivot System Service does not exist in the farm

Hi I'm hoping that someone can help me out here. I have a Multi-server dev farm that I am unable to provision PowerPivot correctly. It worked fine on the standalone farm. Any help would be ...
0
votes
1answer
1k views

Upgrade SQL Server 2012 to 2014 or 2016 for Sharepoint Server 2016 instance

I have a Windows Server 2012 R2 with Sharepoint Server 2016 installed but the SQL server version is 2012. What do I need to do to upgrade the database to 2014 or 2016. Everything is installed in the ...
0
votes
1answer
34 views

get AssignedTo column value from sharepoint tasks list using sql server query

I did SQL server query to retrieve tasks list data but the field AssignedTo not retrieved i don't know why? My SQL query : SELECT W.Title [webTitle], AD.tp_ID [Task Id], tp_columnset.value('(...
1
vote
0answers
74 views

Sharepoint 2013 TLS 1.2 SQL Native client issue

I've been following the below guide for updating to TLS 1.2. https://docs.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/enable-tls-and-ssl-support-in-sharepoint-2013 I am working to ...
0
votes
2answers
367 views

Getting SharePoint List data into a SQL Server table from URL

I have been hitting dead ends when trying to pull SharePoint List data into SQL Server. The goal is to query the data so I am able to use it in a Tableau dashboard. The reason we have to do it this ...
1
vote
1answer
96 views

Could not load file or assembly 'Microsoft.SharePoint.Library, Version=14.0.0.0

We have a custom workflow which works with Sharepoint 2010 and when we are migrating SP 2010 to SP 2013 we are getting the below error "Could not load file or assembly 'Microsoft.SharePoint.Library, ...
0
votes
2answers
23 views

Is it advisable to use SharePoint SQL DB instance to another application?

We are having SP 2013 on-prem environment. We are planning to have few applications which are using SQL as a backend. Is it advisable to use the same SP SQL Server DB instance to create DB for other ...
4
votes
2answers
56 views

SharePoint 2013 with SQL 2012 License Query

We have SharePoint 2013 with SQL 2012. Microsoft support for SQL Server 2012 has ended. Microsoft support for SP2013 is ending by 2023. We cannot migrate SQL Server 2012 to SQL Server 2016 as SP ...
0
votes
1answer
14 views

Steps to migrate SP 2013 with SQL 2012 from one physical server to another physical server under the same domain

Steps to migrate SP 2013 with SQL 2012 from one physical server to another physical server under the same DB & domain and using same server name.
0
votes
1answer
20 views

SharePoint Keys

I would like to purchase keys for SharePoint 2013 on-premise, windows server 2012, and SQL server 2012. But I can't find any hint over the internet on how to do it. Any assistance on the same will ...
3
votes
2answers
301 views

How to move SharePoint Provider Hosted App from development environment to production environment?

I'm using SharePoint server 2013 along with SQL server 2012, I have developed a provider hosted app in my development environment. Can anybody tell me how to move my app from development to production ...
0
votes
1answer
1k views

RBS Enabled Database Migration SharePoint 2010 to 2013

How can we do migration of SharePoint 2010 to 2013 RBS enabled database. We are using SQL database Attach & Detach method. With normal database we are able to do this. But RBS enabled database We ...
2
votes
2answers
7k views

Sharepoint Database Connection issue after recovering the content Database

Recently our SQL server which contained the SharePoint Content Database got corrupted. So we recovered the database. After that we tried to point out SharePoint System to the recovered database and we ...
1
vote
1answer
56 views

SharePoint SQL server volume shadow copy service is utilizing more disk space

we are supporting SharePoint 2013 on premises servers ans using SQL server log shipping configuration for Disaster recovery. We observed that Windows Volume Shadow copy service is enabled in SQL ...
1
vote
2answers
382 views

While fetching data from sql server in sharepoint web part getting error as Login failed for user 'NT AUTHORITY\IUSR'

I am trying to get data from SQL server's table in SharePoint custom web part.There I am getting error as "Login failed for user 'NT AUTHORITY\IUSR'". here is my simple code DataTable table = ...
0
votes
1answer
54 views

SharePoint deleted large site but released only 65% free space in content database

We have deleted one large share point site collection with space 150 GB through gradual delete job from a large content database size 300 GB. The job ran for 45 days but released only 100GB free ...
0
votes
2answers
290 views

Content Database with RBS - Maximum size?

what is the maximum size limit for a sharepoint content database when it configured with RBS . i mean max limit for content database .mdf file and rbs san / nas folder
2
votes
2answers
174 views

SharePoint 2013 / SQL Server 2012 Report Server Integration Feature Disappeared / Missing

Report Server Integration Feature has disappeared from Site Collection Features (Site - Site Settings - Site collection features under Site Collection Administration). Report Builder Report, Report ...
1
vote
2answers
2k views

How i can load data from sql server to office 365 list with ssis

Please help. OData connection load data from Office 365 to sql server. How i can load data from sql server to office 365 list with ssis?
0
votes
3answers
239 views

SharePoint SQL Server Databases are “Suspect” on every shutdown or reboot

I'll use this article: http://sharepointchips.com/recover-sharepoint-2013-databases-from-suspect-mode/ As a reference point. What is happening is as described in the article, my SharePoint 2013 SP1 ...
0
votes
1answer
1k views

SharePoint 2010 SP2 compability SQL Server 2012 SP4

Last year SQL Server 2012 got new service pack - SP4. Is it compatible with SharePoint Server 2010 SP2 (build 14.0.7190.5000)?
0
votes
1answer
1k views

Custom message for those who don't have access

How can I provide a custom message to a user who doesn't have access to a folder in Microsoft Online SharePoint? Appreciation in advance.
6
votes
1answer
11k views

SharePoint showing different time zone

I have created a SharePoint application which has a specific time zone. The Windows server where SQL Server and SharePoint are installed are using same time zone. When I create a new item in list in ...
1
vote
1answer
7k views

Is SharePoint 2010 supported on SQL server 2012 SP2

Is SharePoint 2010 supported on SQL server 2012 SP2? Thanks...
0
votes
1answer
975 views

Failed to open explicitly specified database

I've been tasked with resolving the following error that's appearing in our SQL Logs every few minutes. Login failed for user 'domain\workflowxxx-svc. Reason: 'Failed to open explicitly ...
1
vote
2answers
305 views

Deleted ldf files, Sharepoint database schema lost

After deleting manually ldf files related to the share point databases, it's impossible to connect to SharePoint sites. It shows: "Cannot connect to the configuration database" It is not related to ...
4
votes
1answer
302 views

Impact of SQL Server 2012 cu installation on SP 2013 on premise

I have to install the KB4019090 on my SQL Server 2012. My SharePoint 2013 farm with MS Project 2013 depends of it. What are the best practice to follow to make sure my farm will be up and running ...
0
votes
2answers
573 views

How to populate external data columns in a custom SharePoint 2010 list

Hello fellow SharePointer's. I am currently working on converting a custom solution to a more out of the box solution. I need to populate a SharePoint list with data from a SQL table which meets a ...
3
votes
3answers
17k views

Create External Content Type - Access denied by Business Data Connectivity

Following the technet articles on how to get external data into SharePoint 2013 (for testing purposes) I've created: Business Data Connectivity Service with Metadata Store Permissions Secure Store ...
8
votes
1answer
2k views

The UPDATE permission was denied on the object 'AllListsAux', database 'spContent', schema 'dbo'

Insufficient SQL database permissions for user 'Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation' in database 'spContent' on SQL Server instance '###' The UPDATE permission ...
1
vote
1answer
38 views

How to move the SharePoint's SQL Server Instance from one Server to Another

Am having a single server farm for my SP 2013, currently WFE is installed on Server01 and sql db in Server02 . I dont have sufficient space in server02, where sql server is running, like no D:\ drive ...
1
vote
2answers
2k views

How to update to Sharepoint 2013 SP1 and SQL Server SP2

I have, on my developer machine, a SharePoint 2013 with SQL Server 2012(Sp1 + CU6), mainly I focus on BI features. How to upgrade SharePoint to SP1 and SQL Server to SP2? Which Service pack should ...
0
votes
1answer
478 views

SSRS add in in sharepoint 2013

I am quite new to sharepoint. I want to use ssrs reports in sharepoint. I came to know by google that we need to install reporting services add in. My dev environment details are as follows. App ...
1
vote
1answer
125 views

Capacity planning for back-end SQL Server 2012 for a SP 2013 Farm

Would like to know how much MB of space/how much load SQL Server has to take when we upload a 8 MB - 10 MB size of document in document library in SP 2013 site collection. Cant we calculate as 10 MB ...
1
vote
2answers
37 views

There is any impact to share point farm if we install SQL Server 2012 Service Pack 3

There is any impact to share point farm if we install SQL Server 2012 Service Pack 3 and it will make any changes to sharepoint configuration databases and content dbs. we have below sharepont ...
1
vote
1answer
283 views

Performance degradation

There are 2 SP farms in different data centers, similar design: DC1 1 SP WFE: 15.0.4569.1000 MS SQL: 11.0.3128.0 DC2 1 SP WFE: 15.0.4849.1000 MS SQL: 11.0.6020.0 Due to need to migrate to ...
1
vote
1answer
120 views

SQL Max Degree of parallelism value

Recently we had to reconfigure entire SQL(SharePoint) server due to catastrophic failure in out storage components. While we have done that successfully, we have forgot to turn on the MAX Degree of ...
0
votes
1answer
35 views

SQL alwaysOn for sharepoint 2013 not able to open central admin

In our SharePoint 2013 environment we are performing SQL AlwaysOn activity. We have followed some MSDN blogs: https://blogs.msdn.microsoft.com/sambetts/2015/04/24/setting-up-sharepoint-disaster-...
0
votes
1answer
911 views

Connect SQL Server and Display data in Web Part

I am trying to get data from SQL SERVER and display in SharePoint 2013 web part. I wrote following code to connect SQL SERVER. But it gives an error "login failed for user 'nt authority iusr" when ...
1
vote
1answer
331 views

error while configure reporting services and run configuration wizard

I want to configure SQL Server reporting services service sharepoint 2013. install sql server 2012 then install manually service pack 1. In During installation of service pack 1, Reporting Services ...
0
votes
1answer
352 views

RBS error and unable to upload documents more than 1.5 MB to a database configured with always on/

We are unable to upload a document more than 1.5 MB to a SharePoint content database which is configured RBS storage, and SharePoint data source instance is configured with SQL Server always on and ...
1
vote
1answer
133 views

Document Version Storage

In SharePoint 2013 my understanding is that each version of a document is stored as a delta of the original document. i.e. each version takes less size on disk (in the content database) Is this ...
0
votes
1answer
2k views

C# Bind SQL Server Table in Sharepoint List

I want to copy sql server table in sharepoint 2010list, I know that Business Data Connectivity Service (BDC) might do it, but I have some problems and it doesn't work, so I want to do it ...
1
vote
1answer
86 views

SharePoint accounts being created in SQL with $ at the end

I'm getting the following error: (EVENT ID 3760) SQL Database 'WSS_Content' on SQL Server instance 'SQLSERVER01' not found. Additional error information from SQL Server is included below. Cannot open ...
1
vote
0answers
1k views

Failure in connecting to SQL Server Workflow Manager Configuration

So I am Configuring workflow manager 1.0 using the wizard. When I test connection of SQL Server Instance, I receive a red error "Failure in connecting to SQL Server". I am using "machine name\instance ...
3
votes
3answers
223 views

Content database recovery model rather than Full recovery importance in sharepoint

SharePoint Content Database are configured to run with a different recovery model than Full Recovery,is it important to configure content database recovery model to full recovery. We have 3 TB size of ...
0
votes
1answer
544 views

How can I install `SQL Server PowerPivot For SharePoint` for `SharePoint 2013`?

I have SharePoint 2013 and SQL Servere 2012 SP1 in my serever. I want install SQL Server PowerPivot For Sharepoint. I run SetUp of SQL Server 2012 SP1 and in Setup Role I Select SQL Server ...
1
vote
1answer
67 views

Hybrid SharePoint 2010 On-Premise with AWS EC2 (manage DB SQL Server 2012) [duplicate]

We have requirement one of client to maintain that SharePoint 2010 Server on our local Server instead of AWS EC2 and SharePoint Databases (Like SP_Config,WSS_Content, Service application databases) ...
1
vote
1answer
84 views

Restoring site collection on different sql server version

I am planning to restore a SP2013 site collection from a farm running on MSSQL 2008r2 into a different farm which runs on 2012 MSSQL. Is it possible? Is there any issue? thanks in advance