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 ...
- 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....
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 ...
- 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 ...
- 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 ...
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
- 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 ...
- 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 ...
- 1,951
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 ...
- 51
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 ...
- 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 ...
- 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 ...
- 24.6k
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 ...
- 996
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
...
- 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 ...
- 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
- 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....
- 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.
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 ...
- 21.1k
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
- 13.3k
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 ...
- 13.3k
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 ...
- 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 ...
- 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.
- 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 ...
- 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, ...
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;
...
- 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 ...
- 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 ...
- 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 ...
- 961
Only top scored, non community-wiki answers of a minimum length are eligible