SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [sql-server]

SQL Server is a relational database server used in SharePoint

Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet)

Questions with the SQL Server tag regards development, configuration and implementation of content and structure database in SharePoint.

Reference: http://en.wikipedia.org/wiki/Microsoft_SQL_Server

499 questions
2
votes
2 answers

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, our internal hosting group uses the default SQL…
MDRoz
  • 187
  • 3
2
votes
1 answer

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?
Rob
  • 536
  • 7
  • 18
1
vote
1 answer

Is it possible running SharePoint Foundation 2010 on the following environment?

I would like to know if the following environment is supported by SharePoint Foundation 2010: OS: Windows Server 2003 R2 DB: SQL Server 2005 Standard Edition (with license model for CPU) If not officially supported by Microsoft, do you known any…
Drake
  • 435
  • 2
  • 10
  • 19
1
vote
1 answer

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.
variable
  • 4,473
  • 13
  • 75
  • 139
1
vote
3 answers

Can I use a SQL Express database for sharepoint 2010?

I'm setting up a dev system with only 2 site collections, is it possible to run an express version of SQL 2008 R2? I'm not too worried about performance, mainly that it will install and run for dev work.
user879
  • 1,066
  • 6
  • 23
  • 47
1
vote
0 answers

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 limitation starts to affect the usage and how (with…
thomius
  • 2,808
  • 8
  • 35
  • 50
1
vote
2 answers

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 practice for sp sql maintenance?
M. Todd
  • 290
  • 3
  • 8
  • 21
0
votes
1 answer

SQL Server 2012 - service account error

I am getting the following 2 errors when trying to install SQL server 2012 on Windows Server 2012. These occur at the server configuration page. Access is denied. The SQL Server service account login or password is not valid. Use SQL Server…
James
  • 99
  • 10
0
votes
2 answers

VS2010 then SP2010

Goal: Using Sharepoint 2010 in my client computer with Windows server 2008 Problem: Should I install Visual Studio 2010 first then install Microsoft SharePoint Server 2010 64-bit and then install SQL server 2012? What chronological order should I…
HelloWorld1
  • 1,035
  • 7
  • 17
  • 23
0
votes
1 answer

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 old server from the new server via SQL Server…
James Grizzle
  • 2,612
  • 4
  • 37
  • 61
0
votes
1 answer

Sync a Sql Server Table with a SharePoint list

Is there a way to automatically sync a Sql Server Table with a SharePoint list? (Sql as source and SharePoint as destination). I tried to connect MS Acces to a SharePoint list as source and seem to work. However now I sould need to sync Sql with…
serge
  • 133
  • 8
0
votes
0 answers

Database locks on content database. How to identify what is generating the statement SharePoint side?

We're currently experiencing database locks on our one of our site collection's content database. These locks are generated by the SharePoint web server, and shows up in the Activity Monitor in MS SQL Studio as a 'SELECT' statement by our service…
Hugh
  • 131
  • 8