SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
17 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
33 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 farm-...
1
vote
1answer
43 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
44 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
63 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
139 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
30 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
47 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
36 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
132 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
29 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
28 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
239 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
23 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
22 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
89 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
125 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
487 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
10 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
177 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
111 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
23 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
39 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
78 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
70 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
47 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
208 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
2answers
1k 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
102 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 ...
0
votes
0answers
488 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
154 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
170 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
2answers
134 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 ...
-1
votes
1answer
939 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
43 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
232 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
345 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
25 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
63 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
81 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
369 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
528 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 ...
1
vote
1answer
94 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 ...
1
vote
1answer
344 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
80 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
163 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
49 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
55 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
277 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