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

1
vote
0answers
41 views

Internal site works External site gets “Server Error in '/' Application.”

Our sharepoint works great on our internal network. We use Sharepoint 2013 and SQLEXPRESS 2012. We have a domain intranet.crkoes.org that we have setup but get this error. Server Error in '/' ...
0
votes
0answers
11 views

encrypting connection strings in a web.config

I am creating a web part which needs to access a stored procedure from the database.And i have given the connection string in the web.config of the sharepoint site. But my client also wants the ...
1
vote
1answer
5k views

Updating a SharePoint list via an Access query and VBA code exhausts system resources

My apologies: I asked this on StackOverflow already but have received no responses. I am hoping that reposting on a site more oriented to SharePoint might lead to more insight. For reasons beyond my ...
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 ...
0
votes
1answer
28 views

SSRS bar-chart do not show the x-axis name when value is zero

We have a Dashboard implemented by SSRS in SharePoint 2010 and data source is a SharePoint list. We have a bar table in which the x-axis is month but when data is zero it doesn't show the month name ...
0
votes
2answers
26 views

Migrating content databases

I've just moved one of our SharePoint 2013 environments over to a new SQL server and I tested one of the content databases was able to connect and this was fine but I cannot figure out how to update ...
0
votes
0answers
15 views

Website form import into Sharepoint Infopath Form

We are trying to set up a form on our external website so users can submit request to different departments. We need to get this information into our internal SharePoint site somehow and wanted to ...
0
votes
2answers
24 views

Database Backup\Restore Not working properly

In my present SharePoint farm what we do is create a web app and restore a previously saved backup of a site to the new one, this is usually done using the PowerShell site collection back\restore ...
0
votes
1answer
18 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 ...
1
vote
1answer
12 views

SQL DNS entry for SharePoint farm configuration

To prevent from issues when/if the SQL server fails is it a good idea to create a DNS entry to point to the SQL server instead of using the actual server name when configuring SharePoint 2013? In ...
0
votes
1answer
16 views

Reinstall SQL server in windows server 2012?

I have SharePoint server. I did mistake to uninstall SQL server so now SharePoint site is also not opening. so please some one help me how can I reinstall SQL so my existing SharePoint site works ...
0
votes
1answer
34 views

Performance Issue - Using Access to Update Field in SharePoint

I would like to use MS Access to update one field on a SharePoint list. I run into serious performance issues with MSAccess locking up for +15 minutes. Are there steps I can take to optimize the query ...
0
votes
0answers
15 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 ...
1
vote
0answers
56 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 ...
0
votes
2answers
104 views

Is it possible to access a MYSQL database table from a sharepoint hosted app?

I'm alittle confused, when I google this all i seem to find is how to connect to sharepoint using a cloud hosted app hosted in windows azure, that's not what I'm looking for. I've been creating Java ...
0
votes
1answer
27 views

What's the meaning of column Level in table AllDocs?

I know it's not the most orthodox way, but I am trying to count files in a huge list with a sql straight into the AllDocs table. I see most files have one row only while others have one row with ...
2
votes
1answer
23 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
1
vote
1answer
53 views

Where do I get started on building an HTML5 form in SharePoint?

Working on a project to build an HTML5 form within SharePoint that will read and write to a SQL database. Can't find much online about how to get this implemented. I am very well versed in HTML and ...
1
vote
1answer
29 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
2answers
654 views

SP 2013 How to create new FBA sql users with PowerShell?

I set up SharePoint 2013 with FBA users (SQL). I'd like to know if it's possible to create new users using PowerShell script ? What I tried but did not work : [System.AppDomain]::CurrentDomain....
1
vote
1answer
31 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, ...
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 ...
2
votes
1answer
24 views

SiteCollection not available after the DB was moved into a different volume/drive by DB Admin

I ran the below command to create a NewSiteCollection and new DB for Legal Team Add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue; New-SPContentDatabase "...
0
votes
0answers
38 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 ...
1
vote
2answers
66 views

if i want to free some space on my Dev machine can i shrink the WSS Logging database

I am working on my Dev machine, and i am running out of space, now i check the WSS Logging database and i find that it have 34% of its size as a free space :- so are there any harm if i shrink it ? ...
1
vote
2answers
46 views

Conflict Content Databases names inside my sharepoint farm

I am using SharePoint server 2013, and i am facing problems on understanding how to manage my SharePoint content databases:- currently i have a single content database, with name = ...
2
votes
2answers
57 views

Add entries to AllUserData from SQL

I have been tasked with having our application make entries into our customer's Sharepoint database. I have found the table where I think these entries are stored ("AllUserData"), but there are ...
0
votes
2answers
249 views

How to grant user DB_Owner on all SharePoint 2013 databases

For many admin tasks for SharePoint 2013 using PowerShell you need to have DB_Owner for all SharePoint databases. The Add-SPShellAdmin command no longer granted DB_Owner to the SharePoint databases, ...
0
votes
0answers
30 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. ...
1
vote
4answers
8k views

SharePoint 2010 - Database Schema

I´m searching for informations about the SharePoint 2010 Database. Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn ...
4
votes
1answer
55 views

How to retrieve all list/library which uses custom content type in a site collection?

How to retrieve all list/library which uses custom content type or a custom column in a site collection? It would be really helpful if you post your answers in C# code or SQL query. Please let me ...
0
votes
1answer
115 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 ...
1
vote
2answers
108 views

BCS, can I connect a result of SQL query to external database in SharePoint list?

Can I connect a result of SQL query to external database in SharePoint list? As I understand - External Content types could map only one table for list, but I need to get some combined data from few ...
0
votes
1answer
157 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
1k views

The index entry exceeds the maximum length

I have been receiving this error: The index entry of length <> bytes for the index '<>' exceeds the maximum length of <> bytes. The index entry of length for the index exceeds maximum ...
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.
1
vote
1answer
30 views

Do I need to drop database before doing SP-remove?

I'm currently testing doing some stuff on a site collection with a console app. I'd like to redo the test by deleting and then restoring the site collection, but I'm not sure if I need to delete ...
1
vote
0answers
104 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 '...
2
votes
1answer
91 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 ...
1
vote
1answer
114 views

How to solve error with comments paging on blog site?

We have a news functionality in SP2013 based on the blog site template. The problem occurs when a post receives more than 10 comments: SharePoint adds a paging button (the left and right arrows) in ...
1
vote
1answer
34 views

Upload data stored in external SQL database

I want to upload some data which is stored in external SQL database to SharePoint database and it should reflect in forms under SharePoint.
0
votes
1answer
1k views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
1
vote
1answer
111 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?
0
votes
0answers
30 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: "ad.domain....
0
votes
1answer
85 views

import user profile directly from an external source (`SQL database`) without using active directory?

Pertaining to SharePoint 2013, How do I import user profile directly from an external source (SQL database) without using active directory? is it possible to start the User Profile Synchronization ...
2
votes
1answer
100 views

Is it possible to import user profile from an external source, not from active directory

How do I import user profile directly from an external source (SQL database) without using active directory? The common usual solution is to have a SharePoint privilege account that have the ...
0
votes
1answer
360 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
108 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
1answer
51 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 ...