SQL Server is a relational database server used in SharePoint
0
votes
2answers
52 views
Inserting new list items into SQL
When I add new item into the list, I have to insert the items into the SQL database. How can I do it? Any clue is good for me.
0
votes
1answer
22 views
Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”
My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition
WF1
WF2
Both Web Fronts are NLB, and we have they following Application Servers
APP1 - ...
0
votes
0answers
21 views
SQL connection string doesn't work
I made the Oracle connection string work for another project.Now for another project I want to make a connection string for SQL. In my BDC VS Project
Data Source=.....;Database=....;Initial ...
1
vote
2answers
37 views
Workflows and SQL Server Databases
Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint?
Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
1answer
60 views
There are no SQL Server instances or shared features that can be updated on this computer
I am trying to install SQL server 2008 r2 on Windows server 2008 r2, I have the SQL server installed in an ISO image and the windows server is on a VM workstation, but during the installation I got ...
1
vote
0answers
24 views
Which installation option I should use for SQL server 2008 to work with SharePoint 2013
I want to prepare a development environment for SharePoint 2013, so I want to know which SQL server option I should use from the SQL server 2008 installation center , the available options are:-
1.New ...
1
vote
1answer
497 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. ...
0
votes
0answers
21 views
instalation media for sql server 2008 r2 to be used with sharepoint 2013
I want to install an SQL server r2 2008 from and ISO imagE to my VM windows server 2008. but when i try to create a new NON-CLUSTERED SQL server i was asked to specify the installation media for SQL ...
0
votes
5answers
45 views
Sharepoint 2010 products configuration wizard giving error
Small disclaimer: I am a n00b at Sharepoint. I am actually a developer and have just been given Sharepoint platform saying that I have to get it running properly =/ Have had no training, all my ...
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
16 views
wss 3.0 content database has expanded exponentially without any data added in it
I am hosting wss 3.0 web application in windows 2003 server with sql 2005 express edition. we are leveraging lots of out of the box functionality, but we also have some custom features and web parts. ...
0
votes
0answers
22 views
Deploying SSRS report from BIDS to SharePoint 2010
I am having an issue deploying a report from BIDS to a SharePoint Integrated Report Services Server. I have set up SSRS and everything is successful from the configuration wizard, I am using a Domain ...
0
votes
0answers
51 views
Difference between Power View for SharePoint 2010 and SharePoint 2013
Is there a difference between Power View (from SQL 2012 SP1) for SharePoint 2010 and for SharePoint 2013? Or do they have identical features?
What I'm asking is, do I gain any Power View specific ...
0
votes
1answer
12 views
SharePoint 2010: How to determine in what mode SQL Server Reporting Services is installed
SharePoint 2010 Standard farm.
How can I determine in what mode the SQL Server Reporting Services is installed?
When installing SQL Server Reporting Services (SSRS), you must choose the mode in ...
0
votes
0answers
131 views
SQL Server Reporting Services: The remote server returned an error: (500) Internal Server Error
I'm running a SharePoint 2010 Standard farm. I have 2 Web Front-end Servers, an application server running SSRS and 2 Database servers.
SSRS is installed using the Microsoft SQL Server 2012 RS Add-In ...
0
votes
1answer
35 views
Development with SQL Data Source in Visual Studio
There is a sql database. I want to get datas and display them as a list. And I want to filter the datas too. But I can't find any basic tutorial to do it. I don't know where to begin. Where should I ...
0
votes
1answer
70 views
SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2
I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message -
...
0
votes
0answers
8 views
Find Data for Microsoft Project in SharePoint enterprise
Goal:
To view the table's data of the database for Microsoft Project from SharePoint 2010 and/or 2013 enterprise.
Problem:
Where can I find the raw data for Microsoft Project in the database? I would ...
1
vote
1answer
42 views
SQL Log file repeating error :error code 0x6fd
SQL Server 2008 R2
Currently the log folder is taking upto 109GB's of space!
It keeps repeating the following error:
“An exception occurred while enqueueing a message in the target queue.
...
0
votes
0answers
12 views
Apps for office Storing OOXML templates
This is my first try in writing an app for office. I want to have a task Pane app for office that would access a database in which OOXML parts will be stored. The user would typically enter some ...
1
vote
1answer
27 views
Change SQL Server service account
I need to change the Service Account for Sql Server (i.e. I need SQL Server to run under a different account). Can I just change the account or do I need to perform some Sharepoint configuration as ...
2
votes
2answers
573 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 ...
0
votes
0answers
65 views
RBS with SharePoint 2010 and SQL Express 2008 / 2012.
My client has about 100GB of files loaded on a File Server. Initially the plan was to upload everything to SharePoint and bring everything under one hood.
They have SharePoint Foundation 2010 and SQL ...
0
votes
0answers
39 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 ...
0
votes
0answers
25 views
Upgrading default SQL server express of SharePoint 2010 for reporting services
I need to upgrade default SQL server express of SharePoint 2010 with SQL Server 2008 Express with Advanced Services. What are the things I should keep in mind before upgrading?
Thanking you in ...
0
votes
1answer
102 views
Databases for Sharepoint Foundation 2013
I recently installed Sharepoint 2013 onto a test server to look at the possibilities of upgrading our 2010 instance. After the installation, I noticed that far more DBs were created on my SQL Server. ...
0
votes
0answers
36 views
Can't start configuration database service
TL;DR: I can't start the SQL Server service that my content database is on.
I installed SharePoint Foundation 2010 on a Win7 box a while back. About a year ago I disabled some services (in ...
3
votes
0answers
72 views
Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm
I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups.
Essentially we're running ...
0
votes
0answers
25 views
Problem in Invoking SQL Server Reporting Services by SharePoint Timer Job
I'm facing some problem with the Render of some Reports during my SharePoint Timer Job. The same code running in a Console Application works correctly but in SharePoint Timer job stops working without ...
0
votes
1answer
29 views
How to backup specific ListItems to database?
We are running a ticketsystem on Sharepoint 2010 which got alarmingly large over the last few months. The ListView Threshhold currently sits at 15k for this WebApplication.
I am currently looking for ...
0
votes
0answers
35 views
After shrink the error still occurs
When I try to save the aspx page an error occures. It says "....It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web".
At SQL Server Man. ...
0
votes
1answer
249 views
InvalidOperationException after promoting SharePoint server to domain controller
I installed SharePoint 2013 Standard on Windows Server 2012, and it was running fine until I decided to make the server a domain controller:
Remove the ADCS role
Remove then re-add the ADDS role ...
0
votes
1answer
363 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
1answer
41 views
Document storage in sharepoint
By default, Sharepoint stores the documents in Sql Server. It may give performance issue if we have large files(say 1 TB).
So, how do we overcome this or do we have any other way of storing ...
0
votes
2answers
588 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
2answers
71 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 ...
1
vote
1answer
43 views
Sharepoint 2010 - Delete Picture Library
I had picture library on Sharepoint with 500MB of images. I have deleted it from site and farm level also. But data still rely on SQL DB. I have daily backups on server. Before uploading images daily ...
0
votes
1answer
91 views
User Profile Synchronisation from SQL Database
I am trying to update the Manager and Profile Picture properties for the UPS from SQL. The problem is that these two fields are stored as text in SQL but SharePoint expects a Person field and URL ...
4
votes
4answers
6k 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 ...
1
vote
1answer
37 views
Sharepoint 2010 multilingual support and SQL Server 2008 Collation
I am wondering when I install my respective SQL Server 2008 R2 database for Sharepoint if I will need to set the collation to anything specific to support Sharepoint's multilingual capabilities?
0
votes
1answer
88 views
Connect SQL Server installed local machine with Sharepoint VM
I need to install SharePoint (Farm based installation) on VM and I have installed SQL Server 2008 R2 on my local machine.
How can I connect both the machines so that I can use sql instance settings ...
0
votes
1answer
157 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
3answers
92 views
Installation of SQL database on local machine as opposed to Virtual machine
I have configured Virtual machine to install Sharepoint 2010. The virtual machine is configured as;
a. OS: Windows Server 2008
b. Active Directory Configured (Domain Name as "DOMAINNAME" is ...
0
votes
1answer
194 views
SharePoint 2010 - Force to use non-1433 SQL Port
In my farm, I was using the standard 1433 port for SharePoint to communicate with SQL. Our project lead came down with the order to change the SQL port to a non-standard port from 1433.
I went ...
0
votes
1answer
39 views
Auto-Update Statics On/Off
MS recommends disabling auto-create statistics on SP DBs (ref).
What about auto-update statistics?
Looking at our TFS installation, for the SP DBs, these two options are disabled for you when TFS is ...
1
vote
2answers
427 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 ...
0
votes
1answer
38 views
list updation in list loadvent
I have a custom list that contains a row of data. The data in the list is created from the data in the table in the SQL table. I need to check the data in database table and the data in the list is ...
1
vote
0answers
81 views
BCS connection with SQL DB and Sharepoint list passing parameters
Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...
1
vote
2answers
1k 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 ...
3
votes
1answer
43 views
SP2010: What happens when starting several Content deployment jobs at the same time?
what happens if I start several content deployment jobs synchronously in different site collections by ContentDeploymentJob.Run()? Are the jobs definitely executed one after another?
Thanks!
