SQL Server is a relational database server used in SharePoint
1
vote
2answers
70 views
How can i retreive data from Web Server to my Intranet SP site
Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site
...
0
votes
1answer
213 views
Cannot install SQL Server (2012) PowerPivot for SharePoint, always fails Sharepoint Version check
Trying to install a fresh install of Sharepoint 2010 (w/ SP1) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint.
The prerequisites clearly show that Sharepoint 2010 SP1 is needed, ...
2
votes
1answer
224 views
Problem with PowerShell script in Tasks Sheduler Windows Server 2008 R2 - SharePoint Shell Access?
I have a problem with PowerShell script in Tasks Sheduler in Windows Server 2008 R2. I try to run Sheduler Tasks which run batch file which run PowerShell script to Backup Farm and while I choose "Run ...
0
votes
0answers
54 views
SharePoint 2010 Access Service Account not automatically added to content DB
We've configured Access Services for SharePoint 2010. When we go to use it with a contact site template, the site installs and loads, but we get a red X "An Error has occrurred".
When I look on the ...
0
votes
1answer
398 views
How to Create Analysis service Data Source for SharePoint Dashboard designer?
We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source.
So can anyone ...
0
votes
1answer
145 views
Does the membership seeder tool to add new FBA users, use the createuser method?
Does the membership seeder tool to add new FBA users, use the createuser method?
Here is the link from where I downloaded it:
http://cks.codeplex.com/releases/view/7450
0
votes
1answer
281 views
InfoPath 2010: Populating drowdown from SQL on load form
I have a data connection to SQL database already set and for the form to query the database on form load. In the dropdown list property I have it pulling from an external data source and in the ...
1
vote
2answers
413 views
Cloning a SharePoint Server 2010 (Virtual Machine) production box?
Here is the long and short:
Goal: To clone a SharepointProd VM retaining all the webapps and sites in order to debug a custom solution.
We have two virtual machines: spTest and spProd. spTest is ...
0
votes
0answers
211 views
SharePoint and SRSS integration using SQL Server 2012
I am trying to integrate my SSRS database (SQL Server 2012) with SharePoint. I followed this site: http://msdn.microsoft.com/library/gg492276(SQL.110).aspx#bkmk_create_serrviceapplication
I go to ...
0
votes
2answers
57 views
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 ...
0
votes
2answers
232 views
Migrate Sharepoint 2007 to 2010
So right now there's a SharePoint 2007 site filled with data. I have to migrate EVERYTHING properly from the SharePoint 2007 site to a new server that has SharePoint 2010 and Windows Server 2008 ...
1
vote
1answer
70 views
SQL Server 2008 Installation on SP 2010
I'm installing SP 2010 on Virtual Machine Windows Server 2008 R2. My Question: Is it necessary to install SQL Server 2008 (or R2) before installing Sharepoint Server 2010?
Plus, when installing SQL ...
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 ...
1
vote
1answer
284 views
DispForm.aspx taking 5+ minutes to load on SP2010 Server, high CPU utilization
We have one list that has about 55 columns. Most of these are very simple columns (number, text, choice), though there are four that are Lookups to another list. All four lookups columns lookup ...
0
votes
0answers
54 views
Web Services and InfoPath - Advance Troubleshooting
I am experiencing a problem with InfoPath 2010 when when querying for information retrieved by a web service.
When ever creating a new form from scratch, setting up our data connections and ...
0
votes
0answers
95 views
SharePoint 2010 Multi Tenancy content database SQL server issues
We have 2 SharePoint 2010 multi tenancy environments, both using the one SQL server instance.
Server 1: SharePoint Foundation
Server 2: SharePoint Standard
Server 3: SQL Server
We used the ...
0
votes
1answer
25 views
Upgrading from SQL 2005 to SQL 2008R2 with RBS support
I am looking at setting up Sharepoint 2010 in our local test environment and our current test SQL server is running SQL 2005. I am just wondering if it is possible to upgrade the database later to SQL ...
0
votes
1answer
187 views
Attaching and restoring document library files from a .mdf config database file?
We have a Symantec backup system that runs through all of the instances on a SQL2008 box and backsup data,
I would like to restore a corrupted document library and am wondering as to how I would ...
0
votes
0answers
101 views
BCS Model with primary key consisting of multiple columns
We have a database with a table that has a primary key that consists 4 columns.
I want to show the table data in SharePoint by using BCS.
A created a new BDC Model in Visual Studio, but has no idea ...
0
votes
0answers
61 views
Can OLAP Cube CustomData be used in conjunction with a custom Membership provider on Sharepoint
What I'm trying to do is expose access to an OLAP cube using Excel Services. From what I've read, we're comfortable with getting this in place providing that it uses Active Directory for ...
0
votes
3answers
1k views
Populate Data From SharePoint List to a SQL Table
Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that ...
2
votes
1answer
234 views
File size too large with RBS and SharePoint 2013
since i set up my SP2013 Foundation Preview with SQL Server 2008 R2 Express i wanted to use the RemoteBlobStorage. It works seemingly fine just now.
The only problem is if my files which im uploading ...
0
votes
1answer
357 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
2answers
50 views
Backing up all sharepoint web applications?
I have a sharepoint farm hooked to a named instance of SQL2008.
I have a web application (it is also extended to another web app) that I would like to back up.
Here is what I am trying to achieve:
I ...
0
votes
1answer
226 views
Event Receiver Item Added for Multiple Files uploaded
I am trying to add few details for a item that is added to a list to SQL database table using a stored procedure, it works perfectly but when I upload multiple files it adds all of the items into the ...
-1
votes
1answer
40 views
powerpivot configration
i installed sql server 2008 and SharePoint 2010 and finished the installation of the pivot but when i clicked start - 1 all programs -sql server 2008 - configuration tools -
(but the only thing exist ...
1
vote
1answer
635 views
What benefits do I get by upgrading to SQL Server 2012 Enterprise?
With SharePoint Server 2010 Enterprise edition, what additional benefits do I get using SQL Server 2012 Enterprise edition as opposed to SQL Server 2008 R2 Enterprise edition?
0
votes
2answers
50 views
SQL Server 2008 Install / Data Location
Am about to try and install SQL Server 2008 R2 for the second time. How and when during an install can I configure my data to be held on the D:/ drive as opposed to the default C:/ drive?
0
votes
2answers
569 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
1answer
392 views
Change SQL Server Port for existing SharePoint 2010 environment - Howto
I have a SharePoint 2010 environment configured with SQL Server 2008R2. Currently SQL Server is running on 1433. I am willing to change the existing SQL server port from 1433 to some non standard ...
0
votes
0answers
257 views
Passing parameters to stored procedure in data view web part
I have a stored procedure which accepts 2 parameters. The stored proc is executed as
EXEC MySP N'Val1, Val2', N'A,B,C'
I inserted a Data View Web-Part and tried to get data from stored procedure. ...
2
votes
2answers
454 views
Should I regularly backup and shrink my content databases through SQL?
I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help.
Should I be regularly ...
1
vote
1answer
60 views
Add a server to SharePoint Admin user?
I need to add one of our production servers (that hosts SQL Server 2008) let's say XXX to SharePoint Admin in SharePoint 2010. How can I do that?
I agree that a server is not a user or a group. Let ...
1
vote
2answers
867 views
Connection to external data source using windows authentication (NTLM)
I'm trying to connect to an external SQL server DB programmatically from a SharePoint WebPart. The problem is that I'm not able to authenticate to the DB although I gave access to application pool ...
6
votes
5answers
165 views
Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?
I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
2
votes
1answer
2k views
Create reports from SharePoint lists
We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
0
votes
0answers
116 views
When using a SQL database connection with stored procedures is it possible to use an output parameter
I'm kind of new to attempting this sort of thing and I have some unique restrictions, so please bear with me.
I am attempting to connect to data in a SQL database through stored procedures in my ...
0
votes
1answer
253 views
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 ...
1
vote
2answers
495 views
Move database without creating alias
when we started with Sharepoint we installed everything on a sqlserver that was used for non-sharepoint activities to. Now however we decided to seperate those from each other. Management decided that ...
0
votes
1answer
275 views
Remote BLOB Storage Filestream Issue
I had to enable Remote Blob Storage on my farm. I'm following this tutorial:
http://technet.microsoft.com/en-us/library/ee663474.aspx#enable
And also this one:
...
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 ...
0
votes
0answers
165 views
How create an infopath form for sharepoint that receive and submit data to sql server database?
I want to create an infopath form for sharepoint, this form will submit and receive data from SQL Server Database.
What I've done this far:
I've created an infopath form with data source from sql ...
2
votes
1answer
463 views
Two Server Sharepoint Farm Topology
I'm working on creating a product for Sharepoint and have set up a server farm consisting of two machines running Server 2008 R2.
I want to set up SQL2008 on one Machine, and SharePoint 2010 on the ...
3
votes
1answer
167 views
Remote BLOB Storage and Sharepoint 2010
I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change.
Should I use the ...
0
votes
2answers
1k views
Cannot connect to the configuration database
I don't really know what to do. I was trying to get some bcs working, and because they were not, I've decided to restart the server.
After it restarted I was unable to go on any site / page or on the ...
2
votes
2answers
441 views
Migrating Windows Sharepoint Services 3.0 from Windows 2003 x86 / MSEE to Windows 2008 R2 x64 / SQL Server 2008
I am having a helluva time with this one.
I am attempting to migrate a 5 year old VM running Windows 2003 Windows Sharepoint Services 3.0 that was deployed as a standalone (thus to MSEE) to a ...
0
votes
1answer
321 views
View SQL data from CRM into Sharepoint 2010 BCS failing
I'm trying to view CRM Customer data from the SQL database in SharePoint so that I can use it in surveys etc.
I followed these instructions (amongst others) ...
1
vote
1answer
1k views
How can I tell SP installation of an existing SQL server
I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same ...
1
vote
2answers
592 views
Installing SSRS on the Sharepoint Box as opposed to the SQL Box?
We currently have two SQl boxes (2008 R2) with multiple instances on them. One for test and the other for production databases.
We also have two sharepoint servers (2010 Enterprise). One in the DMZ ...
0
votes
1answer
241 views
Migrate Access to SQL Server for SharePoint Integration & Reporting
I'm hoping to get some feedback on this multi-parted problem. The end goal with this problem is to create reports within SharePoint from data contained in some db.
Currently, an Excel report exists ...
