SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

2
votes
2answers
450 views

Migrate Sharepoint 2007 to 2010

So right now there's a SharePoint 2007 site filled with data. I have to migrate EVERYTHING properly from the SharePoint 2007 site to a new server that has SharePoint 2010 and Windows Server 2008 ...
1
vote
1answer
85 views

SQL Server 2008 Installation on SP 2010

I'm installing SP 2010 on Virtual Machine Windows Server 2008 R2. My Question: Is it necessary to install SQL Server 2008 (or R2) before installing Sharepoint Server 2010? Plus, when installing SQL ...
1
vote
2answers
2k views

SharePoint Business Connectivity Services (BCS) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I am running SharePoint 2010 with SQL 2012, I am trying to get Business Connectivity Services (BCS) running but I am facing a double-hope authentication issue. Every time I try to connect to the ...
1
vote
1answer
684 views

DispForm.aspx taking 5+ minutes to load on SP2010 Server, high CPU utilization

We have one list that has about 55 columns. Most of these are very simple columns (number, text, choice), though there are four that are Lookups to another list. All four lookups columns lookup ...
0
votes
1answer
35 views

Upgrading from SQL 2005 to SQL 2008R2 with RBS support

I am looking at setting up Sharepoint 2010 in our local test environment and our current test SQL server is running SQL 2005. I am just wondering if it is possible to upgrade the database later to SQL ...
0
votes
1answer
284 views

Attaching and restoring document library files from a .mdf config database file?

We have a Symantec backup system that runs through all of the instances on a SQL2008 box and backsup data, I would like to restore a corrupted document library and am wondering as to how I would ...
0
votes
3answers
2k views

Populate Data From SharePoint List to a SQL Table

Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that ...
2
votes
1answer
427 views

File size too large with RBS and SharePoint 2013

since i set up my SP2013 Foundation Preview with SQL Server 2008 R2 Express i wanted to use the RemoteBlobStorage. It works seemingly fine just now. The only problem is if my files which im uploading ...
0
votes
1answer
684 views

Microsoft SQL Server 2008 R2 (RTM)upgrade query?

Will SharePoint Server 2010 SP1 be compatible for an upgrade to SQL Server 2008 R2 SP2 CU2 from Microsoft SQL Server 2008 R2 (RTM)? If we upgrade(from Microsoft SQL Server 2008 R2 (RTM)) Is there any ...
1
vote
2answers
58 views

Backing up all sharepoint web applications?

I have a sharepoint farm hooked to a named instance of SQL2008. I have a web application (it is also extended to another web app) that I would like to back up. Here is what I am trying to achieve: I ...
0
votes
1answer
395 views

Event Receiver Item Added for Multiple Files uploaded

I am trying to add few details for a item that is added to a list to SQL database table using a stored procedure, it works perfectly but when I upload multiple files it adds all of the items into the ...
-1
votes
1answer
46 views

powerpivot configration

i installed sql server 2008 and SharePoint 2010 and finished the installation of the pivot but when i clicked start - 1 all programs -sql server 2008 - configuration tools - (but the only thing exist ...
1
vote
1answer
875 views

What benefits do I get by upgrading to SQL Server 2012 Enterprise?

With SharePoint Server 2010 Enterprise edition, what additional benefits do I get using SQL Server 2012 Enterprise edition as opposed to SQL Server 2008 R2 Enterprise edition?
0
votes
2answers
54 views

SQL Server 2008 Install / Data Location

Am about to try and install SQL Server 2008 R2 for the second time. How and when during an install can I configure my data to be held on the D:/ drive as opposed to the default C:/ drive?
0
votes
2answers
2k views

Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?
1
vote
1answer
792 views

Change SQL Server Port for existing SharePoint 2010 environment - Howto

I have a SharePoint 2010 environment configured with SQL Server 2008R2. Currently SQL Server is running on 1433. I am willing to change the existing SQL server port from 1433 to some non standard ...
0
votes
0answers
398 views

Passing parameters to stored procedure in data view web part

I have a stored procedure which accepts 2 parameters. The stored proc is executed as EXEC MySP N'Val1, Val2', N'A,B,C' I inserted a Data View Web-Part and tried to get data from stored procedure. ...
2
votes
2answers
991 views

Should I regularly backup and shrink my content databases through SQL?

I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help. Should I be regularly ...
1
vote
1answer
74 views

Add a server to SharePoint Admin user?

I need to add one of our production servers (that hosts SQL Server 2008) let's say XXX to SharePoint Admin in SharePoint 2010. How can I do that? I agree that a server is not a user or a group. Let ...
1
vote
2answers
2k views

Connection to external data source using windows authentication (NTLM)

I'm trying to connect to an external SQL server DB programmatically from a SharePoint WebPart. The problem is that I'm not able to authenticate to the DB although I gave access to application pool ...
8
votes
5answers
325 views

Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?

I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
2
votes
1answer
4k views

Create reports from SharePoint lists

We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
0
votes
1answer
268 views

Moving SharePoint databases to a new Server

I followed instructions from the Move All Databases (SharePoint Server 2010) article. I have a SQL alias set up on the original database server and the new database server.  I can connect to the ...
2
votes
2answers
913 views

Move database without creating alias

when we started with Sharepoint we installed everything on a sqlserver that was used for non-sharepoint activities to. Now however we decided to seperate those from each other. Management decided that ...
0
votes
1answer
494 views

Remote BLOB Storage Filestream Issue

I had to enable Remote Blob Storage on my farm. I'm following this tutorial: http://technet.microsoft.com/en-us/library/ee663474.aspx#enable And also this one: ...
4
votes
4answers
12k views

Cannot connect to the configuration database

During usage yesterday my SharePoint services locked up the entire server and forced me to end process SharePoint tasks and stop SharePoint services. The problem was attributed to Office Web Apps, so ...
2
votes
1answer
735 views

Two Server Sharepoint Farm Topology

I'm working on creating a product for Sharepoint and have set up a server farm consisting of two machines running Server 2008 R2. I want to set up SQL2008 on one Machine, and SharePoint 2010 on the ...
3
votes
1answer
199 views

Remote BLOB Storage and Sharepoint 2010

I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change. Should I use the ...
0
votes
2answers
2k views

Cannot connect to the configuration database

I don't really know what to do. I was trying to get some bcs working, and because they were not, I've decided to restart the server. After it restarted I was unable to go on any site / page or on the ...
2
votes
2answers
732 views

Migrating Windows Sharepoint Services 3.0 from Windows 2003 x86 / MSEE to Windows 2008 R2 x64 / SQL Server 2008

I am having a helluva time with this one. I am attempting to migrate a 5 year old VM running Windows 2003 Windows Sharepoint Services 3.0 that was deployed as a standalone (thus to MSEE) to a ...
0
votes
1answer
464 views

View SQL data from CRM into Sharepoint 2010 BCS failing

I'm trying to view CRM Customer data from the SQL database in SharePoint so that I can use it in surveys etc. I followed these instructions (amongst others) ...
1
vote
2answers
2k 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 ...
1
vote
2answers
997 views

Installing SSRS on the Sharepoint Box as opposed to the SQL Box?

We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases. We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
0
votes
1answer
368 views

Migrate Access to SQL Server for SharePoint Integration & Reporting

I'm hoping to get some feedback on this multi-parted problem. The end goal with this problem is to create reports within SharePoint from data contained in some db. Currently, an Excel report exists ...
3
votes
4answers
5k views

Claim SQL server space after content deleted from SharePoint

We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
1
vote
1answer
1k views

Mysterious Error 3355 - SQL machine not available every day at the same time

One my users reports that he cannot access our Sharepoint MOSS 2007 installation at midnight each night. I look in the Event Viewer and every day this error appears at 12:25:20 am: I'm confused by ...
3
votes
2answers
479 views

Installing RBS

OK I have posted other questions about this but no answers were given so I deleted them and thought I would try one last time before calling it a day... I am trying to install RBS for SharePoint ...
0
votes
2answers
58 views

Reporting Server Integration with Sharepoint Server 2010

I have a Sharepoint server 2010 Enterprise in a public domain and a SQL2008 standard in a local domain (with an installation of sharepoint 2010 to support report integration). Does Microsoft support ...
0
votes
0answers
281 views

Move Sharepoint 2010 and SQL from one server to 2 different servers

I am moving a server that has Sharepoint 2010 Standard and SQL 2008 R2 installed to 2 different servers. Could someone explain in detail, what are the steps to achieve this? What are the things that ...
3
votes
2answers
5k views

Moving Sharepoint to New Server

I am running a Sharepoint Server 2010 Stardard on a Windows 2008 R2 server. This server also has SQL Server 2008 R2 installed. I want to move the Sharepoint and SQL to 2 completely new machine. What ...
0
votes
3answers
413 views

Ideal Server Specs for Sharepoint Server

We are about a month to the deployment stage of our Sharepoint Server. What would be an ideal specification (memory, HDD, etc.) for the Sharepoint Server that will serve about 130 employees. We are ...
0
votes
2answers
984 views

SharePoint 2010 Licensing with 10k employees

I am doing my homework and I need to get rough costs for licensing SharePoint 2010 for company with 10,000 employees. I made an assumption that a company runs on Windows Server R2. The SharePoint 2010 ...
23
votes
6answers
9k views

Backup via SharePoint or backup via SQL Server?

How should I backup my 2010 SharePoint server? As I see it there are 3 choices: Full Farm backup Site collection backup SQL Server backup We're only doing backups using points 1 (occasionally) ...
0
votes
1answer
46 views

SQL Server New or Existing for a Sharepoint Installation

We have a Sharepoint farm that uses a SQL Server. I need to create another Sharepoint farm. Can i reuse the same SQL Server or do i need a new one?
0
votes
3answers
1k views

Dataview Web part and SQL - Way to use trusted connection?

As I'm sure you're already aware one of the biggest weaknesses of the data view web part is that it exposes connection strings for SQL Server connections. Instead of using a web service to pass my ...
1
vote
0answers
307 views

SharePoint with SQL Server 2008 R2 Express Edition (max 1GB RAM)

I am planning to launch a light-weight app on a dedicated virtual sharepoint - Windows Server Web Edition 2008 - SQL Server Express Edition 2008 R2 - SharePoint Foundation 2010 When the 1GB RAM ...
0
votes
1answer
99 views

Problems faced for a VPC

UPDATE : Original question was solved by giving proper authentication method to the current user in IIS. Would like to change my question like this: When I browse my site I am getting following ...
1
vote
1answer
355 views

Use REST to sum a column?

I want to retrieve items from a SharePoint list using REST, and then sum one of the columns. I'm brand new to REST, and didn't see a way to do this on MSDN. Is it possible to sum a column in a REST ...
1
vote
1answer
45 views

Not able to see reports in SharePoint site

I have a SharePoint site containing more than 100 reports.But i am not able to see few reports.When i browse the report it executes for 15 to 20 mins then it gives blank page with error at the bottom ...
0
votes
2answers
137 views

SP SQL maintenance - as logs is growing

Should there be a process in place to shrink the log and the db for sp databases? I noticed some of the log files are in GBs. Should the db in Full or simple mode? Are there any standard or good ...