SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

2
votes
0answers
22 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
30 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
30 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
10 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
21 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
27 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 ...
0
votes
1answer
34 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
52 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
1answer
92 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
25 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
49 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
25 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
14 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
32 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
43 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
25 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
252 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
11 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
31 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
32 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
24 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 ...
0
votes
1answer
78 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
0
votes
1answer
38 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 ...
1
vote
1answer
48 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 ...
0
votes
1answer
19 views

Sharepoint data base management

Dose anyone know a tools for SharePoint content data base management (add/remove,attach ... the content database )
0
votes
2answers
261 views

Error in User Profile Service connection (it was working fine before)

I noticed the following error on that page where you define connection for User Profile Service Synchronization. An error has occurred while accessing the SQL Server database or the SharePoint Server ...
1
vote
1answer
42 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 ...
1
vote
0answers
12 views

Submitting list data to SQL

I'd like to submit data from a Sharepoint List to my SQL Database. I want the user to be able to create a new list item, attach a file and then once added it will write to an SQL Database. How would ...
2
votes
2answers
113 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: ...
0
votes
0answers
62 views

Expand SharePoint Calendar Recurring Event in SSIS Project using CAML

Is it possible to expand recurring SharePoint calendar events using a CAML query in a SharePoint List Source using the SharePoint adapter off of Codeplex? I have been searching all day and found many ...
0
votes
0answers
14 views

Creating a BCS conectivity with Sharepoint Designer 2010 with MS SQL server 2005 (Externall Table)

When I tryied this Link and Connect with server 2005 : http://kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/ Get a lot of errors with tables(No One ...
1
vote
2answers
48 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, ...
0
votes
0answers
45 views

Row-Wrapping… What limit?

Currently at site collection level on this instance of which is single on both counts, row-wrapping is set to 6. I want to increase this to 7. Traffic is based on 300 or so office employees of which ...
1
vote
1answer
35 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 ...
2
votes
1answer
121 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
2
votes
2answers
98 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 ...
2
votes
1answer
111 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 ...
0
votes
1answer
37 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 ...
1
vote
3answers
67 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?
1
vote
0answers
892 views

Office Web Apps can't read/edit Powerpoint or read Word, but Excel reads/edits fine

A brief overview: I have a Sharepoint 2010 installation on Windows Server 2008 R2, with Office Web Apps installed. The Central Admin SQL Database in on the local server, but the SQL database that ...
0
votes
1answer
24 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 ...
1
vote
1answer
22 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 ...
3
votes
1answer
265 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 ...
0
votes
0answers
867 views

Critical error in event log after installation: Login failed for user

The following error will occur in the event log after starting my Windows Server 2012 server with SharePoint 2013 (Farm installation, not stand-alone): SQL Database 'SharePoint_Config' on SQL ...
0
votes
0answers
14 views

SQL Write Access when using SPExport API

We have developped a tool in C# which use the SharePoint SPExport API. We discover that when we EXPORT some Sharepoint websites, SQL read transactions are growing (normal) but also WRITE ...
3
votes
2answers
45 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 ...
0
votes
1answer
57 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
0
votes
1answer
471 views

Orphan Site Reported After Running Test-SPContentDatabase

I'm upgrading from 2010 to 2013 and when I ran the Test-SPContentDatabase (on destination WFE server pointing at original content DB) command I got the following error relating to an orphan site: ...
3
votes
1answer
2k views

Sharepoint 2013 - SQL Server connection stopped working shortly after database server rename

We have an issue that has been solved, but I am trying to find an explanation. Our Sharepoint 2013 was working fine connected to a SQL 2012/Windows 2012 machine via a SQL Server Alias. We had to ...