SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
4 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
12 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
13 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
0answers
11 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
14 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
15 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
63 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
4 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
26 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
22 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
14 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
12 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
65 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
24 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
31 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
1answer
18 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
0answers
28 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
23 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
1answer
71 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.
1
vote
1answer
31 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 ...
1
vote
0answers
23 views

How to give full permissions (such as permission to give other employers) to site manager in sharepoint 2013?

For example, the HR head department DOES NOT wants to give permission to a ECT (external content type) table view. However, the HR head just wants to give permission to submit data from a form ...
0
votes
0answers
23 views

Custom WCF Service in SharePoint That Queries SQL Server

I'm able to create a WCF service and deploy it SharePoint. When I try to add functionality to interact with a SQL Server database, the service stops working. For testing, I've tried creating an ...
0
votes
0answers
85 views

SPDataAccess Role is not visible - Sharepoint 2013

I have a Sharepoint 2013 farm and SPDataAccess Role is available for some content DBs and not for others. Is there a way to add this role to a specific DB using PowerShell?
0
votes
1answer
28 views

Show Custom field in SharePoint form based from a table in sql server

I hope I can get some tips here. I have some fields in a SharePoint form that I would like to pre populate from a table in SQL server tables. So for example if I select a value in a dropdown field ...
0
votes
1answer
37 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 ...
0
votes
0answers
23 views

WSS 3.0 single server system with external SQL Server

I have installed WSS 3.0 with SP2 on Windows Server 2008 R2 SP1 (not domain joined) as a single system (Basic or Advanced -> Complete in the installation wizard selected). Everything works fine. I can ...
0
votes
0answers
94 views

Read operation on a large object failed while sending data to the client

We recently upgraded our DB's for SharePoint 2013 by following these directions: http://blog.entos.at/Lists/Posts/Post.aspx?ID=14 Now we're receiving this error multiple times in Event Viewer ...
0
votes
2answers
44 views

how to connect infoPath form with SQL server in SharePoint 2013?

i have an BCS/external content type in SPD connected to my InfoPath form. I want to insert the data to the SQL table. Therefore, I just the following rules: R1) Query using a data connection: Main ...
0
votes
0answers
33 views

I can open Sharepoint Central Administration Page, but most clicks are inop?

I just installed Sharepoint 2013 server on top of WIN2012r2/SQL2014 and all seemed to go well until I tried to click on anything behind the home page Sharepoint Central Administration: I can get ...
-1
votes
1answer
39 views

how to enter data into SQL server table via a Form in SharePoint?

im using SharePoint Designer 2013. need some ideas or source code to help me.
0
votes
2answers
29 views

Scrip sample file? to connect sharepoint 2013 and sql server in a form

I want to create a template in sharepoint 2013 and connected to an SQL server table, so it will populate with the info entered in a form.
1
vote
0answers
42 views

Farm configuration failed during step 3 = sqlexception error + infinite “not running in high constrat …” messages

I try to install a farm with the following requirments : windows server 2012 r2 + sql server 2012 sp2 windows server 2012 r2 + sharepoint 2013 SQL Server was correctly configured (alias, ...
0
votes
1answer
85 views

InfoPath form has connection to SQL server, but form data is not being submitted and stored in db table?

I am created one submit rule which it has the action 1) query using a data connection: Main connection 2) set a field's value @fullname = 1. I need help creating a second rule inserting all the field ...
2
votes
2answers
21 views

Sharepoint databases status in SQL Server

We have a SharePoint oriented environment where all the content and config databases are hosted on SQL Server. My question is there some way from SQL Server end to find out if the content databases ...
2
votes
1answer
37 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
5
votes
1answer
61 views

Is it a good practice to have 2 SQL Severs for a SharePoint site?

Is it a good practice to have 2 SQL Severs for a SharePoint site? If yes, can you recommend me link(s) for how to add it?
0
votes
1answer
149 views

A network-related or instance-specific error occurred while establishing a connection to SQL Server. when use sqlalias and try to connect sql server [closed]

i have an asp.net web application that connected to sql server 2012 from a server ( windows server 2012 R2) its a fresh installed server and installed oracle 32 bit client . its SharePoint wfe server. ...
0
votes
1answer
71 views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
0
votes
0answers
43 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 2014 is not a supported combination, but not ...
1
vote
1answer
23 views

How to rollback RBS and what happens to existing data

Let's say I am using Remote Blog Storage (RBS) in one of my content database and decide not to use anymore. How can I roll back RBS? What will happen to my data and how can I migrate it out of RBS? ...
0
votes
1answer
38 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
1
vote
0answers
72 views

“Missing documents” in RBS after restoring database

I'm assisting a client with a SharePoint migration, but have run into a situation with some of the document libraries. The SharePoint server was configured to use RBS via the native FileStream ...
1
vote
2answers
33 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
0
votes
1answer
36 views

Creating a list-backed SQL Server database without using External Content Types

I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only ...
1
vote
2answers
36 views

Multiple SQL databases in a farm

Is it recommended to have multiple SQL servers in a farm to host content databases or usually just one? sorry if this is a basic question but i am new to the SP architecture
0
votes
1answer
35 views

SQL server WSS_Logging fragmentation

We are running SP2013 on SQL Server 2014 (setup with a Available Group) and we use a tool called SQL spotlight to monitor the health of our SQL servers. It constantly complains that many of the ...
0
votes
0answers
14 views

SQL environments to a centralised environment

We are looking at moving our SQL environments to a centralized environment, with a single SQL installed and many DB instances on. Are there any problems that might arise? We currently have a separate ...
0
votes
1answer
37 views

Mount ContentDB

I am mounting a contentDB to a 2013 web application (upgrading from 2010). The contentDB size is around 2,5GB , the mounting process is stucked. I checked in the log and it is stucked here: ...
0
votes
0answers
13 views

SQL server 2012 SharePoint 2010

Can we use same SQL server for two farms of SharePoint 2010? Can I use different SQL instances on same SQL server for two different SharePoint farms? If I want to move from SQL 2008 R2 to SQL 2012 ...