SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

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 ...
0
votes
0answers
42 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
324 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
82 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
73 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
28 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
256 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
81 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
36 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
240 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
40 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
114 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
250 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
22 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
47 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
66 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
262 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
290 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
75 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
115 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
63 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
128 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
38 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
46 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
106 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
68 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
40 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
16 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 ...
1
vote
2answers
433 views

upgrading SharePoint 2010/2013 Databases from SQL Server 2008 R2 SP2 -> SP3

How can i confirm that upgrading SQL Server 2008 R2 SP2 to SP3 is safe to roll out.(Compatible?) Any resources or tips would be appreciated Thanks in Advance
0
votes
2answers
103 views

Programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists

I need to programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists. By programatically I mean using a power shell, SQL query or even a webpart Libraries can be Asset ...
0
votes
2answers
97 views

Clone SharePoint VM containing SQL DB on different Box

I have a SharePoint 2010 Setup in a VM. And Content DB of central admin of this server, say "Server A" resides on "DB Server 1". Now i clone the VM and create another copy say "Server B". I changed ...
0
votes
0answers
27 views

Grab image type from SQL and display in SharePoint

I have SharePoint Foundation 2013. I have employee information (name, titles, dates, photo [image type]) in a SQL database. I want to be able to grab this employee data from the SQL table and ...
0
votes
0answers
34 views

How to access ProjectWebApp site without define directory in Url

I am working on SSL configuration on PWA(ProjectWebApp)site with SQL Server 2008 and SharePoint 2013.Whenever someone wants to access it, need to put /PWA (http://servername/pwa ) explicitly in URL. ...
0
votes
2answers
322 views

Resolving permission error in sql for username domain\computerName$

I'm trying to resolve a permission error on our sharepoint sql server. The login for the user that has failed is the WFE computer name on the farm config db. What permission or role can I grant that ...
0
votes
1answer
205 views

Export(or map) List data to external MSSQL table

There are many references about External Lists, where you make a Sharepoint list from SQL database table. In my case, I need to do the opposite - I have SharePoint list, and I want to map it to an ...
0
votes
0answers
45 views

Token-based server access validation failed with an infrastructure error

I am having the following error notification from the database server DESCRIPTION:Login failed for user 'Domain\XYZ_Admin'. Reason: Token-based server access validation failed with an ...
2
votes
5answers
434 views

Creating SQL Alias after configuring SharePoint 2013 farm

I am trying to configure sql alias in SharePoint farm. I have followed various articles about configuring it through cliconfg.exe and it looks fine. I have rebooted server and all the services. When ...
0
votes
1answer
111 views

Using SharePoint WSS_Content database to find permissions changes?

I've noticed there are a few tables that may be able to help me put together an "Audit Log" of sorts for permissions changes in our SharePoint site. However, I'm unsure of how to join up the tables ...
1
vote
1answer
3k views

What versions of SQL Server does Sharepoint 2010 and 2007 support?

We have two SharePoint environments - 2010 and 2007. We are looking to upgrade our SQL Cluster to SQL Server 2014 and are looking to see if 2010 and 2007 support it. I could not find any ...
0
votes
1answer
340 views

Changing sql server service and sql server agent service startup account in SQL Server hosting SharePoint DB

i have a sharepoint deployment with one SQL Server (running on VM) hosting the config DB and another SQL Server (Physical Host because VM was running out of space) to host the huge Content DBs. I need ...
0
votes
1answer
68 views

Can we save few of list items in a separate database?

I have a different requirement that For suppose myCustomList having 40 columns and every 10 columns are similar kind of data. So, I want to save those each group of 10 columns into a specific table[my ...
1
vote
0answers
39 views

SharePoint 2007 crawler is not stopping

I recently tried to start a full crawl after my colleague mentioned that some of the files are not visible in the search. Normally the crawler start full crawl every week. so i manually tried to ...
0
votes
1answer
135 views

Calling infoPath form code from a Web Service to populate a drop down list

Using a web service solution to retrieve SQL data I'm wanting to return the list of values that I've collected and call the InfoPath form code to populate the drop down options. How do I call the form ...
0
votes
3answers
2k views

Is it possible to have 2 Sharepoint 2013 Farms using the same SQL Server instance?

Can 2 SharePoint Farms use the same database instance? I know SharePoint can use DBs that have non-standard names (as in the case of databases that have been pre-staged). I'm not asking if they can ...
0
votes
1answer
28 views

Sharepoint 2013 Online SQL Server Connect

We have a sharepoint 2013 online tenant. We have some sql server databases that are on premise. For this query we want to connect sharepoint 2013 online to those databases and read information from ...
0
votes
2answers
125 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
0
votes
0answers
33 views

Constant SharePoint 2010 read/writes to TEMPDB

We have a SharePoint 2010 farm consisting of 4 servers (1 WS, 2 Apps, 1 DB). Things appear to run smoothly except that we are noticing a surprisingly high number of IOPS hitting TEMPDB. We are talking ...
1
vote
1answer
241 views

Can setting MAXDOP to 1 decrease performance?

I was looking at my client's UAT farm and found out that MAXDOP was set to 0 on SQL Server instance hosting SP databases. Before setting this value to 1, I measured response times of most commonly ...
0
votes
1answer
46 views

External Data Editing and Modification

Can data in a SQL database be modified (new, delete, edit) through a SharePoint out-of-the-box feature or custom built feature?