SQL Server is a relational database server used in SharePoint
3
votes
4answers
2k 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
617 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 ...
2
votes
2answers
278 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
53 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
269 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
2k 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
245 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
658 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 ...
0
votes
0answers
18 views
Different usages shown in SQL server 2008 and SharePoint 2010
The content database size in SQL server is 84GB while shown up in Sharepoint 2010 - Site Collections Quotas and Locks is 698GB. There is a discrepancy of 15GB usage. Why the usages are different?
18
votes
6answers
4k 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
40 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
764 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
267 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
85 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
195 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
40 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
101 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 ...
1
vote
0answers
112 views
Dataview Web Part only works when pulling 110 lines or less of SQL
I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query.
Unfortunately my queries appear to be limited to returning 110 ...
1
vote
2answers
365 views
Update a list via SQL with MOSS2007?
How can I go about applying an update statement to a on MOSS2007 deployment?
Essentially I'd like to write something similar to the following across it:
update <list_name>
set ...
1
vote
1answer
222 views
SharePoint 2010 new server farm with shared SQL Server
Here is the situation I'm planning an upgrade from MOSS 2007 to MOSS 2010. My goal is to provision the minimum amount of new hardware. My Thought was to just setup new WFE's and re-use the existing ...
1
vote
1answer
212 views
SharePoint 2010 Farm Setup : Virtualize the SQL Server 2008 or NOT?
2 years back when I was working on SharePoint 2007 , virtualization of SQL Server was not recommend due to performance and clustering issues. When it comes to SharePoint 2010 , I see most of the MVPs ...
2
votes
2answers
821 views
Import a SQL Server table into a SharePoint list to use in InfoPath
I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.
0
votes
3answers
1k views
Content Database showing 0 (zero) site collection after content database attach
I have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server ...
1
vote
1answer
145 views
Which identity is being used and authenticated while connection to SQL Server with Windows Authentication?
SQL Server Windows authentication uses application's process identity or thread identity to connect. So, for a solution deployed to a SharePoint farm which identity will be used to connect
Current ...
1
vote
1answer
493 views
Looking up a value in SQL to set a value on the InfoPath Form
Looking up a value in SQL to set a value on the InfoPath Form.
I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
1
vote
3answers
488 views
SharePoint 2010 - Generate reports from SharePoint Database?
It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ?
I heard maybe it is possible with the WSS-Logging Database.
Are there ...
1
vote
2answers
2k views
Moving Sharepoint Foundation 2010 from SQL Express 2008 R2 to SQL Server 2008 R2
We have a very small Sharepoint Foundation 2010 farm with a library and some workflows. We want to build this originally on one server using SQL Server Express 2008 R2.
However, there is a chance ...
0
votes
2answers
66 views
SharePoint 2010 installation - sql server
Simple question...
Is it a requirement that SQL SERVER be installed on the same machine SharePoint is on?
This is for a development installation...
I.e. could I have SharePoint setup on one VM and ...
0
votes
1answer
39 views
Backup Plan for a VM based sharepoint website
I developed a doc sharing website for my company using Sharepoint2010 and SQLServer 2008 R2.
The website is on a virtual machine powered by Hyper-V
Now, I am thinking the disaster recovery plan.
...
0
votes
1answer
116 views
Not able to configure ssp on MOSS 2007 server
I am not able to configure ssp on MOSS 2007 server.
I found that OFFICESERVERS service was not running.
I checked system event log I got this error: The SQL Server (OFFICESERVERS) service terminated ...
1
vote
2answers
835 views
SQL Hardening, BCS, and ECT (SharePoint 2010)
Currently running into some errors when trying to setup External Content Types with SharePoint 2010. The goal is simple which is to connect to a SQL Server and pull information into SharePoint to an ...
3
votes
1answer
1k 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 ...
0
votes
1answer
76 views
SP2010 Install on virtual [closed]
I started to work on a home based play project where I wanted to created at least 2 VM (using vmware). Server 2k8 went good. then I moved on to setup AD (DC) and completed this piece. next step was to ...
0
votes
2answers
130 views
Does SharePoint need to be installed on the database server?
Or more specifically, how much of SharePoint needs to be installed on the database server?
I have a SharePoint environment I'm getting ready to move into production but I'm a bit paranoid that the ...
0
votes
1answer
76 views
Always Sync Form Library Columns data with SQL Server 2008
How do I set a "always-sync" connection between a Form Library and a Database (in SQL server 2008)?
Scenario:
I have a Form library that use InfoPath form. In the form library, there are multiple ...
1
vote
1answer
764 views
How to design for large content databases?
Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...
1
vote
1answer
136 views
Advantage of SharePoint aware mirroring compared to normal SQL mirroring?
We are going to implement mirroring for our databases in order to increase the data redundancy. Our understanding is that SQL clustering won't help for this. Can someone please explain for me why we ...
1
vote
2answers
1k views
External Data field - problem with refreshing (SP 2010)
I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
1
vote
1answer
227 views
Finding the location of the SharePoint Configuration Database in API
I'm building a .NET Health Analyzer Custom Rule which checks a few vital signs of another custom application I have built, however if the application is also deployed on a server that is also hosting ...
0
votes
1answer
2k views
Add login account to access “WSS_Content”
I need to run the SharePoint Content Deployment Wizard (2.8) on SP 2010. It tries to read the database "WSS_Content" using my login account but keeps blowing up with this error when it tries to do the ...
3
votes
4answers
710 views
What is the recommended way to query data on a Sharepoint site?
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
2
votes
2answers
190 views
Should we have thousands of sleeping database connections from the Crawler server?
Our IT Manager has brought up a situation where it looks like we have about 5000+ sleeping connections from the Crawl Server to our SQL Server. This seems like quite a bit and it's been slowly ...
2
votes
1answer
1k views
Tutorial to move WSS 3.0 DBs from Windows Internal to SQL 2005 Instance
I have found or have been told about a few ways to move WSS 3.0 databases from the Windows Internal Database to SQL Server 2005. As I read them, however, I find I have more questions.
Two I found ...
0
votes
1answer
269 views
How to get real file path from a BLOB
I have a situation in which data (mostly images) is stored in a BLOB. As you know data in BLOB are guid like which I cannot relate to any file. My question is, is there a way by which I can extract ...
0
votes
1answer
477 views
SharePoint Farm SQL Server tempdb/Crawl DB disk configuration
We've identified I/O latency on SQL Server portion of our farm. We see tempdb and CrawlDB are biggest offenders. We have 2 extra Raid 1 disks available to us. Let's call them X: and Z:. The ...
1
vote
1answer
4k views
failed to start the database services MSSQL$Sharepoint
I am trying to install Share Point 2010 Foundation on a Win7 SP1 64-bit desktop.
It installed with an error, something about Office components.
When I start the SharePoint Central Admin Web App, I ...
1
vote
2answers
3k views
Can't Create External Content Type linked to SQL Server
In Sharepoint 2010, I am trying to create an External Content Type, and use a connection to a SQL Server. But, in Sharepoint Designer, when I am in the wizard to create an ECT, I'm having trouble ...
3
votes
1answer
211 views
Which version of SQL Server Express gets installed with Search Server Express 2010?
What exact version of SQL Server Express 2008 gets automatically installed via the standalone setup of SSE 2010? Is it just SQL Server Express 2008, SQL Server Express 2008 R2 or a special kind of ...
3
votes
4answers
2k views
Why is SharePoint_Shell_Access permission required to run SharePoint powershell?
So we're setting up a SharePoint farm and it seems our admin accounts require access SharePoint_Shell_Access role on SQL.
http://technet.microsoft.com/en-us/library/ee806878.aspx
...
6
votes
4answers
1k views
Reusing and parameterising BCS External Content Types
I recently posted a query here that asked about the best way of connecting to an external SQL store.
I got some great responses back but need a little more info, specifically around External Content ...
