SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
23 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
22 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
13 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 ...
2
votes
1answer
103 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
21 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
34 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
32 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
46 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
12 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
24 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
204 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
35 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
44 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
98 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
31 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
24 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
10 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
0answers
13 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
28 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
29 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
15 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
111 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
25 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
29 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
24 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
37 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
24 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
23 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 ...
1
vote
1answer
91 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
0
votes
0answers
20 views

Why Sharepoint Admin account cannot be a member of dbcreator and security admin in SQL server?

Once I am defining a server roles for SP_Admin account in sql server as a dbcreator and security admin, then I receive an error which says: Add member failed for server role... Can you please a ...
0
votes
1answer
19 views

User Profile Sync Creation + FIM error 22

We encountered problems with the User Profile Synchronization in SharePoint 2013. In the end we decided to re-create it, so we deleted the User Profile Service and kept the databases, however now ...
0
votes
0answers
54 views

Where to install SSRS SharePoint mode in a multi-server environment?

Hi I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server ...
0
votes
0answers
81 views

SQL Server reporting services report viewer parameters not visible after applying filters(Query string URL filter)

I am currently working on SharePoint 2013 and SSRS 2012. I have added a SQL Server Reporting Services Report Viewer web part on a page with few parameters. Next, I've configured QSUF (Query string URL ...
1
vote
2answers
242 views

User Profile Synchronization service is not starting

Following error occurs: UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ...
0
votes
0answers
9 views

data filter ssrs 2010 dosent work

My sharepoint list has 7000 items, I made report from this list 10 month ago, report made by data tools 2010. I have date filter in my report, table of report filter by parameter as date type. I ...
0
votes
2answers
85 views

Sharepoint BLOB Storage RBS filestream to a Fileserver?

I am currently trying to enable Remote blob storage in the SharePoint 2010 environment running on windows server 2008 and the SQL server is 2008 R2 enterprise edition in a separate box. In addition to ...
0
votes
0answers
9 views

Unable to start SQL Server service [duplicate]

Recently I changed my account's domain and password. Now, when I try to start the SQL Server service and I get the error whose code is 17058. The system cannot find the path specified. How can I ...
0
votes
0answers
62 views

Unable to start SQL Server (SHAREPOINT) service

Some days ago I had installed AD and DNS in one of my servers. These services was migrated and I then uninstalled them from the server. That server have the Sharepoint and SQL Server services. Just ...
1
vote
0answers
18 views

SQL Error 18456 state 8 on SharePoint Excel Services

I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint. I created new account with which I can easily login to SQL Server Management Studio: the username and password ...
0
votes
1answer
21 views

PowerPivot database not deleted from tabular database

I am testing SharePoint 2013 / SQL Server 2014 combination. I upload a PowerPivot Excel to PowerPivot gallery and do some testing. I notice that when I delete the PowerPivot from the PowerPivot ...
2
votes
0answers
73 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no ...
0
votes
1answer
39 views

External Content Type - Cannot connect to SQL server with user's identity

I'm trying to get some data from external content type from SQL server by using my windows identity, but when I add a new connection in SPD, and choose user's identity to connect, a error message pop ...
0
votes
1answer
40 views

How to recover corrupted web parts?

I have two SharePoint websites A web part is working on one site but corrupted in second site and it is stored in the database. When I recover database from first site database then the web part is ...
0
votes
0answers
23 views

How can I use SQL data in SharePoint form

I have a SharePoint form with some fields and would like to populate it with some data from a SQL Server table. I wanted to have a search button besides the title field for example and when that is ...
0
votes
1answer
99 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
0answers
41 views

How to move data files from local C drive to Content Database in SQL Server

I am having some html files in local C drive in the laptop.. the dynamic data in those files should be moved to SQL database.. the data is further used through sharepoint after its saved on sql. ...
0
votes
2answers
513 views

InfoPath does not support customizing the form used for this list.

How to enable this feature? "InfoPath does not support customizing the form used for this list." I want to edit the form in infopath and publish it back to SharePoint.
2
votes
1answer
56 views

How to map a variable taken in query to a gridview column in asp.net?

I have written a query in SQL server 2008 R2 and it is: select *, Row_Number() Over(Order By Total_Marks DESC) as Rank from tbl_Ranking_System order by Rank In this query, I have taken variable ...