SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
2answers
2k 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 ...
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
2answers
813 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
2answers
28 views

Development Environment to Emulate Production

I have a current SharePoint 2013 environment development site and I want to emulate our production site as closely as possible. The purpose of this is for testing of course. Recently I had our ...
0
votes
1answer
24 views

Migrate entire SQL Server Database into a SharePoint site?

I'm looking for advice on how to move an entire SQL database - with multiple linked tables into a Sharepoint site, with each table becoming its own list. I don't need them to sync, just to move all ...
1
vote
1answer
788 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
2answers
28 views

backup of sharepoint server 2010 portal

We use sharepoint server 2010 and windows server 2008 R2. Currently, I'm taking backup of sharepoint portal through sql server management studio by backing up the databases (listed for each web ...
0
votes
0answers
24 views

SQL Server Reporting Services in SharePoint 2013

Please any one can help me in the following problem: When i try to working with SQL Server Reporting Service in SharePoint site the following issue faced me: Notes: All configuration steps 100% ...
0
votes
1answer
40 views

AutoSpInstaller: Getting an error/warning installing SharePoint 2016

Iam seting up my development enviroment on Hyper-V virtual machine, and every thing works fine on SQL server. I can ping sql sever by ip and servername. But when i run AutoSPInstaller i get an error: ...
0
votes
1answer
66 views

How to Retrieve SQL column from SharePoint list and update SQL data to SharePoint list?

I have a table in SQL with following columns COLUMN Names : Contract TitleRequestor,Awardamount ,CAN_Type ,Selected_Subcon_Address This is my sample data. ContractTitle ...
0
votes
1answer
783 views

Cannot install SQL Server (2012) PowerPivot for SharePoint, always fails SharePoint Version check

Trying to install a fresh install of SharePoint 2010 (w/ SP1) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint. The prerequisites clearly show that SharePoint 2010 SP1 is needed, ...
0
votes
0answers
14 views

Permissions and Authentication for Business Data Connectivity Services

I have successfully installed BDC into my SharePoint 2010 environment, as well as an External Content Type and associated list. When navigating to the list however, I am receiving the error "Login ...
0
votes
0answers
14 views

Please suggest can we download Project Online Database with SSIS Using Azure site?

There is the capability to user SSIS to download copy of Project online Odata tables to On premise or Azure. Please suggest can download Project Online Database with SSIS Using Azure site. Preference ...
1
vote
2answers
6k views

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

I am using Sp2013 Standard server, with 1 APP, 1 WFE, 1 Workflow and 1 Clustered SQL. Everything was all great until Monday Morning (7-28-14). Thats when Event Log started to fire off following ...
0
votes
1answer
171 views

Site creation error

While create a new subsite within a site collection (from the browser), I get this error: The url 'Pages/default.aspx' is invalid. it may refer to a nonexistent file or folder or refer to a valid ...
1
vote
2answers
1k views

Project Web App is stuck on: Waiting for resources

While trying to unprovision a PWA in order to move the DB to a new SQL Server. I followed the following article: http://technet.microsoft.com/en-us/library/ff961887(v=office.14).aspx After the "...
0
votes
1answer
38 views

Shared server farm: Possible to connect SharePoint 2010 local farm to Amazon EC2 SQL Server?

We are running SharePoint 2010 server farm locally. Now it is our requirement to move SQL Server 2012 on Amazon EC2. Requirement: We want to connect SharePoint 2010 server on-premise with Amazon EC2 ...
2
votes
0answers
30 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
1
vote
0answers
42 views

Error while Creating New Web Application

Environment : SharePoint 2010. Description: I am trying to create new web-application through Central Admin. Once I click on 'New' I am getting below error. Steps Performed till now: Verified ...
1
vote
1answer
45 views

Connecting to local database via SharePoint Designer

Following this article I am trying to connect to a local SQL database using SharePoint Designer. I am able to create external content type, use it in external list, and the list is correctly populated ...
1
vote
0answers
22 views

Exception: Microsoft.Data.SqlRemoteBlobs.BlobStore Exception

In SharePoint 2010 I get this error from RBS. This error is shown in event viewer. I could not find any questions around about this error. This error is shown very ofthen. Too often I would say. ...
0
votes
0answers
22 views

Load SQL and SharePoint in PowerShell script

I need to create one PowerShell in which i am using SQL and SharePoint both. In my development environment it works fine because there is single server for Content DB server and WFE server. But in ...
0
votes
1answer
35 views

Change IP of DB server SP 2013 Foundation

I have SharePoint Foundation 2013 with the WFE on one server and the db on another. I need to change the SQL server IP address. What's the process of doing this correctly?
3
votes
1answer
59 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
2answers
120 views

How can I show SQL data in a SharePoint Server 2013 list?

I have one table in SQL database. ID Name Address 1 pavi chennai 2 priya Bangalore In SharePoint, I want to show above SQL table in a task list programmatically via C#. How can I achieve ...
0
votes
1answer
16 views

Migrading from SQL 2008 R2 to SQL 2014 (between servers)

To move SharePoint SQL database from a SQL 2008 R2 server to a SQL 2014 server. Do I have to do an in-place SQL upgrade on SQL 2008 to SQL 2014, then move the database onto the new server? Thank you!...
0
votes
1answer
32 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
27 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
16 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
0answers
28 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
25 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
12 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
40 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
25 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
40 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
57 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
29 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
68 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
247 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
67 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 System.Runtime.InteropServices....
0
votes
1answer
76 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
28 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
143 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
15k 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
210 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
33 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
38 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
42 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 ...