.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

Database Publishing Wizard

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

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

View Complete Post

More Related Resource Links

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

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.

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.

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.

Stuck installing Sharepoint 2010 - Config Wizard saying Cannot connect to database master


Hi all

I have setup 2 servers in hyper-v.
SERVER-SHP = Sharepoint 2010
both running on windows server 2008 R2.
Both servers are joined to the same domain, have fixed ip addresses and can ping each other.

When I get to the part in Sharepoint 2010 setup where I'm runnng "Sharepoint Products Configuration Wizard" where I specify the database server and name and username and password I get the following error which I can't get past "Cannot connect to database master at SQL server at SERVER-SQL. The database might not exist, or the current user does not have permission to connect to it."

I have read the following link and followed it but the problem remains

I don't see where it is falling over as the username and password is the domain administrator one (have also tried the spAdmin) mentioned to setup in the above link. And it says at the notes at the top of the page that if the database (SharePoint_Co

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

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




I am using copy wizard in sql server 2008 machine to copy a database to another sql server 2008 machine. Here is the log file.


#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,CDW_NL-DEVXP95_MSSQL2008_NL-DEVXP95_MSSQL2008R2_3,{65EB1D9A-DC17-4649-90B7-B3292DFE1ADE},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPreValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,192_168_3_144_MSSQL2008_192_168_3_144_MSSQL2008R2_Transfer Objects Task,{5231CE89-011F-4E2F-8B23-3DC5809CCB86},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPostValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,192_168_3_144_MSSQL2008_192_168_3_144_MSSQL2008R2_Transfer Objects Task,{5231CE89-011F-4E2F-8B23-3DC5809CCB86},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPostValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,CDW_NL-DEVXP95_MSSQL2008_NL-DEVXP95_MSSQL2008R2_3,{65EB1D9A-DC17-4649-90B7-B3292DFE1ADE},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)

Copy Database Wizard: Cannot choose databases, checkboxes are missing



I try to move databases from one SQL 2008 R2 to another SQL 2008 R2 Server with the copy database wizard.
On the page where I should choose the databases to move or copy the checkboxes are missing. The databases are listed but no way to choose one of them.

I searched a lot but did not find out what the reason could be for this.
Any hints are appreciated, thank you!

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

A better way to reference your wizard steps using named steps

Note: this article uses the plain vanilla but the concepts apply equally well to its popular counterpart .

By far the most common way that I see wizard steps reference in code snippets is by their index.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
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