SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
11 views

How 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
0answers
21 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
21 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?
0
votes
2answers
61 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
15 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 ...
3
votes
1answer
45 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
20 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
20 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
9 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
23 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
21 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
10 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
36 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
24 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
33 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 ...
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
56 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
25 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
57 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
165 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
50 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
49 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
22 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
133 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?
0
votes
1answer
31 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 ...
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. ...
0
votes
0answers
39 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
169 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. ...
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
17 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
46 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 ...
7
votes
4answers
272 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 ...
1
vote
1answer
42 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
102 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 ...
0
votes
0answers
334 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
122 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
0answers
30 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 ...
2
votes
0answers
29 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
40 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 ...
0
votes
0answers
39 views

SharePoint Using all available SQL memory

Background We have two environments for SharePoint: Test 1 WFE, 1 APP server, 1 OWAP server and 1 SQL Server with 32 GB RAM All servers are Windows Server 2012 Tier 3 SAN disk (slower) ...
0
votes
0answers
45 views

Database locks on content database. How to identify what is generating the statement SharePoint side?

We're currently experiencing database locks on our one of our site collection's content database. These locks are generated by the SharePoint web server, and shows up in the Activity Monitor in MS SQL ...
0
votes
0answers
128 views

can't open office docs in sharepoint

I am running SharePoint foundation 2010 with office 2010. At some point yesterday sharepoint stopped allowing users to open any office document, word excel whatever. Here is what is going on. Click ...
1
vote
0answers
29 views

Save infopath web form library published on Sharepoint to SQL database

I am very new to sharepoint. I have created an Infopath 2010 form template, which is hosted in Sharepoint 2010 library. I want to store the form data to SQL Database, so that I can create reports and ...
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 ...
0
votes
0answers
34 views

SSRS208 with sharepoint 2010 Intrigrated mode- ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created

I am trying to run SQL server 2008 SSRS with sharepoint Intrigrated mode and end up with ERROR: Appdomain:4 WindowsService_2 failed to initialize. Error: The endpoint cannot be created. Production ...
0
votes
1answer
90 views

Prevent “Save to SharePoint Site” alert in Access 2010

We are storing an Access 2010 file in a SharePoint 2010 library and the yellow alert bar that says "Save to SharePoint Site" is showing up whenever users open the Access file. If the user closes the ...
1
vote
1answer
27 views

Term set not showing in SQL Server

I administrate a SharePoint 2013 site on which a bunch of managed metadata term sets are used (picture): The last term set "Subject Area" is not looking like the rest of them, and has no ...
0
votes
0answers
25 views

Error when trying to create SQL Server PowerPivot Service Application

We recently migrated our 2010 environment to 2013. Everything is working except for Power Pivot. We're attempting to create a SQL Server PowerPivot Service Application and we're getting the ...