Tagged Questions

SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

0
votes
0answers
12 views

Slow SharePoint 2013 site 18000ms in SQL queries

I have a fresh virtual machine with 12gb RAM and 64bit 4 core CPU. SQL is running on a separate server. My SharePoint 2013 site is running extremly slow. It takes over 20s to load a page. I tried ...
1
vote
1answer
12 views

Can setting MAXDOP to 1 decrease performance?

I was looking at my client's UAT farm and found out that MAXDOP was set to 0 on SQL Server instance hosting SP databases. Before setting this value to 1, I measured response times of most commonly ...
0
votes
1answer
20 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
vote
1answer
21 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 ...
1
vote
2answers
36 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 ...
1
vote
1answer
16 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).
2
votes
1answer
50 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 ...
0
votes
0answers
15 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 ...
0
votes
1answer
19 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 ...
1
vote
1answer
28 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 ...
1
vote
1answer
85 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: ...
0
votes
2answers
33 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. ...
0
votes
0answers
25 views

KRB_ERROR KDC_ERR_BADOPTION (13) for MSOLAPDisco.3

Anyone encountered the KDC_ERR_BADOPTION (13) Kerberos error for the MSOLAPDisco.3 SPN (SQL Server Browser)? Couldn't find any resources related to it. What misconfiguration (or missing ...
0
votes
1answer
35 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,
0
votes
1answer
86 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 ...
0
votes
0answers
21 views

Configuring Windows Server 2008 R2 for SharePoint Server 2013 installation

I've a server running Windows Server 2008 R2 and I want to install SharePoint Server 2013 as evaluation. I don't have any experience with Windows Server roles, features and services. I want to know ...
2
votes
0answers
59 views

Sharepoint 2013 and SQL Server 2012 Service Pack 2

I've tried to research this, but I'm not seeing anything relevant to installing Service Pack 2 for SQL Server 2012. Our DBA's want to apply this to out SharePoint 2012 SQL Server, but I can't find ...
1
vote
2answers
41 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 ...
0
votes
0answers
22 views

How to browse a multidimensional OLAP cube in SharePoint 2013?

I have an instance of SQL Server 2012 analysis services (multidimensional not tabular) with a couple of cubes. I want to browse the cubes from a SharePoint 2013 enterprise edition site. I tried using ...
0
votes
1answer
70 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 ...
0
votes
0answers
19 views

Migration from SQL server 2008 to 2012

I am upgrading MSSQL 2008 to MSSQL 2012. This box contains all of the DBs for our Sharepoint installation. We have identified that we can run the setup wizard to change the database and basically ...
2
votes
1answer
25 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, ...
0
votes
0answers
60 views

Downgrade SQL Server edition from Enterpise to Standart

Maybe somebody faced with the same task and have solved it successfully. If so then, Is there any way to save Web Analytics service application data? Will Search Service Application normally recover ...
0
votes
0answers
25 views

Creat AlwaysOn SQL Server 2014 and running SharePoint 2013 on the Replica

When i am gonna creat an AG the following error shown the following folder locations do not exist on the server instance that hosts secondary replica ...
0
votes
2answers
38 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 ...
0
votes
0answers
29 views

SharePoint remote blob storage confusion

We are considering using RBS with SharePoint 2010. I have researched it but I am still confused about one scenario. We want to store our BLOB's (mainly videos as files) on a NAS. I have read it is ...
1
vote
1answer
976 views

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

I am using Sp2013 Standard server, with 1 APP, 1 WFE, 1 Workflow and 1 Clustered SQL. Everything was all great until Monday Morning (7-28-14). Thats when Event Log started to fire off following ...
0
votes
1answer
45 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 ...
2
votes
0answers
110 views

Usage and Health Data Collection using SQL Authentication

I'm having an issue with trying to set my Usage and Health Data Collection to use SQL Authentication. I have tried setting my database credentials to SQL Authentication using both Powershell and ...
0
votes
1answer
114 views

How to install SharePoint 2013 Installation with SQL Server Authentication

I'm just curious about the steps required to install Sharepoint 2013 using SQL Server Authentication. Also if there are any drawbacks that i might not be aware of. Here are some steps i currently ...
0
votes
1answer
243 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 ...
0
votes
0answers
39 views

PerformancePoint services 2013 with SQL Server 2008

I am trying to use performancepoint 2013 services to create a report that simple displays a set of columns from SQL Server Table. Apparently, PerformancePoint services can only display data from ...
0
votes
1answer
510 views

Local farm is not accessible, cmdlets with featuredependencyid are not registered

So after moving all my databases to the new SQL server I run this on my SharePoint central admin box, http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx#Man Everything goes through ...
0
votes
1answer
37 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 ...
0
votes
2answers
113 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 ...
1
vote
1answer
57 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 ...
0
votes
4answers
489 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? ...
0
votes
3answers
707 views

Can local SQL Server data be made available in SharePoint Online

We have a SharePoint Online account and local data in a SQL Server instance. The data from the SQL Server is available as an OData feed in SharePoint and can be worked with in Excel Power Query. We ...
0
votes
1answer
91 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 ...
1
vote
1answer
267 views

Sharepoint 2013 Foundation, Windows Server 2012 and SQL Server 2012 Licensing

I'm trying to figure out the exact licensing and costs i need for a client that wants to run Sharepoint Foundation. Here is the scenario 1 Server Running Windows Server 2012 + Sharepoint Foundation ...
0
votes
2answers
33 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? ...
0
votes
0answers
23 views

SP2013 reporting in MicroStrategy

I want to use MicroStrategy to build my repots. Normally i use sqlServer and microstrat with the ODBC links but i don't know how to do that with sp. Can i execute some SQLs directly in the ...
0
votes
0answers
40 views

Move SharePoint 2010 and SQL 2008 R2 Reporting Services to new server

I have a server with SQL 2008 R2 and SharePoint 2010 installed on the same box and Reporting Services is running in SharePoint Integrated mode. I'm now looking to move all of this to a new server and ...
0
votes
1answer
107 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?
0
votes
1answer
33 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 ...
1
vote
1answer
1k views

Find a farm's database server and instance in PowerShell

Through PowerShell, how can I find the SQL server name AND instance where my databases are stored? Assuming I am not using an alias and can't check cliconfg. In servers in farm, I can see the server ...
0
votes
0answers
16 views

Error when creating new site collection by new user (developer)

We have installed SharePoint on a server. A new sharepoint developer has joined the team and the system admins have provided him a login: server\newemployee Now, if he logs into Windows and opens ...
0
votes
1answer
47 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.
0
votes
2answers
82 views

SharePoint 2010 Install with SQL Server 2008 Express which is missing agent service, SharePoint will work?

I am installing SharePoint 2010 with SQL Server 2008 R2 Express on Windows Server 2008 R2. During installation of SQL Server, I have noticed Agent service is not in the service list, I goggled and ...
1
vote
0answers
27 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 ...