A usually large collection of data organized especially for rapid search and retrieval (as by a computer).

learn more… | top users | synonyms

2
votes
2answers
7k 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 ...
1
vote
1answer
482 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
750 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
357 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
59 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
1answer
1k 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 ...
2
votes
2answers
2k 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
202 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
3answers
6k 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 ...
5
votes
3answers
1k 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
207 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
85 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
695 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
2answers
1k 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
1answer
157 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
388 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
1k 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
1k 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
4k 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 ...
2
votes
1answer
110 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
4k 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
206 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
344 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
234 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
117 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
2k 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
3k 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
694 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
193 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 ...
0
votes
1answer
55 views

Renaming SP2010 Service Application DBs

Does anyone have any experience of renaming the SP2010 Service Application Databases. They were created and I don't recall an option to manually name them (as you can with Content DBs). They are in ...
0
votes
0answers
241 views

Linq Data Context - connect from web part as application pool identity

I have an assembly with linq to sql mappings and I'd like to utilize it in my webpart. But when I try following: DataList dataList = new DataList(); dataList.DataSource = DB.Foo; ...
2
votes
2answers
123 views

Get default db instance

I'm writing web service which will be part of my sharepoint solution. This service will save and read some data from custom db which will reside on the same mssql instance as sharepoint. I'd like my ...
0
votes
1answer
47 views

Additional databse - best practices

Our system needs to synchronize data with external systems by web services. We want additional database to keep needed data and then be able to access it. I wonder how to resolve issue with database ...
4
votes
2answers
10k views

Central Administration cannot connect to configuration database

I made a script for batch uploading files, which I successfully used to upload more than 900 files (few gigs of data). Today I prepared another set of files and everything was working fine, but ...
1
vote
2answers
461 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...
3
votes
1answer
3k views

How to know the GUID of a Database?

I follow this step by step http://technet.microsoft.com/en-us/library/ff681014.aspx for reset the User Profile Synchronization Service but I need the GUID of the synchronization database. I searched a ...
0
votes
1answer
183 views

Attach restored content DB to same web application

I have an issue with a customer DB with it being corrupted. This has been the case for a while and hence no way to revert to a backup because all the backups have the corruption as well. I am however ...
5
votes
2answers
231 views

How to move SQL user database to SharePoint?

I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc. Is this possible ...
0
votes
3answers
6k views

SharePoint 2010 - Database Schema

I´m searching for informations about the SharePoint 2010 Database. Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn ...
0
votes
2answers
2k views

How should I set up my database instances for multiple SP2010 installs?

I'm setting up three SharePoint instances. We have a single database instance (DB\SP2010) that will hold all the databases for these three SP instances. Will this be overly confusing? Is there some ...
1
vote
3answers
570 views

Rename database pointer in SharePoint 2010

I've run into a problem regarding the naming of the database server on our SharePoint 2010 installation. I've used the FQDN, where it's best pratice to use the NETBIOS name of the SQL server ...
5
votes
1answer
422 views

How to corrupt content database?

I am working on a solution using which Site Admins can check and repair corrupt DB. I need sample corrupt DB for testing. Any ideas how to corrupt content database?
1
vote
3answers
231 views

What are the implications of using a shared/default SQL Server instance vs a dedicated/named one for SP2010 DB Role?

I have a database server that hosts multiple minor databases not related to SharePoint and I want to utilize this server for a SP2010 environment database role. What are the implications of ...
1
vote
2answers
2k views

Sample/Demo Database for SharePoint 2010

I'm looking for a sample/demo database for SharePoint 2010 in order to be able to demo SharePoint. Does anyone know of such a thing? Ideally it should have already created and populated lists and ...
11
votes
3answers
3k views

How to split a Content Database within site

I have a very large content database & need to split it. Is it possible to split a content database within a site collection? or I need to create a new site collection?
1
vote
2answers
1k views

Database Attache Upgrade Fail?

I ran the mount-spcontentdatabase and it failed. The test-SPContent Database didn't produce anything in the log that would fail the upgrade. Also, the error report didn't have anything that would ...
0
votes
1answer
189 views

SilverLight webpart reading data from a external server through sharepoint

Let's hope i'll be clear enough. Ok. I have a request to create a silverlight webpart, that'll be 'fed' with data that comes from a third server. This external server can't (security issues) be ...
0
votes
2answers
2k views

Is it possible to migrate and attach a wss 3.0 configuration database to a new Foundation 2010 front-end?

We are preparing to migrate from WSS 3.0 to 2010. WSS is currently on a x86 operating system, so migrating to a x64 operating system will be involved as well. My co-worker's thought is to turn up a ...
5
votes
2answers
993 views

The Search Service Application crawl DB default has grown to 60GB

Our Search Service Application was installed but never configured with rules. Our default Search Service Application Crawl DB has grown to 60GB. We attempted to create a new Crawl Database and ...
0
votes
2answers
231 views

SharePoint 2010 Install test.. changing mind on service accounts and undoing Wizard created services/dbs?

We have a new 2010 Environment. Ran through quick on our install.. with the likely intention of having to do it again anyways. To keep thing simple, only have two service accounts. The farm admin ...