A usually large collection of data organized especially for rapid search and retrieval (as by a computer).
1
vote
2answers
36 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. ...
1
vote
0answers
20 views
What is a SPPersistedUpgradableObject and the IUpgradable interface mean?
SPPersistedUpgradableObject is a SPPersistedObject that implements the IUpgradable interface. The MSDN is seriously lacks any documentation other than it:
Provides members for managing an ...
1
vote
2answers
75 views
IBM DB2 database connect to Sharepoint
We have an IBM DB2 database which stores our documents as BLOBS in binary format.
I've read about Remote Blob Storage(RBS) and FILESTREAM but I'm still puzzled if its possible to hook up our IBM DB2 ...
0
votes
0answers
64 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
1answer
101 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
45 views
The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'
Our organisation is upgrading from SP2010 + PWA to SP2013.
Having followed the process detailed on TechNet (http://technet.microsoft.com/en-us/library/ee662104.aspx), the test-spprojectdatabase ...
0
votes
2answers
85 views
Databases require upgrade or not supported
My search stopped automatically crawling on Feb 28. I can still start it manually and it works but it doesn't work automatically.
When I went to Central Administration, I saw the following error:
...
0
votes
1answer
105 views
Sharepoint site stopped working. Database “needs upgrading”. Upgrade fails
One of my Sharepoint 2010 Site Collections has stopped functioning this morning and presents the following in the browser.
Server error: http://go.microsoft.com/fwlink?LinkID=177673
When I look ...
0
votes
2answers
68 views
How to force standalone install?
On out-of-the-box Windows Server 2012, I installed SharePoint 2013. I was not asked any database question, and SharePoint was working fine.
Then I made the server a domain controller and decided to ...
1
vote
0answers
22 views
Editing a Dataview from a joined list
I think I want to do something simple, but it seems maybe I am not doing it the way you are supposed to.
I need to use Sharepoint Designer 2007 to create a website, code behind is highly likely to be ...
0
votes
0answers
33 views
Customising parameters in SqlDataSource
I am very new to Sharepoint and ASP and all of this so I suspect my question is really simple but I am confused.
I am using Sharepoint Designer 2007 and am not allowed to use code behind. The task ...
6
votes
3answers
232 views
“SharePoint is not a database!” article of 2009 - does it still apply for SP 2010 and 2013?
I'm talking about this blog post by Chris Woodill.
He mentions the following advantages of modeling data via SQL programming instead of SharePoint's lists:
Primary And foreign keys: one of the most ...
0
votes
1answer
31 views
Implementing a Custom ASPX Page That Uses a Custom Database
I know how to create custom ASPX pages and a deployment package, but I need to implement a custom ASPX page in SharePoint 2010 which uses its own custom database.
Please advise me how to do this.
2
votes
1answer
76 views
Access Database-linked forms not working after Server Reboot
Our server went down & when I rebooted, all is working on site except Access Database-linked forms are not working.
It is showing following error:
> Preparing Site ... Someone has recently ...
0
votes
0answers
83 views
Database Attach Upgrade - Warnings and Errors
After running the database attach upgrade and getting the site collection running. SharePoint is advising about some problems.
1- Databases running in compatibility range, upgrade recommended.
The ...
1
vote
2answers
103 views
error when start new project in visual studio 2010
I am a new administrator to a SharePoint farm and I want to start developing *web-part*s for our sites.
In our company we have installed SharePoint 2010 on Windows Server 2008 R2.
And we have ...
1
vote
2answers
115 views
SharePoint Data Modelling Tool
I plan to develop a data model for a SharePoint application that we would like to bid out for development. Is there a data modelling tool that is preferred to be used with SharePoint, like it can ...
2
votes
2answers
3k views
Move database to new SQL Server
My client has asked me to move all the Database used by the SharePoint Farm to a new SQL Server Machine. I came across this article ...
0
votes
1answer
248 views
how to add data connections in infopath codebehind
I'm trying to add multiple data connections to an infopath form in the codebehind. I see that I can connect to a db file , but not straight to sql server. Is this possible?
Thanks,
0
votes
1answer
404 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 ...
1
vote
1answer
136 views
different users, one access web database, permissions
I want to create a Sharepoint site and want to publish an Access web database on it. I want to know is there a way to give different permissions to Sharepoint site users? Some users have just read ...
0
votes
1answer
54 views
Problem with setting Farm Account
I am currently trying to setup a farm for my fresh sharepoint installation (before i run the configuration wizard) and set a local account for the farm admin. I ran this cmd using sharepoint ...
0
votes
0answers
73 views
Tempdb activity causing IO problem on virtual Sharepoint installation
My problem is performance and I suspect an IO problem with TempDB.
I have a sharepoint 2010 installation that is running on 3 VMs; App tier + web, search, database. Database storage is being provided ...
0
votes
1answer
322 views
How to stop SQL time out issue
I keep getting "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 9 out of 10 times when I try to ...
1
vote
2answers
787 views
accessing database through sharepoint using a service account (windows account)
I am having an issue with connecting to the database for KHouse through sharepoint.
I have run through several workarounds to get it to work, but to no avail.
We are using several pages that retrieve ...
0
votes
1answer
156 views
Migrate Excel Docs from Shared Drive to Sharepoint Foundation 2010?
I have a fairly large shared drive with various files that need to be migrated over to SharePoint.
I only have full control of my site, which is a subsite within the hierarchy.
I feel like if I were ...
1
vote
2answers
3k views
Moving the Sharepoint 2010 configuration Database to a new DB server..?
We were using the database server "OldDBServer" and have copied all the databases on the new database server "NewDBServer". Now, all the reference (like CA admin content DB, content DBs & Service ...
-1
votes
2answers
65 views
SharePoint Database and Content Versioning [closed]
We're starting to work on a SharePoint project on the company I work and we're currently analysing the best versioning tool to work with that.
We really needed to do a "real" version control on this ...
5
votes
3answers
762 views
Integrating an external database into Sharepoint
One of my current projects involves integrating a client's database into an overall CRM system design.
Part of the process was updating their legacy database and porting it over to SQL Server. ...
0
votes
2answers
167 views
How Can I create simple database in list Sharepoint Fundation?
How I can create simple database for example vacation request in SP list? It will looks like that: I create probably two list. In first list is vacation days people and on the second list is vacation ...
1
vote
2answers
82 views
How to create sites taking values from database
In one interview, interviewer asked this question.
I have one table in sql server database which contains the Title and its id(int).
Now I want to retrieve those values from database and based on the ...
0
votes
1answer
448 views
Site usage report from Database
I have a SP 2007 site where site usage is enabled and I can check the usage for last thirty days. I wanted the usage details for last 6 months for which I went to SharePoint Designer but my SPD is ...
1
vote
1answer
614 views
New-SPconfigurationDatabase: Invalid Address on single SP2010 install
Can anyone please help me with this as I'm sure im missing something small.
I am installing SP2010 on a Win7 Prof machine. All components on one machine. SQL2008R2 installed and all the features are ...
0
votes
0answers
118 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
105 views
Empty tables in WSS 3.0 configuration database
I've been looking through the configuration database of our WSS 3.0 installation and I've noticed that the Databases, Servers, Sites, and VirtualServers tables are completely empty. And yet the site ...
0
votes
0answers
265 views
Insufficient SQL database permissions for user “”
I'm working with SharePoint 2007 and when I start the search service I keep getting the following error:
Insufficient SQL database permissions for user '' in database Test_ConfigDB on SQL Server ...
0
votes
1answer
797 views
Restore User Profile Data to another farm
I've been setting up a test farm for a customer where I'll be looking to restore the UPSA databases from production, mainly the profile one, there isn't too much else I'm interested in other than ...
3
votes
2answers
562 views
How does SharePoint store versions of customised pages?
While a page is uncustomised (previously known as unghosted) it is stored on the file system, however once it is customised (previously known as ghosting) it is copied to the DB. Source 1 and Source 2
...
1
vote
3answers
3k views
How to Connect to SQL database using Sharepoint 2010/Office 365
How do you get into the Central administration page and create a secure store application ID?
I am trying to connect to an external database and cannot do so with my current credentials. I have a ...
0
votes
0answers
180 views
Updating MOSS list with MS Access- Object is read-only
I have a user who needs to update a large (39,000 items) MOSS list from MS Access 2007. The list is a simple one, created by publishing a query from Access to MOSS, now needs to be updated weekly. The ...
2
votes
1answer
86 views
Storage Location of Installed Features
Are features installed on a site stored in any of the databases?
I know the assemblies installed to the GAC from a .wsp are not, however are the features themselves stored in a database?
2
votes
3answers
3k views
Move databases to another server
I have tried moving all databases to another server, but I forgot to change the default database server in Central Administration.
From Googling it, I found out that stsadm or psconfig could help me ...
0
votes
2answers
168 views
Does anyone know which database table Job Titles are stored in on WSS 3.0?
I need to edit the job titles of users in an installation of WSS 3.0. There doesn't seem to be an easy way of doing this as an administrator. Users can edit their own details via the ...
0
votes
0answers
215 views
How to change the database server in SharePoint server 2010?
I have SharePoint Server 2010 installed on Server A (all the roles are on the same machine),and now
I need to add a new server B which must be the new database server, so I need to move all the ...
1
vote
2answers
192 views
Need to access a database…what is the best/proper/recommended way
Here is the setup. I have a SQL Server database that i need to query. I want to display the information in a Telerik/Devexpress chart control on either an application or site page.
Here is what i ...
1
vote
1answer
97 views
SP2010: Is modifying of admin content DB stored procedure permissionssions allowed?
I'm having a problem in production environment with help pages. Basically the problem is that the application pool account for some reason does not have permissions to run the required stored ...
1
vote
1answer
1k views
WSS_Logging database size
Our sharepoint server 2010 WSS_Logging database is about 100GB and counting ...
(Farm DB ~1TB / ~100 000 pages viewed per day / ~5000 unique users per days)
I've reduced
retention and logging ...
3
votes
3answers
2k views
Enormous database log files - Why are they not being truncated after a SharePoint backup runs?
I've performed a full Farm backup and also a full Site Collection backup using Central Administration site but there are still several enormous database log files
4GB - SharePoint_AdminContent
53GB ...
-1
votes
2answers
508 views
Using linq to get aggregated total of distinct values from csv items in datatable
I am going to use linq to get datapoints for chart created in sharepoint from datatable
this is datatable with 2 columns "task" and "users"
task users
task 1 john
task 2 mike, ...
0
votes
1answer
155 views
Sharepoint 2010 - database reconfiguration after failure
We had major database crash and our master database got broken. Probably it will be rebuild so then we will have to configure logins and user mappings for sharepoint databases. Is there some kind of ...
