SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

learn more… | top users | synonyms

2
votes
1answer
83 views

“Sorry this site hasn't been shared with you” for root URL only after migrating to new SQL server

All I found a couple other posts related to my issue but they did not lead to any solutions and my backstory is a bit different. Backstory: We have a 2013 farm that we use for test/development. The ...
2
votes
1answer
2k views

SP2013 Failed to create the configuration database

When installing SP2013 I got this error: Failed to create the configuration database An exception of type Microsoft.Sharepoint.SPException was thrown. Additional exception information: The ...
1
vote
1answer
26 views

Simple Question - Is it possible to Edit SQL Tables from SharePoint form

The title about says it all. I've developed in Access for 20+ years. I've held off learning SharePoint because everything I've read seems to indicate restrictions on true data management. So... here ...
1
vote
1answer
27 views

Workflow farm infrastructure

We are planning on building a Workflow farm to use with an existing SharePoint 2013 farm. We have 7 servers in total split between 2 physical locations: Location 1: Server 1, Server 2, Server 3, ...
1
vote
1answer
75 views

how to import data from sql database to a sharepoint list

i would need to import 2 columns of data from a SQL database into a SharePoint list? is there a way to easily import data from a sql database to a SharePoint list?
1
vote
1answer
28 views

Is there a good way to connect to a SQL Server using Windows authentication from a Sharepoint 2010 event hander?

Inherited some legacy code that makes use of SQL authentication which I want to eliminate. When I tried using Windows auth, the connection seemed to be getting created using ANONYMOUS LOGIN. is there ...
0
votes
1answer
17 views

Datasheet view export

I am using a datasheet view in sharepoint to manage an excel like sheet that multiple users can modify there data in. right now i export the list manually and upload it to the service provider. I am ...
0
votes
1answer
91 views

SQL Server Reporting Services Service Application Encryption Error

I'm trying to create a new SQL Server Reporting Services Service Application, I go in and set all my settings and the application creates just fine. But when I click on the service application i ...
0
votes
1answer
109 views

insert value from sharepoint list to SQL table

I have list with approx 20000 items, and want to push that into sql table. Can anyone help me with c# code. Thanks
0
votes
1answer
15 views

Foundation, Designer and SQL Database in a Virtual Enviornment

Are there any good tutorials that show you how to set up a web server, SharePoint 2010 Foundation & Designer as well as a database in a virtual environment (i.e VirualBox). I would like to learn ...
0
votes
1answer
47 views

Unable to connect to SQL on aspnet_regsql.exe

I have a standalone environment, and I am trying to configure FBA on my local machine, I ran aspnet_regsql.exe, and it said it's unable to connect to SQL. The account am using is the sp_admin ...
3
votes
0answers
65 views

Create a SharePoint Farm using SQL Azure

I have an on-premise installation of SharePoint 2013. I need to create a new farm (Using either SharePoint Configuration Wizard or Powershell) in SQL Azure. Using Configuration Wizard, it keeps ...
3
votes
0answers
6k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
2
votes
0answers
136 views

Sharepoint 2013 with SQL Authentication

I'm trying to get Sharepoint 2013 to install correctly with SQL Authentication. The domain environment I am running this under, service accounts are not easy to come by and have to be renewed every ...
2
votes
0answers
302 views

How to include custom managed metadata in FullTextSQLQuery searches?

I am using SP2010 and spservices jquery library to make sql search queries to the search service. I created a managed metadata called DocumentGUID which is mapped to the document guid crawled ...
2
votes
0answers
262 views

Business Data Connector List Column not working BDC XML Definition

I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it look fine except for limited number of Rows. However, if I ...
1
vote
0answers
45 views

How to resolve SharePoint 2010 Error Event 5586 - Some part of your SQL statement is nested too deeply.

The SharePoint 2010 server is returning some error message on Windows Event Viewer and SharePoint logs. Windows Event Viewer is returning the following error message: Event 5586, SharePoint ...
1
vote
0answers
27 views

Who is updating my database?

I have a custom solution (FARM level) which is deploying webpart to my site collection. This webpart has a textbox, which is writing to custom database (Nothing to do with content DB) Now, while ...
1
vote
0answers
101 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
1
vote
0answers
52 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
1
vote
0answers
83 views

Mounting content database from 2010 to 2013 murders Views and Indexes in the Database

Well this is fun. I have content database from a SharePoint 2010 and I´m trying to mount it on my SharePoint 2013 SP1 farm. At around 26% I get a the error Mount-SPContentDatabase : Operation ...
1
vote
0answers
336 views

InfoPath 2013 form causes “Server out of memory” error when viewing list item

I have a rather large (200+ field) InfoPath form on a custom list that is full of drop-downs referencing other lists on the same site, along with some textboxes and checkboxes. There's not much in the ...
1
vote
0answers
101 views

Migrate documents from SQL Server to SharePoint document library with the meta data?

I'm new in SharePoint and I have a requirement to migrate millions of documents stored as BLOB's in SQL Server to a new SharePoint Document library. Can you suggest the best approaches for the same?
1
vote
0answers
24 views

Re-using SQL instance for multiple farms

During a transition phase of indeterminate length, I will be hosting the databases for a SP2012 farm and an unrelated SP2013 farm on the same physical hardware. I know that the guidance for mixing SP ...
1
vote
0answers
77 views

Display and update data column of type time in sharepoint

I have an sql server data table with a column of type time(0). I need to display columns of this table on a sharepoint page, including the time-column. Users must be able to read and update rows. What ...
0
votes
0answers
14 views

Importing multiple lists with lookups

I have a legacy database that was originally written in SQL Server 7 and then upgraded to SQL 2000. My client would like to now use Sharepoint Online to manage this database. There are 25 tables and ...
0
votes
0answers
37 views

In SharePoint lists - how add a field that gets data from a database connection?

Background: We have SharePoint lists that contain user requests for compilation of software, various regression testing, and other tasks. They automatically cause start of these tasks. I need to add ...
0
votes
0answers
26 views

Expose list or document through ODBC connection

I've seen a few things on Data Connection Libraries and BCS on how to bring content from external databases into SharePoint, but what I am looking for is the other way around. We have a SAP server ...
0
votes
0answers
29 views

SharePoint 2010 not Accessible

My complete SharePoint 2010 site is not accessible. However, the admin site is. The database is still OK. Error: Cannot open database "WSS_Site_Content" requested by the login. The login failed. ...
0
votes
0answers
9 views

One SQL PowerPivot instance for SharePoint for two separate SharePoint Farms?

Can I use one SQL PowerPivot instance for SharePoint for two separate SharePoint Farms? I use SharePoint 2013 SP1 and SQL 2012.
0
votes
0answers
90 views

Event ID 5586, error seems related to search

The following error is being thrown every few minutes 24/7: Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below. Procedure or function ...
0
votes
0answers
28 views

Configuring Sharepoint Server 2013 connect to SQL server using child Active Directory domain user

I'm having a problem with the initial configuration of SharePoint. I'm unable to connect to my SQL user account which is integrated in a child Active Directory domain, like this format: ...
0
votes
0answers
99 views

Multiple Inner Joins CAML query

I'm trying to convert the following SQL statement to a CAML query: SELECT t.Id, t.Name, t.CustomerId FROM Ticket AS t INNER JOIN Customer AS ...
0
votes
0answers
66 views

XML column on Sharepoint 2013 list - import to SQL table

I tried to import data from Sharepoint 2013 list to MSSQL. I prepered Query, but if I use Remote Server by Linked Server. But if I use this with Sharepoint 2013 list it giving me Error that can't ...
0
votes
0answers
47 views

How to import Sharepoint 2013 list to SQL table

How to import Values from Sharepoint 2013 list to SQL table in MSSQL server ? Please tell in different ways to achieve this. In 2010 I was doing by read WSS_Content tables, but in Sharepoint 2013 ...
0
votes
0answers
60 views

XML DataType in Sharepoint 2013 - problem with remote server

If I make Query in MSSQL, and asking the data from sharepoint list I geting this error. I geting this only if i connecting with Remote Server: Msg 9514, Level 16, State 1, Line 28 Xml data type is ...
0
votes
0answers
49 views

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

I have got SQL Query: And I getting this error: Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or ...
0
votes
0answers
87 views

In Sharepoint 2013 AllUserData has been change

Now is written as XML file. Like they told in this article: http://joelblogs.co.uk/2013/02/15/sharepoint-2013-content-databases-and-the-alluserdata-table/ How to use them in SQL ? This field and find ...
0
votes
0answers
32 views

SharePoint Workflow manager SQL Alias

I recently performed a separation of machines (from standalone to small farm). We choose the SQL Alias approach in order to keep everything as it is (I moved SQL Server to a new machine and add an ...
0
votes
0answers
20 views

User can't refresh data in Sharepoint List after SQL View Def changed

I am trying to support a user who uses a SharePoint 'report' (ie Excel SS). The report is based on an SQL Server 2008 View. The view definition was altered to source data from different tables within ...
0
votes
0answers
23 views

SharePoint External Content Type error: An entry has been added to the Windows event log of the server.

I have an External Content Type list connecting an SQL server in SharePoint 2013, and the data is not submitting/saving in the front-end of SharePoint using InfoPath. The error message is the ...
0
votes
0answers
22 views

Stored procedure to retrieve Name given Login Name

I have a hybrid database and SharePoint setup. I store some data inside my custom tables on the database. One of the tables requires a report to be generated based on a stored procedure. I do not ...
0
votes
0answers
31 views

Dashboard in sharepoint online - from list /sql azure datasource

Just wondering if anyone has done this and how did they go? What will be the best way to present a dashboard/charts in sharepoint online from data coming from a list or sql azure? Thanks for any info ...
0
votes
0answers
22 views

RBS Configuration on another content database Fail

I faced a problem while configuring RBS on another content database after installing it on a content database. The problem is that inside the log file I found the expression "Configuration completed ...
0
votes
0answers
47 views

Access full URL (including domain) from SQL

I'm aware MS recommends PowerShell etc but I'm using TSQL (nolock). Everywhere I'm looking in the database I'm seeing "sites/something" rather than "http://domain-one.com/sites/something". The only ...
0
votes
0answers
82 views

SharePoint Transaction Log Size in High Availability Group

I know SharePoint Config transaction logs tends to grow quickly when in Full Recovery mode, we have been cleaning it out by swapping the database recovery to simple mode, running a backup, the ...
0
votes
0answers
49 views

What do I have to consider when modifying 'wss_minimaltrust.config'?

I have an issue which makes me go mad for quite a while. It probably has to do with permissions and CAS. In the referenced question I explained that I tried out a number of approaches, running against ...
0
votes
0answers
29 views

Sharepoint 2010 enterprise search sql syntax

sorry for the bad English. So i'm using SharePoint 2010 server Enterprise Search and I'm building a custom search webpart and result page. Using the SQL syntax: Select (whatever i need) from scope() ...
0
votes
0answers
208 views

SharePoint Foundation, SQL Server Express & Forms Based Authentication

Are there any limitations to use SharePoint Foundation with a SQL Server Express and using Forms Based Authentication to log in?
0
votes
0answers
900 views

Moved SQL databases for SharePoint 2010 and now have a 3351 error

I moved the SQL databases from a local instance to a remote SQL server. All permissions are the same. Everything seems to work but now I'm getting a 3351 SQL error every 30 minutes from the local ...