Questions tagged [sql-server]
SQL Server is a relational database server used in SharePoint
498
questions
0
votes
1
answer
68
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?
- 1,709
1
vote
1
answer
90
views
Add SQL Analysis Services to a existing SharePoint Farm
Our SharePoint Farm is based on a failover SQL cluster (MS SQL 2012 Standard). The problem is, that the Analysis Services were not installed with the database engine.
If I'm understanding right, it's ...
- 10.9k
2
votes
2
answers
4k
views
How to archive the AuditData table on a contentDB?
I have a content db whose audit log is getting really big (60GB) and it's starting to effect the DB. I know I can go in and delete entries via Powershell, but I wanted to archive this table before I ...
- 28.3k
1
vote
1
answer
34
views
How is DocumentSet Capture Version data stored in Content Database
Is it possible to know how a "DocumentSet Capture Version" data is stored in SQL Server Content Database ? (Not using OM but directly).
- 28.3k
2
votes
1
answer
830
views
SharePoint 2013 + Reporting Services + Kerberos
How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database?
I found below blog but I'm not sure about ...
- 345
0
votes
0
answers
113
views
Error while creating aspnet.db for Form Based Authentication
I want to install SharePoint 2013 FBA Pack for user password management. When I followed the instruction to prepare my system, I can not create a aspnet.db. I got the following error message:
Setup ...
- 133
0
votes
1
answer
162
views
SharePoint 2013 FBA Pack without SQL server Management Studio
I used of "prerequisites installation" option for install all of prerequisites for SharePoint 2013. This option just installed SQL server 2008 R2 without SQL server Management Studio. After SharePoint ...
- 57k
1
vote
1
answer
629
views
Change default Calendar events to have dropdowns populated by SP Lists
I figured out how to change the fields in a calendar to add extra info about events. Is there a way that I can take the fields that popup when I try to add a new event and get a dropdown table based ...
- 7,372
11
votes
9
answers
19k
views
Content database size vs site collection size
We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
- 2,287
3
votes
1
answer
7k
views
Unable to perform A full Farm Backup
I have SharePoint 2013 server, containing one web application and three site collections.
I want to perform my first full farm backup, so I wrote the following command inside SharePoint PowerShell:
...
- 24.5k
1
vote
2
answers
87
views
How to decide between native SharePoint Lists or External Content Types?
We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint.
Our team is building a HelpDesk ticketing system in SharePoint. ...
- 57k
0
votes
1
answer
490
views
Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013
What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
- 57k
0
votes
1
answer
2k
views
SQL Server 2014 Features Required for SharePoint Foundation 2013
I'm migrating a simple SharePoint installation (WSS 3.0 with internal DB) to SharePoint Foundation 2013 backed by SQL Server 2014. SQL Server 2014 seems to have a lot of options about which features I ...
CommunityBot
- 1
1
vote
2
answers
62
views
Who has permission to see what?
We just encountered a problem in our site - 95% of the security permission settings that we had in place were lost.
We have added them back manually and suspect we have added them back 95% correctly ...
CommunityBot
- 1
0
votes
1
answer
366
views
SharePoint: Perform a query to load data into external list and display the results in a list within the webpart
I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
- 7,885
2
votes
1
answer
55
views
How to fill up values from sql into a newform.aspx
I have a list that has fields like, name, position, year of birth. This information is stored in a database (read only).
When a user opens list's form (an OOTB form) , I want to go to the database, ...
- 2,392
0
votes
2
answers
136
views
Can we use SQL Server as a primary data storage for SharePoint 2013?
Is it possible to use external SQL Server as a primary data storage for SharePoint 2013?
Having this implemented we can generate reports, query data and it would become very very powerful to use.
Or
...
- 281
0
votes
1
answer
387
views
Populate field in a form depending on value on another from database in SP2010
I have a List with three fields, all three text boxes. The first field is an ID, which when populated needs to trigger a DB query to pull corresponding title and description from a table in SQL Server ...
- 1,363
1
vote
1
answer
6k
views
SharePoint Designer SQL Server Connections, Connection Strings
Forgive me as I am new to SP Dev.
I have a DB server that I use RDP to connect to via VPN from a local laptop.
I know the name of the DB server. The DB (SQL Server 2008) is set up to use Windows ...
- 2,287
0
votes
2
answers
1k
views
Adding more fields to SQL membership Provider for form-based authenticaiton
I have set up form-based authentication for SharePoint 2013 with .NET SQL Membership Provider.
It is working fine but I have requirement to add more fields for the users.
Will I have to write my own ...
CommunityBot
- 1
1
vote
1
answer
171
views
Changing sql servers crashes sharepoint
So I have two SQL servers, server A and Server B. Server B is the newest one and the one we are moving things to. I have moved over all the content databases and changed everything in central admin ...
- 10.9k
0
votes
1
answer
40
views
Is this do-able in SharePoint 2010?
I'm very new to SharePoint so please forgive me if its a dumb question.
I have a SQL Server database storing a set of manual tests and grouping information of the tests. I want to have a list to ...
- 113
1
vote
4
answers
4k
views
Access SQL Server data in SharePoint Online list
I have an existing Asp.Net solution which stores data into SQL Server 2008 database.
I would like to reference that SQL server data in SharePoint Online list. What would be the best way to do it?
...
- 24.5k
0
votes
1
answer
1k
views
SQL Server Standalone and Sharepoint connected to a domain
I am currently in the process of setting up a client that wishes to use SharePoint. They currently have a Enterprise version of SQL Server 2012 running in a standalone environment and is not connected ...
- 57k
0
votes
2
answers
159
views
Querying Published Access 2010 Web Database from SQL Server
I have a published Access 2010 Web Database on my SharePoint 2010 site. The forms and tables all work as expected, but I would like to query this database from SQL Server. Is this possible?
...
CommunityBot
- 1
1
vote
2
answers
7k
views
Workflows and SQL Server Databases
Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint?
Using a WebPart to put and modify data in a database isn't a problem. ...
CommunityBot
- 1
0
votes
1
answer
442
views
SharePoint Foundation 2010 with SQL Server 2008 R2 SP2 - compatibility?
I have to upgrade SharePoint Foundation 2010 databases SQL Server 2008 R2 to SP2.
If SharePoint Foundation 2010 is full compatibility with SQL Server 2008 R2 SP2?
- 7,885
0
votes
1
answer
43
views
Sharing same SQL server for a SP2010 and SP2013 farm. Viable?
We are planning to migrate SP2010 to SP2013. Due to we have no spare SQL server (we do have separated APP and WFE servers), I am planning to install SP2013 on existing SQL instance with different DB ...
- 4,065
0
votes
1
answer
935
views
Which versions of sharepoint support sqlserver read commited snapshot isolation?
I have been unable to find out if Sharepoint 2010 or 2013 (or even 2007) are able to take advantage of this MSSQL feature to improve the performance of the database operations invoked by Sharepoint ...
- 46
1
vote
1
answer
194
views
What is the sql database user implications for SharePoint?
I am interested to know about the SQL database users under SQL->Security and their server roles and its implications for SharePoint users.
- 17.8k
1
vote
0
answers
57
views
RBS won't work with default "0x" SID credentials
I'm trying to get RBS to work without having to specify credentials for each user (SID) in the RBS tables. MSDN notes that default credentials starting with 0x can be used:
Each credential entry ...
- 652
0
votes
1
answer
650
views
How to connect a local database in a sandbox environment?
I have the following scenario:
I am very new to Sharepoint 2010 development. In order to practice I had to create a sandbox. Therefore I was instructed to do the following steps:
Get Windows 8
...
- 293
1
vote
1
answer
977
views
Stuck backup process - Backup or restore is already running
From a few days I'm not able to performe backup. Backup always stuck on the same level - eg backup files have 10GB in jobs I see running backup proces and that it, backup stuck. When I delete that job ...
- 1,548
0
votes
1
answer
24
views
Sharepoint data base management
Dose anyone know a tools for SharePoint content data base management (add/remove,attach ... the content database )
- 18.2k
1
vote
1
answer
158
views
Restore farm backup and rename databases?
I'm using the Backup-SPFarm PowerShell cmdlet to backup our SP 2010 Server farm and all of its associated databases. We want to test our restore process, and I'm wondering if it's possible to restore ...
- 57k
2
votes
2
answers
3k
views
Is it suggested to restart SQL servers regularly?
In my experience, all Microsoft products need to be restarted regularly to keep the memory allocation healthy.
But I always think it is an unofficial practice until I see this article:
http://technet....
- 24.5k
1
vote
2
answers
4k
views
How to use SQL tables as SharePoint lists?
We are creating a new SharePoint site for an existing application (.NET & SQL).
Now, we need to create few lists and use existing SQL tables as SharePoint lists. Is this possible, how to do it, ...
- 24.5k
1
vote
1
answer
182
views
Can multiple MS-Access 2007 front ends be linked to an SQL Server 2008 backend on Sharepoint?
I have several computers at different locations, each with their own copy of an MS-Access 2007 front end. Each copy links to an SQL-Server 2008 back end on a server. I would like to migrate the back ...
- 1,590
2
votes
2
answers
1k
views
Should we run SharePoint 2013 on Windows Server 2012 or 2008 R2
We are getting ready to start a project to bring up a brand new SharePoint 2013 Intranet/Extranet site and was wondering if we should be using Windows Server 2008 R2 SP1 or Windows Server 2012. I know ...
- 337
2
votes
1
answer
1k
views
Claim Based authentication on SharePoint 2013 and "Integrated Security"
I have a problem with a SharePoint 2010 application that now runs on SharePoint 2013.
The application has been converted and seems to have no problem "from a code" point of view. The problem comes ...
- 238
0
votes
1
answer
201
views
Backup/Restore which content database?
I have seen a few posts about backing and restoring SharePoint content databases from both Central Admin and using PowerShell. My question is relatively simple I hope.....
There are a number of ...
- 18.7k
1
vote
2
answers
4k
views
How can I tell SP installation of an existing SQL server
I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same ...
- 11
1
vote
3
answers
340
views
How can I archiving gmail hosted emails on SharePoint Server
I have my email hosted on gmail cloud server, and I am about to get SharePoint 2013. I would like to use SharePoint to archive my gmail email on-premise. Can you advise on what I should do?
- 57k
2
votes
1
answer
64
views
What exactly does it mean that storing "large blobs in the database reduces performance"?
To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
- 2,676
1
vote
1
answer
3k
views
Aliasing the SQL Server name
I'm creating a new SP 2010 farm that will replace our existing 2007 farm (using the db attach method), and decided I should probably use SQL aliasing with this install. So 2 questions relating to this....
- 12.2k
0
votes
1
answer
39
views
Is the IIS role necessary on a dedicated SQL server?
I haven't been able to find anything on this. I'm looking into only the bare necessities for a dedicated SQL server being used by a SharePoint farm.
Is the Web Server (IIS) role necessary for a ...
- 12.2k
1
vote
1
answer
35
views
Should I perform scheduled content DB SQL backups in addition to scheduled granular backups?
Currently we have a series of scheduled granular backups for the site collection level that use the PS "Backup-SPSite" command (e.g. https://myportal.com). I test these backups frequently, and have ...
- 12.2k
3
votes
1
answer
944
views
Extracting browser-compatible InfoPath 2013 form submission data into a SQL Server 2008 Database as well as a SharePoint 2013 list
We are looking at using InfoPath 2013 to capture simple sets of data without the need the need for writing custom applications. However, we still need the information to be stored in a SQL Server 2008 ...
- 33
4
votes
1
answer
6k
views
Form for user to input data and submit to run sql command
We're looking for an quick and easy way for an HR person to enter data into a couple fields and then have them click submit and have it execute some SQL Update query on the database. We don't need to ...
CommunityBot
- 1
3
votes
2
answers
61
views
Migrated 2010 Databases, but some DBs can no longer be pointed to due to alias
Here's our scenario.
We successfully migrated our SharePoint 2010 Foundation databases to another server using this method and this article. The key point is that we set up an alias from our existing ...
- 807