SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

1
vote
3answers
9k 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 ...
2
votes
2answers
547 views

401 Unauthorized after database move to new SQL Server

I need some assistance trying to figure out what is going on. We have been running our test SharePoint and test SQL together on the same server and it has been doing ok, but we decided to move SQL to ...
-2
votes
1answer
13 views

How to use infopath to send its data to SQL table? [on hold]

i have already setup an External Content Type set up and a external list in SP.
-1
votes
1answer
19 views
0
votes
2answers
16 views

Scrip sample file? to connect sharepoint 2013 and sql server in a form

I want to create a template in sharepoint 2013 and connected to an SQL server table, so it will populate with the info entered in a form.
1
vote
0answers
27 views

Farm configuration failed during step 3 = sqlexception error + infinite “not running in high constrat …” messages

I try to install a farm with the following requirments : windows server 2012 r2 + sql server 2012 sp2 windows server 2012 r2 + sharepoint 2013 SQL Server was correctly configured (alias, ...
0
votes
1answer
12 views

InfoPath form has connection to SQL server, but form data is not being submitted and stored in db table?

I am created one submit rule which it has the action 1) query using a data connection: Main connection 2) set a field's value @fullname = 1. I need help creating a second rule inserting all the field ...
0
votes
0answers
19 views

How to access ProjectWebApp site without define directory in Url

I am working on SSL configuration on PWA(ProjectWebApp)site with SQL Server 2008 and SharePoint 2013.Whenever someone wants to access it, need to put /PWA (http://servername/pwa ) explicitly in URL. ...
3
votes
1answer
4k 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
2answers
2k views

Content Database Is Not Listing In SQL Management Studio

I have created a new SP web application and the content database name which I have given is WSS_Content_Test. Application created successfully(I checked out and found IIS Website and App pool is ...
2
votes
2answers
19 views

Sharepoint databases status in SQL Server

We have a SharePoint oriented environment where all the content and config databases are hosted on SQL Server. My question is there some way from SQL Server end to find out if the content databases ...
0
votes
2answers
134 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 ...
0
votes
1answer
966 views

SSRS - Get LookupSet results on different cells

Sorry if I'm missing something obvious but I'm a newbie to SSRS (SQL Server 2012 R2) and SharePoint 2010. My boss wants some basic reports from our internal SP site (list data) and I'm doing some ...
2
votes
1answer
22 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
4
votes
1answer
51 views

Is it a good practice to have 2 SQL Severs for a SharePoint site?

Is it a good practice to have 2 SQL Severs for a SharePoint site? If yes, can you recommend me link(s) for how to add it?
1
vote
1answer
545 views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
0
votes
1answer
26 views

A network-related or instance-specific error occurred while establishing a connection to SQL Server. when use sqlalias and try to connect sql server [closed]

i have an asp.net web application that connected to sql server 2012 from a server ( windows server 2012 R2) its a fresh installed server and installed oracle 32 bit client . its SharePoint wfe server. ...
0
votes
1answer
20 views

How to have Report Viewer Web Part for SP 2013 and SQL Reports 2008 R2

I am trying to display a SQL Reports 2008 R2 report in SharePoint 2013. I am confused because I can not find a web part for SharePoint 2013 that can display a SQL Server 2008 R2 Report. Am I ...
0
votes
1answer
796 views

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 ...
0
votes
0answers
13 views

Running SharePoint 2010 on SQL Server 2014 with Compatibility Level 110?

Can anyone confirm if it is supported to run SharePoint 2010 on SQL Server 2014 with Compatibility Level 110? Have seen SQL Server 2014 and SharePoint 2014 is not a supported combination, but not ...
1
vote
4answers
3k 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
3k 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 ...
1
vote
1answer
1k 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
1answer
10 views

How to rollback RBS and what happens to existing data

Let's say I am using Remote Blog Storage (RBS) in one of my content database and decide not to use anymore. How can I roll back RBS? What will happen to my data and how can I migrate it out of RBS? ...
1
vote
1answer
3k views

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

I am using Sp2013 Standard server, with 1 APP, 1 WFE, 1 Workflow and 1 Clustered SQL. Everything was all great until Monday Morning (7-28-14). Thats when Event Log started to fire off following ...
0
votes
1answer
30 views

Creating a list-backed SQL Server database without using External Content Types

I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only ...
1
vote
2answers
25 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
0
votes
1answer
23 views

Reporting Services not working

I have DC 1, SQL1 and SP1 in a 3 tier virtual environment. In SP1 I installed Reporting Services - SharePoint Integrated and Reporting Services Add-in for SharePoint. Once the install was done I ...
1
vote
0answers
33 views

“Missing documents” in RBS after restoring database

I'm assisting a client with a SharePoint migration, but have run into a situation with some of the document libraries. The SharePoint server was configured to use RBS via the native FileStream ...
1
vote
2answers
20 views

Multiple SQL databases in a farm

Is it recommended to have multiple SQL servers in a farm to host content databases or usually just one? sorry if this is a basic question but i am new to the SP architecture
0
votes
1answer
22 views

SQL server WSS_Logging fragmentation

We are running SP2013 on SQL Server 2014 (setup with a Available Group) and we use a tool called SQL spotlight to monitor the health of our SQL servers. It constantly complains that many of the ...
0
votes
0answers
11 views

SQL environments to a centralised environment

We are looking at moving our SQL environments to a centralized environment, with a single SQL installed and many DB instances on. Are there any problems that might arise? We currently have a separate ...
0
votes
1answer
36 views

Mount ContentDB

I am mounting a contentDB to a 2013 web application (upgrading from 2010). The contentDB size is around 2,5GB , the mounting process is stucked. I checked in the log and it is stucked here: ...
0
votes
0answers
10 views

SQL server 2012 SharePoint 2010

Can we use same SQL server for two farms of SharePoint 2010? Can I use different SQL instances on same SQL server for two different SharePoint farms? If I want to move from SQL 2008 R2 to SQL 2012 ...
1
vote
2answers
84 views

upgrading SharePoint 2010/2013 Databases from SQL Server 2008 R2 SP2 -> SP3

How can i confirm that upgrading SQL Server 2008 R2 SP2 to SP3 is safe to roll out.(Compatible?) Any resources or tips would be appreciated Thanks in Advance
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 ...
0
votes
1answer
63 views

Using SharePoint WSS_Content database to find permissions changes?

I've noticed there are a few tables that may be able to help me put together an "Audit Log" of sorts for permissions changes in our SharePoint site. However, I'm unsure of how to join up the tables ...
1
vote
2answers
64 views

Programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists

I need to programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists. By programatically I mean using a power shell, SQL query or even a webpart Libraries can be Asset ...
0
votes
2answers
44 views

Clone SharePoint VM containing SQL DB on different Box

I have a SharePoint 2010 Setup in a VM. And Content DB of central admin of this server, say "Server A" resides on "DB Server 1". Now i clone the VM and create another copy say "Server B". I changed ...
0
votes
0answers
14 views

Grab image type from SQL and display in SharePoint

I have SharePoint Foundation 2013. I have employee information (name, titles, dates, photo [image type]) in a SQL database. I want to be able to grab this employee data from the SQL table and ...
2
votes
5answers
115 views

Creating SQL Alias after configuring SharePoint 2013 farm

I am trying to configure sql alias in SharePoint farm. I have followed various articles about configuring it through cliconfg.exe and it looks fine. I have rebooted server and all the services. When ...
0
votes
2answers
59 views

Resolving permission error in sql for username domain\computerName$

I'm trying to resolve a permission error on our sharepoint sql server. The login for the user that has failed is the WFE computer name on the farm config db. What permission or role can I grant that ...
0
votes
1answer
28 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
0
votes
0answers
21 views

Token-based server access validation failed with an infrastructure error

I am having the following error notification from the database server DESCRIPTION:Login failed for user 'Domain\XYZ_Admin'. Reason: Token-based server access validation failed with an ...
5
votes
1answer
291 views

Sharepoint 2013 and SQL Server 2012 Service Pack 2

I've tried to research this, but I'm not seeing anything relevant to installing Service Pack 2 for SQL Server 2012. Our DBA's want to apply this to out SharePoint 2012 SQL Server, but I can't find ...
0
votes
0answers
40 views

RBS maintainance job Orphan cleanup not working

the problem are that Orphan cleanup won't start up. He starting up. chekcking pools and always stuck on 5 pool. And can delete other pool data. The command I'm runing: > C: cd "C:\Program ...
0
votes
0answers
20 views

Excessive DB Connections

Normally our SQL database has around 100-200 connections established to various webservers and application. Our DBA did a health check this week and this has jumped to 600-700 upon further ...
0
votes
1answer
323 views

What versions of SQL Server does Sharepoint 2010 and 2007 support?

We have two SharePoint environments - 2010 and 2007. We are looking to upgrade our SQL Cluster to SQL Server 2014 and are looking to see if 2010 and 2007 support it. I could not find any ...
0
votes
1answer
152 views

Changing sql server service and sql server agent service startup account in SQL Server hosting SharePoint DB

i have a sharepoint deployment with one SQL Server (running on VM) hosting the config DB and another SQL Server (Physical Host because VM was running out of space) to host the huge Content DBs. I need ...
0
votes
0answers
30 views

List on External Content Type ECT modify edit form

I have a SQL 2012 table that that publishes a list in sharepoint 2013. I have been able to create some custom filters on the display page and pass those back and forth to get most of the list to ...