Questions tagged [sql-server-2012]
Add this tag, when your issue pertains to SQL Server 2012 or an error occurred in SQL server 2012.
101
questions
0
votes
1
answer
94
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
1
vote
0
answers
133
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 ...
- 11
0
votes
2
answers
826
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 ...
- 51
1
vote
1
answer
164
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
2
answers
25
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 ...
- 787
4
votes
2
answers
59
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 ...
- 1,460
0
votes
1
answer
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
1
answer
21
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 ...
- 109
3
votes
2
answers
320
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 ...
- 51
1
vote
1
answer
60
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 ...
- 585
0
votes
1
answer
72
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 ...
- 585
2
votes
2
answers
197
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 ...
- 435
0
votes
1
answer
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)?
- 717
1
vote
1
answer
7k
views
Is SharePoint 2010 supported on SQL server 2012 SP2
Is SharePoint 2010 supported on SQL server 2012 SP2?
Thanks...
- 25
0
votes
1
answer
1k
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 ...
- 123
1
vote
2
answers
420
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 = ...
- 1,494
1
vote
2
answers
328
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 ...
user70109
4
votes
1
answer
321
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 ...
- 99
0
votes
2
answers
623
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 ...
1
vote
1
answer
44
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 ...
- 3,526
2
votes
2
answers
9k
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 ...
- 203
0
votes
1
answer
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 ...
- 309
0
votes
1
answer
488
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 ...
- 364
1
vote
1
answer
127
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 ...
- 3,526
1
vote
2
answers
40
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 ...
- 2,905
1
vote
1
answer
301
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 ...
- 274
1
vote
1
answer
127
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 ...
- 103
0
votes
1
answer
40
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
1
answer
941
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 ...
- 2,082
1
vote
1
answer
351
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 ...
- 187
0
votes
1
answer
388
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 ...
- 2,905
1
vote
1
answer
134
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 ...
- 2,147
0
votes
1
answer
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 ...
- 303
3
votes
3
answers
254
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 ...
- 2,905
1
vote
1
answer
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) ...
- 58
1
vote
1
answer
86
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
- 333
0
votes
1
answer
287
views
Reconfigure SharePoint to a new Sql Server box
I am having SharePoint 2013 installed and configured on a Windows Server 2012 machine without Sql Server enterprise edition[ I mean,inbuilt sql server express edition]. Now, I would like to configure/...
- 3,526
1
vote
1
answer
4k
views
SQL database login for 'Config' on instance '' failed. Additional error information from SQL Server is included below
In our internet farm in search server I saw below errors in event viewer. How to solve these issues.
SQL database login for SPL_Config' on instance 'SQL123_SQL' failed.
Additional error ...
- 2,905
0
votes
3
answers
318
views
Non sharepoint databases in same sharepoint sql server instance and issues?
we have a SharePoint 2010 farm and sql instance for this farm in a sql farm,
and if create non-SharePoint related databases in same instance for SharePoint farm,
is any danger / issues to SharePoint?...
- 2,905
0
votes
0
answers
332
views
SSRS report and performance point filter issue in sharepoint 2013
Deployed a dashboard in a sharepoint site
this dashboard it has a Performance point filter which is get data from report database
and it has a performance point report it is connected with a report ...
- 2,905
0
votes
2
answers
1k
views
SharePoint 2013 and SQL Server 2012 Service Pack 3
Our DBA wants to apply Service Pack 3 on SQL Server 2012, has anyone installed SQL Server 2012 SP3 on a SharePoint 2013 farm?
Any catch outs?
Any articles that show it is supported?
- 3
0
votes
2
answers
321
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,905
1
vote
1
answer
96
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 ...
- 453
1
vote
0
answers
75
views
How big size of File stream folders created automatically in RBS folder for a content database
There is a content database configured with RBS , and this RBS folder size is 2 TB, and web application has used to upload documents mostly and working fine but in the last weekend there is no ...
- 2,905
5
votes
1
answer
1k
views
RBS on SharePoint 2013 file size limit
I read the MSDN article (https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx) where it says that enabling FILESTREAM storage will allow to overcome the limitation of 2GB file sizes. ...
- 53
2
votes
1
answer
1k
views
Failure to Configure New Farm (Keyset does not exist)
I'm trying to set up a SharePoint Foundation 2010 farm on my local Windows 10 machine in order to make a dev copy of our production site. I have SQL Server 2012 installed, and I point the ...
- 346
4
votes
1
answer
55
views
MIgrate sql 2008 to 2014 with sp 2010
I have a customer with SP 2010 Foundation and Sql Srver 2008, now they want to migrate only the DB Server to SQL 2014, I am looking for detailed explanation so I can give an estimate, but cant find ...
- 5,191
1
vote
1
answer
296
views
Not able to create External Content Type in SharePoint Designer 2013 using Stored Procedure
I want to create the external content type using stored procedure but it is giving me error such that, when I right click on routines in Data Source Explorer and then select New Read Item Operation ...
- 1,027
1
vote
0
answers
76
views
How to create multiple RBS stores for a single content database
I have a sharepoint content database and one RBS store configured with this content db.
and it can be possible to create one another RBS store for the same contet database.
this sharepoint web ...
- 2,905
1
vote
0
answers
34
views
Sharepoint 2013 only to use cubes for dashboards or tables as well?
We have some SSRS reports pulled directly from datamart tables, we are not using SSAS cubes. This is SQL Server 2012.
Now we are implemented a Sharepoint 2013 solution and we will use it for ...
- 11