.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to make Windows SharePoint Services use a preexisting database as the content database

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint
From the link below. I am trying to find in Central Administration the following:

  • Replace each instance of AdminVsAppPoolIdentity in the query with the account that is the SharePoint Central Administration virtual server application pool identity. This account is also the database owner (dbo) of the database.
  • Replace each instance of ContentVsAppPoolIdentity in the query with the account that is the content virtual server application pool identity.

  • http://support.microsoft.com/default.aspx/kb/888041

    Where do I find the AdminVsAppPoolIdentity and ContentVsAppPoolIdentity ??

    View Complete Post

    More Related Resource Links

    Windows SharePoint Services v3.0 Database Error

    Hi Below is the error from event viewer on the server based on the Above Event Type:     Error Event Source:  Windows SharePoint Services 3 Event Category:          Database Event ID:         3758 Date:               3/18/2009 Time:               4:38:40 PM User:                N/A Computer:       FIB-PORTAL Description: Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.   Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.   For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type:     Error Event Source:  MSSQL$OFFICESERVERS Event Category:          (2) Event ID:         1827 Date:               3/18/2009 Time:               4:38:40 PM User:                FIRSTINLAND\sharepointadmin Computer:       FIB-PORTAL Description: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.Any ideas on the Solution to the Above Issue...Best Regards,Adeoye...

    Full Farm Backup Fails on Windows Sharepoint Services Search Database

    I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

    Windows SharePoint Services 3.0 Application Template: Bug Database - can you customize the emails?

    My company is using a ms appliation template downloaded here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C72D23AF-F556-47AA-A6F2-0027246A9928&displaylang=en#RelatedLinks.  How can I change the emails that get sent when an application is assigned?

    Windows Live Small Business and SharePoint Services Back-End Database


    According to the Windows Live Small Business (WLSB) help content, there is a means to setup a survey that will allow you to use Sharepoint list data from the back-end of a WLSB web site to validate an entry from a front-end web site answer. If this is still possible, is there any current detail information that demonstrates a step by step approach to how it can be done. The usefullness of this solution would aid in web page development allowing for the developer to have a landing page in which a client or customer could fill out a survey, enter their client identification number, and then have the Sharepoint list data on the back-end validate the user's id so that if the id is not a valid pre-pitted id entry or storage of the survey entry could be declined.

    Do any of you have knowledge that you could share in order to solve this solution delima?

    MCITP-SA, MPN, CRCP, and WestconGroup Partner; http://oguninternationalmedia.com

    Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

    Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

    SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

    Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

    How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

    Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

    failed to create configuration database on Sharepoint 2010 beta install under Windows 7

    sharepoint configuration wizard at final step issued message as follows:

    failed to create the configuration database.

    an exception of type system.io.filenotfoundexception ws thrown.  additional exception informaion. could not load file or assemble 'microsoft.identity.model. version=,culture=neutral, publickeytoken=31bf3856ad364e35' or one of it's dependencies. the system cannot find the file specified.

    the only option was to 'finish' the wizard and exit without a successful install.

    can anyone help me with diagnosing this problem.

    i am running windows 7 on a dell machine and installed all the software requirements for sharepoint install. with the exception of a hotfix for sql server which when i followed the lin appeared to be updated to a more recently posted hotfix.  i downloaded this and installed successfully.


    "Fields and Content Types for the Windows SharePoint Services Application Templates"


    Installation of Server Admin "Fabulous 40" Templates -

    I saw a new feature appear after the templates were installed by our farm administrator. I didn't see anything in the documentation about it, but it seems like I should activate it.

    Should I activate the "Fields and Content Types for the Windows SharePoint Services Application Templates" feature?

    Are there any drawbacks?

    Any other words of wisdom?


    Unable to connect to the SQL content database from sharepoint web front server.



    SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

    SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

    when ever these errors occur in eventvwr sharepoint will not work.

    Please suggest on this issue.

    waiting for MS replies..






    Getting Started with Windows SharePoint Services

    Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

    Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

    Building a Searchable Phone Directory with Windows SharePoint Services

    I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

    New Features in Windows SharePoint Services 3.0

    Windows SharePoint Services 3.0 (WSS 3.0) is the next version of WSS 2.0, released on 2007, and Microsoft Office SharePoint Server 2007 (MOSS 2007) is built on top of this. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. WSS 3.0 offers a lot of new features and programmability support. I have consolidated a list of new features and enhancements in the below section:

    Reading and Writing Images From a Windows Mobile Database using UltraLite 10(C#)

    Periodically I get a request for information on how to read and write binary data to a database running on Windows Mobile. If you search the Internet you can typically find examples that are available on Windows Desktops or allow you to read and write to a local file system. The problem is that it can take a bit of work to get this code to work on Windows Mobile accessing a database.

    Ultimately you might be asking, why would I want to store and image in a database? Well in an environment where you synchronizing data between a local mobile database and a consolidated (central) database this can be extremely useful. Imagine if an insurance adjuster went to an accident scene, took a picture of a damaged car, loaded it into his Windows Mobile database and then replicated that image up to the Insurance headquarters for approval. All of this could be done in a very short period of time when using images in the database. Another good example might be a doctor who was waiting for a patient chart to become available. If you could store the image in a database this chart could be sent down to the doctor's device once it became available.

    For this article I am not going to get into how to synchronize the images to and from a remote and central database as this is typically fairly straightforward when using a data synchronization technologies like MobiLink

    Unable to make connection to database?


    Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

    I have database called PhoneDirectory.

    It have only one table named Residents.

    I have button wiht ID="Button1".

    I want when i click this button to see all of my residents. 

    I want to see the result in DetailsView and to be able to edin, delete and add new resident.

    First try with SqlDataSource so i wrote this:

    <asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
                  SelectCommand = "SELECT * FROM Resident "

    Data Points: Windows Azure Table Storage - Not Your Father's Database


    Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

    Julie Lerman

    MSDN Magazine July 2010

    SQL Data Services: The Relational Database of the Azure Services Platform


    This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.

    David Robinson

    MSDN Magazine August 2009

    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend