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

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

Creating and configuring a Web Application with pre-created content database

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint

I recently looked at the very interesting Technet article named "Deploy by using DBA-created databases (SharePoint 2010)"; I've noticed something strange in the following section:

To create and configure the portal site Web application

  1. [DBA] Create the portal site Web application content database using the LATIN1_General_CI_AS_KS_WS collation sequence and set the database owner (dbo) to be the Setup user account.

  2. [DBA] Using SQL ServerManagement Studio, add the service application service account to the Users group and then to the db_owner role for the portal site Web application content database.

  3. [Setup] From the SharePoint 2010 Management Shell, use the New-SPWebApplication and Get-SPWebApplication cmdlets to configure the portal site Web application content database. Use the following example as a guide.

    New-SPWebApplication -Name "Contoso Internet Site" -Port 80 -HostHeader "http://sharepoint.contoso.com" -URL "https://www.contoso.com" -ApplicationPool "ContosoAppPool&q

    View Complete Post

More Related Resource Links

Creating an database search application in VS C#

Hello everyone, I wish to create a C# application that will have a form and a text box where I can enter a text, and then ask the application to search if this text exists in a database. If it exists, I want all the information associated with this text to be displayed in a datagrid view or list box. I am able to create a database in SQL Server and I can connect to my database from VS 2005 C#. If this is possible, how do I go about it? Many thanks in advance.

Crawling does not happing on a content database from set of DBs of my Web Application (MOSS)


Hi Team,

This is regarding indexing in MOSS content sources. I have an MOSS application(web site) configured as Content source for crawling. A user reported that his is not able to search on the content uploaded to his site. After performing quite a few checks and investigatations. We found below info in crawl log, we suspect that this is  crawling of all sites in Content Database(i.e., non are crawled and searchable). Atleast that is what we understand by trying search of quite a few sites residing in the databse.

Exception from HRESULT: 0x81070504 (There is no Web named "/sites/020045t".)

Also we find the site only in SiteMap table in SharePoint config Database only. We tried deletesite command with -force and -siteid switch, both were unsuccessful. Can someone tell us how to remove this orphan site/ entry in sitemap table? We are hesitent to delete the row in sitemap table since we do not impact of doing it from backend.

Thank you,


Creating Site Collection in Existing Content Database

Hi All,

I'm trying to create a site collection in a existing content database. I haven't found a method in Sharepoint object model to perform such a action. There is an option to create a site collection in a new database using the following command:
SPSiteCollection.Add(url, siteDescription, siteDescription, 1033, siteTemplate,
                                                                siteCollPrimaryAdmin.LoginName, siteCollPrimaryAdmin.Name, siteCollPrimaryAdmin.Email,
                                                                siteCollSecondaryAdmin.LoginName, siteCollSecondaryAdmin.Name, siteCollSecondaryAdmin.Email,
                                                                strSQLServerName, siteContentDBName, null, null);

Is there a different object to do this creation on existing database? Any ideas to approach this problem will be greatly appreciated



Application Vs. Content Pages in SharePoint

SharePoint has two types of ASPX pages. One type is the application page, also known as a _layout page. The other type of ASPX page is a content page, also known as a site page. Each of these page types is stored in a different location in SharePoint. When developers create custom ASPX pages, they must decide on the page type.

Creating a Smartphone Application and Using Data from SQL Mobile

In this exercise, you will use Visual Studio 2005 to create a Smartphone application. You will associate commands with a mobile device's soft keys, and you will add the ability to scroll through the list of available products (a list of images). You will create a data source for an existing SQL Mobile database, and then test the application in the Windows Mobile 5.0 emulator.

In the following procedure, you will create a new Windows Mobile 5.0 project in Visual Studio.

Need Help in creating chat application using jquery.


Hello Friends

             I have to develope Jquery chat application Like Gmail  in My Web application. For this i spend My lots of hours in Googling. AT THE time of searching I got one script. which is very helpful.  But in the script author has used all the members who has logged will be appeared in the chat box. instead of this i have to put only the members who's are in the friendlist. i have to show only these members.

Following is the project from where i get script.

As well as in the code author has passed dynamic userid to session but i have to pass actuall userid from database.


from Here I download the code. but the code is in the 3.5 framework. i m using 2.0 framwork. so most of the code I have changed but not getting how to make changes for list.

Please help me to solve the Problem.

Thanks In Advance


How to access a new database ( which i created ) in isqlplus ?



I created a new database with the help of Database Configuration Assistant !

I created with the scott account

Now i'm not able to connect to the database with the connect identifier with the scott account

The error i get is.,

ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.

Plz help !

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

An example of packaging web application containing database upgrade SQL file

A few months ago, we have a blog talking about extending the web publishing pipeline to package database project deployed SQL file.  In this blog, I'll show step by step example of packaging web application with SQL Server database upgrade SQL file using Visual Studio 2010.  This way, we can generate a web package with incremental SQL script to certain database version.  The scenario may help distributions of a web upgrade package which needs to be installed on many different locations, each with their own SQL server database.   1. Create a Web Application Project 2. Add a new "SQL Server 2008 Database Project" to the solution 3. Prepare a development database, such as my test1 database as the following: 4. Right click our...(read more)

How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

Create user is creating aspxxxx.mdf database in my app_data folder


I had already setup roles for my pages and requirements call for ability to manage and create users.

So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?

What am i missing or doing wrong?

I have the following setup in my web.config file..

		<authentication mode="Windows"/>
			<deny users="?"/>
        <add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

One or more types failed to load - While creating a web application as well as running psconfig wiza



I got this error while i was trying to create a web application - 'One or more types failed to load'. So i tried to run psconfig and got the same error.

My Spec

Windows Server 2008 R2 x64

SharePoint Server 2007 x64 with MOSS SP1, MOSS SP2, WSS SP1 and WSS SP2

Microsoft Office Professional 2010 x64

Microsoft SQL Server 2005


And, here is the complete error -


Log Name:      Application
Source:        SharePoint Products and Technologies Configuration Wizard
Date:          8/27/2010 3:30:28 PM
Event ID:      104
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ZBDEV22.zenbridge.com
Failed to register SharePoint services.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown.  Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Pleas

Problem with Movie Database Application

Hi Im following MVC tutorials on ASP.net website..I have a problem at Movies database application found in http://www.asp.net/mvc/tutorials/create-a-movie-database-application-in-15-minutes-with-asp-net-mvc-cs  Listing 3 - Views\Home\Index.aspx----------------------------------------------------------------------------------------------I dont understand where "Model" refer to in this code <% foreach (var item in Model) { %>  Also im confusing with accessing the database fields using var item Please explaine me what is happening in this code.<% foreach (var item in Model) { %> <tr> <td> <%= Html.ActionLink("Edit", "Edit", new { id=item.Id }) %> | <%= Html.ActionLink("Details", "Details", new { id=item.Id })%> Movie Database Application

Creating a 3D cube and display content on each side

Dear all, I would like to show different content in each of a cube face that I can manipulated in space. My customer has see this in a desktop 3 D application somewhere on the net and would like to have this integrated in my applciation I am really interresting to integrate this has it is a good customer but have never done it Does any one have a done this already or sample for doing it ? regards SergeYour knowledge is enhanced by that of others.
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