SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

3
votes
1answer
26 views

call sharepoint 2013 rest webservices from tsql stored procedure?

Can i call rest web service of sharepoint 2013 from tsql stored procedure ? all examples in web are for GET method, But i want create item in sharepoint list and i need to use POST method. this is ...
0
votes
1answer
13 views

What's the meaning of column Level in table AllDocs?

I know it's not the most orthodox way, but I am trying to count files in a huge list with a sql straight into the AllDocs table. I see most files have one row only while others have one row with ...
0
votes
0answers
17 views

while upgrading sharepoint 2007 to 2010 errors

hi my upgrade fail from sharepoint 2007 to 2010 this is the log most of them are sql errors what can i do? [powershell] [SPContentDatabaseSequence] [INFO] [4/19/2016 2:41:58 PM]: ...
0
votes
1answer
7 views

Clear out remnant LDF log files of Sharepoint DB not visible on SBS 2008 Domain Server?

Screenshot of files, location & DBs in Microsoft SQL Server Management Studio Express GUI: I've looked at several answers and tutorials on how to clear out the LDF via GUI and SQL commands, but ...
0
votes
3answers
1k views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
1
vote
2answers
765 views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
0
votes
1answer
1k views

SQL Server 2012 - service account error

I am getting the following 2 errors when trying to install SQL server 2012 on Windows Server 2012. These occur at the server configuration page. Access is denied. The SQL Server service account ...
1
vote
1answer
682 views

How to install SharePoint 2013 Installation with SQL Server Authentication

I'm just curious about the steps required to install Sharepoint 2013 using SQL Server Authentication. Also if there are any drawbacks that i might not be aware of. Here are some steps i currently ...
0
votes
0answers
22 views

Sharepoint designer 2013 WFC Not supporting .NET types

I'm trying to make CRUD operations with external content types with WFC Web services. In the Read item operation i'm returning all basic data from a class named "Curso" (Courses in English). That ...
0
votes
0answers
20 views

External List Without BDS

I am developing a Sharepoint site mostly as a document management solution for reports and invoices generated in the billing department. I have two tables in SQL that I would like to have access to in ...
0
votes
0answers
9 views

PerformancePoint: How to connect to sql/analysis services

I'm attempting to visualize list data as a chart. How would I go about requesting access/connecting to analysis services or an sql server table/cube? Much of my work is with sharePoint, so I'm not ...
0
votes
1answer
34 views

Is there any risks of upgrading our SQL server 2008 R2 from SP2 to SP2

We have the following settings insdie our farm :- SharePoint Enterprise server 2013, on separate windows server 2008 R2 VM. SQL server 2008 R2 with SP2, on separate windows server 2008 R2 VM. now ...
1
vote
2answers
22 views

Configure Reporting Services on SharePoint backend SQL server

So currently I have an Integration mode installation of Reporting Services on my SharePoint backend SQL server, however this cannot be configured because the SharePoint backend SQL server must be ...
-1
votes
1answer
32 views

Unable To Connect To SharePoint DB on Virtual Machine

I am trying to install SharePoint 2013 Foundation on a virtual machine I have (vmware with Windows Server 2012) and connect the SharePoint to SQL Server which installed on a different virtual machine ...
1
vote
4answers
5k views

Office Web Apps can't read/edit Powerpoint or read Word, but Excel reads/edits fine

A brief overview: I have a Sharepoint 2010 installation on Windows Server 2008 R2, with Office Web Apps installed. The Central Admin SQL Database in on the local server, but the SQL database that ...
0
votes
1answer
28 views

cost of switching to MAXDOP=1 in prod [duplicate]

Have a client who's Sql Server instance serving SP2010 databases has MAXDOP=0. What are immediate/postponed cost in terms of resource usage (CPU/mem/IO) when MAXDOP is set to 1? Should then I apply ...
1
vote
2answers
54 views

Fine Tune SharePoint 2013 Page Load

In Development machines,all the page loads within a second whereas in QA and Production environment,each page load(even site content and site settings) takes atleast 7 seconds. Help me with some tips ...
0
votes
0answers
21 views

unable to load client print control error while printing

in our sharepoint 2007 farm . we are facing print issue in SSRS and users are getting errors "unable to load client print control" . with the help of our DBA's we found out that the issue is in the ...
2
votes
2answers
52 views

unable to backup our sharepoint content database “Backup Database is terminating abnormally”

I want to backup our live Content Database, now i went to "Central aministration>>Backup>>perform backup",, but i could it find our content database. so i try running the following command on the ...
0
votes
2answers
137 views

Are there any risks of running (Get-SPContentDatabase <content database name>.Repair($false) on live database

I am working on SharePoint server 2013 enterprise , and i run the Health Analyzer, but i got this error "Content databases contain orphans items" :- Here is the full description of the problem when ...
0
votes
0answers
45 views

Unable to open document from Drop off library in SharePoint 2010

Unable to view documents from drop of library it showing error message When I open pdf documents from a web application, I found below error in uls logs ...
0
votes
1answer
43 views

Mount a content database with site collection already exist in the farm

We are using SP2013 standard on-premise. There are 2 farms Test1 and Test2. Both farm have exactly same named Content DBs and same URL site collections. Recently we encounter some issue about ...
0
votes
1answer
18 views

How can i work out if my SharePoint 2010 has a Report Server set up?

I have been given a SharePoint 2010 environment, and wanting to know if a report server has been set up. Is there anyway I can tell? When I go to Set server defaults in General Application settings ...
3
votes
1answer
129 views

How to check if my SharePoint SQL server is a SharePoint web front end?

How to check if my SharePoint SQL server is a SharePoint web front end?
4
votes
2answers
14k views

database size would exceed your licensed limit of 4096 MB per database

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some ...
0
votes
1answer
154 views

Problem after configuring RBS on SharePoint 2013

I have configured RBS on a SharePoint site on one of our clients and I am getting the following error whenever I upload a file to a document library: The URL '' is invalid. May refer to a ...
0
votes
1answer
30 views

Is SQL Server my bottleneck?

I have a SharePoint 2013 farm that serves as a document repository. We are seeing slowness searching for documents and paging through them as the document libraries grow. Is there any logging within ...
0
votes
0answers
37 views

SharePoint 2013 fail over option

What are the options available for setting SharePoint 2013 fail over plan which have two tier architecture. Following servers in farm: SharePoint 2013 web front end SQL 2012 database Both servers ...
0
votes
0answers
36 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
1
vote
0answers
18 views

Transaction log file for FAST Search

I have a FAST database that has a transaction log file that is growing at an unusually high rate, possibly after applying the FAST SP2 update. It ends up taking up the whole volume within a few days. ...
3
votes
3answers
590 views

Installing RBS for Foundation

I have posted other questions about this but no answers were given so I deleted them and thought I would try one last time before calling it a day... I am trying to install RBS for SharePoint ...
1
vote
0answers
115 views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
2
votes
1answer
1k views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
0
votes
0answers
21 views

Cannot edit members of a provider - ,MOSS Forms Based Authentication

I have a MOSS web app using both Windows and Forms Authentication. I see that there is a Members group that can be edited for the forms users. It's server 2003, IIS 6, so I go to the properties of ...
0
votes
0answers
15 views

Command and Parameter Editor will not retain SQL Text

I have written a query that will provide a count of items by year and it works fine when running in SQL Management studio. I get the results I expect in 2 columns. select a.logged as logged, ...
0
votes
1answer
43 views

Downgrading Sharepoint Database from SQL2008 to SQL2005

Good day, I have a request from a client to move the sharepoint 2007 from a server to another. The actual Sharepoint2007(WSS3.0) content databases are on SQL2008 but the new location only has access ...
11
votes
4answers
260 views

Request timeout error in large list

I have a list containing 500000 data. When i am query on that list like list.getitembyuniqueid(1), its working fine and give result quickly. But when i restart sql server and try to fetch data from ...
0
votes
0answers
1k views

Configuring Windows Server 2008 R2 for SharePoint Server 2013 installation

I've a server running Windows Server 2008 R2 and I want to install SharePoint Server 2013 as evaluation. I don't have any experience with Windows Server roles, features and services. I want to know ...
1
vote
1answer
41 views

Stoping our Test SQL server generate errors on ours production Sharepoint Server

We have a SharePoint 2010 production server (A) linked to a SQL server production server (B). We also have a SharePoint 2010 test server (X) linked to a SQL server Test server (Y). When we stop the ...
0
votes
0answers
93 views

SharePoint SSIS integration using oDATA Connection

I have been trying to integrate SharePoint & SQL/SSIS thru oData connection. I was able to integrate successfully once using above combination without any problems. I was able to extract data ...
1
vote
3answers
15k views

Can I use a SQL Express database for sharepoint 2010?

I'm setting up a dev system with only 2 site collections, is it possible to run an express version of SQL 2008 R2? I'm not too worried about performance, mainly that it will install and run for dev ...
0
votes
0answers
292 views

Call to Excel Services returned an error Sharepoint 2013

We have installed Microsoft SQL server 2014 installed and sql server Analysis server running on Sharepoint mode. Everything was working fine and 10 days we started getting the error Call to Excel ...
0
votes
1answer
87 views

SharePoint 2013 Health Check and Post Install Checks

I have to verify a SharePoint 2013 install for an external company and have never done this before. Looking to compile a detailed check list with things people have commonly came across to cause ...
1
vote
1answer
83 views

Running SharePoint 2010 on SQL Server 2014 with Compatibility Level 110?

Can anyone confirm if it is supported to run SharePoint 2010 on SQL Server 2014 with Compatibility Level 110? Have seen SQL Server 2014 and SharePoint 2010 is not a supported combination, but not ...
4
votes
3answers
15k views

“Invalid License Data. Reinstall is required” error when installing SharePoint 2013 after Sql Server 2012 on the same machine

I've already installed SQL Server 2012 on my machine. Then I tried to run the SharePoint 2013 Foundation installer but I received the following error before I even reached the splash screen menu: ...
1
vote
0answers
28 views

Questions regarding migration of existing content to RBS

How much time does it take to migrate existing data into RBS? I am talking about $rbs.Migrate() command. For e.g. if I want to migrate 1GB of data, surely it will take time. But question is how much? ...
0
votes
0answers
15 views

The database collation is not supported error message when creating new Access web app to Sharepoint Online

I'm currently on a O365 Business Premium trial. I've setup a Sharepoint site, and now I'm trying to create an Access web app. When I create the web app using "Custom web app" tile from Access' main ...
1
vote
2answers
40 views

Get error after content database restore to another server

I have some problem with restore sharepoint content database. get back up content data base from server A. then restore to SQL server server B. create a new web application in server B. add restored ...
2
votes
0answers
28 views

SQL usermapping for Farm-account: dbo vs itself

On my SharePoint farm (in SQL) the farm-account is sometimes mapped as user (itself) to a SharePoint database and sometimes the farm-account is mapped as dbo to a database. On all databases the ...
1
vote
1answer
38 views

Separating OneDrive for Business from the main content database

I would like to separate the OneDrive for Business capability (we're running 2013 on-premises) to another, high capacity server. Reason for this is that we expect tens of terabytes of usage on ...