Hot answers tagged

5 votes

Add entries to AllUserData from SQL

This is completely unsupported! Do not read or write data to SharePoint databases. You need to go through the SharePoint Object Model, namely using SPWeb.EnsureUser which will add the entry if it does ...
user avatar
  • 28.8k
5 votes
Accepted

SharePoint 2013 list in SQL

Where does SharePoint list stores data in SQL? In SharePoint Content DataBase at AllLists INNER JOIN AllUserData ON AllLists.tp_ID = AllUserData.tp_ListId where the data stored at AllUserData....
user avatar
4 votes
Accepted

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

Nico, I found a source that may help you immensely. The following link walks you through how to use a PowerShell script to import a list of users from Excel and create them for FBA. Importing and ...
user avatar
  • 1,129
4 votes

Conceptually, how are lists different from SQL tables?

SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that ...
user avatar
  • 56.6k
4 votes
Accepted

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

Depending on your specific requirements, the easiest way is probably to use BCS to create external content types that link to your MySQL data. Your SharePoint hosted app can then read/write that data ...
user avatar
4 votes
Accepted

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

You can detach the content database from central admin and then reattach using the correct SQLCluster Name. You dont need to delete anything. Attach or detach content databases in SharePoint 2013
user avatar
  • 56.6k
4 votes

Migrating content databases

You must use cliconfg.exe on each SharePoint server to point the 'old' SQL Server name (and instance if applicable) to the new SQL Server name (and instance if applicable). So if you had an old SQL ...
user avatar
  • 28.8k
3 votes

Site traffic SQL query?

For SP 2010, you can use Web Analytics feature built in SharePoint: http://blogs.msdn.com/b/ecm/archive/2010/03/21/introducing-web-analytics-in-sharepoint-2010.aspx For SP 2013 things have changed a ...
user avatar
3 votes

Restore content database 2013

Delete your web application. Create a new one. Take care that the authentication mode is identical with the initial web application in which your backed up site collection has been created. Do not ...
user avatar
3 votes
Accepted

Where are List View definitions stored?

Writing queries directly on SharePoint databases is highly discouraged. You should consider the database as a black box which you can interact with through the provided APIs (either SSOM, CSOM, REST ...
user avatar
  • 4,787
3 votes

SQL TempDB size

TEMPDB is a temporary database that contains all Temporary user objects such as: global or local temporary tables, table variables, cursors. It also includes internal objects created by the SQL Server ...
user avatar
  • 56.6k
3 votes

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

Do not remove the site collection from the database! Just remove it via the GUI (Site settings -> Delete site) or use the PowerShell cmdlet Remove-SPSite (outlined here). This will make sure it is ...
user avatar
3 votes
Accepted

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

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a ...
user avatar
3 votes

How to grant user DB_Owner on all SharePoint 2013 databases

You can use the script to give specific users the db_owner role. Don't forget to dd all users to users.txt. [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | out-null ...
user avatar
  • 1,752
2 votes

Efficiency of SQL updates/queries versus dealing with lists

Directly accessing the SharePoint Database not recommended in production in any who. But you can do it in Staging or dev/test farm. For read operations: Reading from the SharePoint databases ...
user avatar
  • 56.6k
2 votes

How to get ".sql" files to be searchable in SharePoint Foundation 2013?

In SP2013 you also need to run New-SPEnterpriseSearchFileFormat see HOW TO: Implement a custom iFilter in SharePoint 2013
user avatar
  • 32.3k
2 votes

Enabling RBS on more than content database (Different site collection)

RBS isn't configured correctly. You need to have master key in your SharePoint Content database. Use the following command to add it: use [ContentDbName] if not exists (select * from sys....
user avatar
  • 8,197
2 votes

Is it possible to run/ install sharepoint on MySQL

It is not possible. You need Microsoft SQL Server. More info in Hardware and software requirements for SharePoint 2013. Technet.
user avatar
2 votes

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

Has nothing to do with SharePoint. If you configure the server your MYSQL database runs on to accept Cross Origin requests you can access it from any environment. A https connection is preferred, but ...
user avatar
2 votes

Upload data stored in external SQL database

If your database is SQL, then there is a built in feature to achieve this. Follow the link For other databases you have to write a custom wcf web service. see here
user avatar
2 votes

How to import data from sql database to a SharePoint list?

BCS: Business connectivity Service allows us to connect external data and work with it from SharePoint.Just we need to create an external content type. Getting started with Business Connectivity ...
user avatar
2 votes
Accepted

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

SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too. Also look at the accepted answer ...
user avatar
  • 1,944
2 votes
Accepted

Conflict Content Databases names inside my sharepoint farm

The name of a content database is just a random generated name that does not have any type of function more than that you can't have 2 databases with the same name. (Every database has it owns unique ...
user avatar
  • 9,491
2 votes

Configure SP2013 to connect to SQL alias Name after Installation

You cannot do so. SharePoint will always need to reference that particular SQL Server name/instance name now. In order to change it, you would have to build a new farm.
user avatar
  • 28.8k
2 votes

Converting SharePoint list into SQL

If you need to use the data contained in the SharePoint list as a source for some other subsystem, I would first of all question if the data should be kept inside SharePoint in the first place. Some ...
user avatar
  • 6,844
2 votes

Several SharePoint farms using the same clustered SQL Server

It is possible to host multiple SharePoint farms within one SQL instance, but there are a few things to keep in mind. Unless you already used a shortened SQL alias in creating your existing farms, ...
user avatar
2 votes

Dismount and Mount of social DB, Sync DB and Profile DB on SP 2010

You could use this method to setup new UPS using Prod UPS Profile DB in Development: Delete the UPS and keep the databases in Development UPS; Detached the Prod UPS Profile DB from Prod SQL Server; ...
user avatar
  • 56.6k
2 votes

SQL service accounts keep getting Locked out

You can do troubleshooting by looking in Windows eventviewer. There is a category "Security". Please look for the Keywords Audit Failure. You might also use the tool Lockout Status to get more ...
user avatar
  • 5,053
2 votes

Suddenly am getting "Cannot open database requested by the login. The login failed."

Try this within a SQL window inside management studio and let me know what happens. USE [SharePoint_AdminContent_92178c76-6c90-4b06-9129-f821866edr4b] GO CREATE USER [yourdomain\yourusername] FOR ...
user avatar
  • 1,129
2 votes
Accepted

How to move web app data between farms

Back–up content database from the Source SP2010 SQL server and restore it in Destination SP 2010 SQL Server. Make Sure that the new Content DB has corect permissions (read & write). In SharePoint ...
user avatar
  • 961

Only top scored, non community-wiki answers of a minimum length are eligible