.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

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

Posted By: Faizal     Posted Date: December 01, 2009    Points: 2   Category :Sql Server
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

View Complete Post

More Related Resource Links

Database Publishing Wizard


Anyone know what I am doing wrong here?

When the DBP (Database Publishing Wizard) starts it wants either a connection string or a server. I enter the name of my server (I am running SQL 2008 R2, locally) and I get the list of databases that are on my server. Great, it's all there including Northwind and my database which is being regularily used by a localhost website. Yet, selecting my database, I get this (I did not find the answer at the link):


TITLE: Microsoft SQL Server

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Database+Publishing+Wizard&ProdVer=


Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its de

Database Export Wizard for ASP.net and SQL Server

A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.

Designing and Developing High-Performance SharePoint Server 2007 Publishing Sites

Learn about the Web Content Management features in SharePoint Server 2007 that enable organizations to deploy Internet-facing publishing sites, and considerations for developers and designers when designing and building high-performance publishing sites.

Real World Branding with SharePoint Server 2007 Publishing Sites, Part 1

Learn the essential concepts needed to create an engaging user interface design in SharePoint Server 2007 publishing sites.

Sample: Real World Branding with SharePoint Server 2007 Publishing Sites

Sample code that helps you learn the essential concepts needed to create an engaging user interface design in SharePoint Server 2007 publishing sites.

Publishing Excel 2007 Workbooks to SharePoint Server 2007 (Visual How To)

Watch the video and explore code as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Sample: Publishing Excel 2007 Workbooks to SharePoint Server 2007

Explore the code in this visual how-to article as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Sharepoint 2010 - Cannot Activate SharePoint Server Publishing

Site The feature being activated is a Site scoped feature which has a dependency on a Site Collection scoped feature which has not been activated. Please activate the following feature before trying again: SharePoint Server Publishing Infrastructure f6924d36-2fa8-4f0b-b16d-06b7250180fa Web The Site scoped feature being activated has a dependency on hidden Site scoped feature 'FeatureDefinition/22a9ef51-737b-4ff2-9346-694633fe4416' (ID: '22a9ef51-737b-4ff2-9346-694633fe4416'). Hidden features cannot be auto-activated across scopes. There may be one or more visible Site scoped features that auto-activate the dependent hidden feature.

Office Sharepoint Server Publishing Infrastructure is missing in site collection feature SharePoint

I was trying to activate the Office Sharepoint Server Publishing Infrastructure feature in the site collection features but the feature is simply not there. Is this option not available in SharePoint Foundation 2010?

SQLServer2008 job created by Copy DataBase Wizard fails - cannot determine if job owner has server a


Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:

SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1 has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).

There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for SSIS jobs.

The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to Logon as a Batch Job on both servers.

TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.

I don't know what else to do.

Setting Options Programmatically in Visio 2010 for Publishing to SharePoint Server 2010

Explore how to programmatically save Visio 2010 diagrams as web drawings for use with Visio Services in SharePoint Server 2010.

SQL Server 2005/2008 COPY Database Through Wizard



Let's start a very intresting thread here:

As you all know moving the database from one server(2000, 2005, 2008) to (2000, 20005, 20008) is not a big deal and can be done in many ways  like backup-restore, attcah-detach, and most easy (some time very complex:-)).

Here i wanna discuss an issue which i have faced.

I have two instances of SQL server 2008, i have created a new database Test in one instance, created few logins and mapped to  Test database with some permissions for this Test database.

Now i used copy database wizard to copy this test database to other instance, i sucessfully went through the wizard and selected SQL server object method to copy the Test database in other instance then i followed the remaing wizard, i selected the logins which i have created for the Test database and finnaly i reached the finish button i clicked finished and the copy of database completed sucessfully. I verified that Test dabase was there in other instance with the logins which i have created. So easy i was happy:-)

Problem: Some other day i wanted to copy AdventureWork database to the other instance of SQl server i was happy that its a very easy task i followed the same steps above(to copy the Test database ) and every thing went in the same way and i clicked finish to complete the wizard it took some time

SharePoint 2007 activating Office SharePoint Server Publishing Infrastructure


We turned on the Office SharePoint Server Publishing Infrastructure feature on our MOSS 2007 (after we already had sites created) to allow users to be able to use features like excel services and reporting which both require this be activated the Publishing feature to be turned on,  In order to do this you have to activate the Office SharePoint Server Publishing Infrastructure feature at I beleive the top level site, however when we activate this feature it changes the templates and navigation for all the existing SharePoint sites in our collection. 

Is there a way to turn this feature on with out impacting existing site sites?  Or am I doing something wrong that is causing this to happen?  Basically I need to know how I can activate this option (Office SharePoint Server Publishing Infrastructure) to just specific sites but not all or turn it on so it does not impact all sites?


Problems displaying xml file after publishing to production server


In my Visual Studio 2008 web site, I created a new folder named Reporting.  Then one of my web pages creates an xml file in this new folder when the user clicks a button.  The user then clicks another button and the xml file displays in the browser.  This all works fine on my development PC. 

But if I publish this web site to my production server, it does not work.  I get an error when I click the first button to create my xml file.  The error reads:

Could not find part of the path 'c:\windows\system32\inetsrv\Reporting\abc.xml'

What must I do so that this works on my development PC and also my production server?





Error when configuring Report Server Database - Wizard is trying to create Database on a non existen


I'm trying to setup SSRS using the Reporting Services Configuration Manager.  Everything seems to be working except the database creation.  When I click on the Database (3rd option down) then Change Database I run through the wizard.  Put in proper SA credentials.  Accept the defaults clicking next through and when it gets to running the script to create the data base I get the Error I pasted below.  We do not have a G drive so I went into SSMS and changed the Default Database settings to point to the F drive (where our other DBs reside) - I got that tip off of this forum but it didn't fix my issue. Any ideas what to try next?  Do I need to stop and restart a service or something?  Thanks for any help you guys can offer.

System.Data.SqlClient.SqlException: Directory lookup for the file "G:\mssql\data\ReportServer.mdf" failed with the operating system error 3(The system cannot find the path specified.).

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateO

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