SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
1k 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 ...
1
vote
1answer
4k 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
38 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
372 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
88 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
1k 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
3k 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
310 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
1k 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
43 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
1answer
212 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
40 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 ...
3
votes
1answer
5k views

Find a farm's database server and instance in PowerShell

How can I find the SQL server name AND instance where my databases are stored using PowerShell? Assuming I am not using an alias and can't check cliconfg. In servers in farm, I can see the server ...
1
vote
1answer
80 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
155 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
33 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
641 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
88 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
195 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
20 views

Sharepoint data base management

Dose anyone know a tools for SharePoint content data base management (add/remove,attach ... the content database )
0
votes
3answers
2k 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
75 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
19 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
882 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: ...
1
vote
2answers
119 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, ...
1
vote
1answer
102 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
568 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
538 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
495 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
93 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
157 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?
8
votes
9answers
7k 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 ...
1
vote
4answers
4k 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
28 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
25 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
460 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
2k 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 ...
3
votes
2answers
53 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
102 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
1k 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
2answers
5k 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 ...
1
vote
1answer
758 views

Project Web App is stuck on: Waiting for resources

While trying to unprovision a PWA in order to move the DB to a new SQL Server. I followed the following article: http://technet.microsoft.com/en-us/library/ff961887(v=office.14).aspx After the ...
3
votes
2answers
11k views

“Invalid License Data. Reinstall is required” error when installing SharePoint 2013 after Sql Server 2012 on the same machine

I've already installed SQL Server 2012 on my machine. Then I tried to run the SharePoint 2013 Foundation installer but I received the following error before I even reached the splash screen menu: ...
2
votes
1answer
51 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
votes
1answer
280 views

Installing SharePoint 2013 on local Domain

I'm trying to install SharePoint 2013 for our company. We already have a Domain Controller running on a separate Windows Server 2003. I am creating a separate server (Windows Server 2008 R2 x64) to ...
0
votes
1answer
70 views

Sharepoint server farm across WAN

I have a general question regarding Sharepoint setup. Currently, my company's setup is as follows: Active Directory domain controller SQL Server Sharepoint 2010 server Secondary AD Domain ...
1
vote
2answers
90 views

Best practice for taking SharePoint data and putting it into an SQL database?

I need to do some reporting across site collections. In order to do this I intend on writing a service layer that crawls SharePoint and puts information about document libraries and files into an SQL ...
0
votes
2answers
122 views

Which database my current SharePoint server is using

I was told by the DB adminsitrator that the current SharePoint server on staging is connected to database named SV002\SPS, but when i create a new application the database server name will ...
1
vote
2answers
321 views

SP_Admin SQL Permissions

I'm trying to create a web application using powershell and I'm getting a log in error with the SP_Admin account. I'm not sure if I've made a mistake when I was setting up the environment, I might ...
1
vote
0answers
676 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...