SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
1answer
1k views

Upgrade SQL 2008 R2 Standard to Enterprise Edition in SharePoint 2010

We are using SQL 2008 R2 Standard edition with SharePoint 2010. If we decide later on to upgrade to the SQL 2008 Enterprise edition, what is the process and the impact on the SharePoint environment?
1
vote
1answer
472 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...
1
vote
2answers
10k views

database size would exceed your licensed limit of 4096 MB per database

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some ...
1
vote
1answer
552 views

MOSS 2007 SP2 DB index maintanance

I've read in the "About Service Pack 2 for SharePoint Products and Technologies" paper that SP2 includes an update for the Update Statistics Timer Job that causes SharePoint to run SQL Server's online ...
0
votes
1answer
1k views

config wizard fails at step 2 after creating database

I have been having a lot of trouble installing WSS 3.0 on windows server 2008, usign SQL 2008. I have found often the solution where it asks to create the db usign the psconfig command line but ...
0
votes
2answers
493 views

Trimming audit events

We'd enabled all types of audit events for our production web-application and ended up with an issue with DB as auditData table grown to 50GB. Now, we want to reduce the size of the AuditData table. ...
2
votes
2answers
251 views

Database migration problem

We have recently migrated our MOSS databases from MS SQL Express 2005 to MS SQL 2008 both intances running on the same Windows 2003 server. After "successful" migration we switched the 2005 server ...
2
votes
2answers
621 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
1
vote
1answer
426 views

SharePoint Learning Kit database error

I have installed the Microsoft SharePoint Learning Kit but when I'm configuring the SLK it gives the following error: 'CREATE DATABASE permission denied in database 'master'.' Does anybody know what ...
2
votes
1answer
439 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...
1
vote
1answer
410 views

Get/Connect to Local Sharepoint SQL Instance

How does one find the name of, or connect to the SQL instance, that SharePoint uses when you perform a basic/local install?
1
vote
2answers
114 views

Extra database server in farm

Recently I was looking at Central Admin > Operations > Servers in Farm and noticed an extra database server. It is the same name as the actual database server with "-Common" appended to the end. This ...
7
votes
5answers
5k views

SQL Server 2005 vs SQL Server 2008 on SharePoint 2010

I'm writing a recommendation for an upgrade scenario from SharePoint 2007 to SP2010. Customer is currently running x64 SQL Server 2005 SP3 on Windows 2003 Server. Does anyone have pros/cons for ...
2
votes
2answers
970 views

Changing to SQL alias after installing MOSS

Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but ...
2
votes
2answers
564 views

What MOSS issues can I expect with default SQL Server collation?

SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, ...
0
votes
3answers
593 views

SharePoint 2010 Beta 2 with SQL 2008 R2

Are there instructions for installing SharePoint 2010 Beta 2 with SQL 2008 R2? I notice that none of the installation resources thus far describe using R2. (At the time of writing R2 is at November ...