.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

configure distribution wizard does not appear on SSMS menu when trying to create new publication

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server


Server A SQL 2005 sp2 Standard Ed. (9.00.3042.00)

Server B SQL 2005 sp2 Standard Ed. (9.00.3068.00)

A replication was setup on these two server a while back by someone else. Server A is the publisher and Server B is the distributor and subscriber. The replication was not working and was told it have never worked.

I was requested to rebuild the replication with local distributor, ie, moving distributor from Server B to Server A.


1. deleted the subscriber from Server B using SSMS.

2. deleted the publication from Server A using SSMS.

3. dropped the distributor using the following script on Server B

                         EXEC sp_dropdistributor @no_checks= 1

I noticed distribution database was gone from Server B. Both publication and subscription were disappeared on SSMS from respective server.


When I tried to create new publication, the "Configure Distribution Wizard" did not appeared as I expected, and the creation failed eventually with the following error.


Creating Publication

- Creating Publication 'Areporting' (Error)

View Complete Post

More Related Resource Links

how to get an array of all the asp.net textbox control inside create user wizard control?



How can I get all the textboxes inside a create user wizard control using getElementsByTagName().

Below is my JQuery code:

<script type="text/javascript">
        function addLoadEvent(func) {
            var oldonload = window.onload;
            if (typeof window.onload != 'function') {
                window.onload = func;
            } else {
                window.onload = function() {

        function prepareInputsForHints() {
            var inputs = document.getElementsByTagName("asp:TextBox");
            for (var i = 0; i < inputs.length; i++) {
                inputs[i].onfocus = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "inline";
                inputs[i].onblur = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "none";



<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

form feild hints are not displaying for textboxses inside create user wizard?



I'm using following JS code to display input hint box besides the textbox whenever that asp.net textbox receives focus. 

I'm doing this for a registration form and all of the textboxes are inside the asp.net create user wizard control.

<script type="text/javascript">
function addLoadEvent(func) {
  var oldonload = window.onload;
  if (typeof window.onload != 'function') {
    window.onload = func;
  } else {
    window.onload = function() {

function prepareInputsForHints() {
	var inputs = document.getElementsByTagName("TextBox");
	for (var i=0; i<inputs.length; i++){
		// test to see if the hint span exists first
		if (inputs[i].parentNode.getElementsByTagName("span")[0]) {
			// the span exists!  on focus, show the hint
			inputs[i].onfocus = function () {
				this.parentNode.getElementsByTagName("span")[0].style.display = "inline";
			// when the cursor moves away from the field, hide the hint
			inputs[i].onblur = function () {
				this.parentNode.getElementsByTagName("span")[0].style.display = "none";

create user wizard login error message dont show in a message box?




i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.


there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes


is it possilbe to hook all of these up so I get one message box with all errors including membership ones?




file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

Create User Wizard and Loginview error


 When i place the create user wizard control inside the Loginview Anonymous Template, the Create User Wizard gives an error inside the C# file. Here is a snippet

Home.aspx Web Form

 <asp:LoginView ID="LoginView2" runat="server">
        <asp:CreateUserWizard ID="CreateUserWizard1" CreateUserButtonType="Image" 
        CreateUserButtonImageUrl="~/images/signup.png" cssclass="createuser" 
        runat="server" OnCreatedUser="CreateUserWizard1_CreatedUser" 
           <TextBoxStyle CssClass="Ctextbox" />
            <LabelStyle cssclass="lbl" />
                <asp:CreateUserWizardStep ID="CreateUserWizardStep1" runat="server" />
                <asp:CompleteWizardStep   ID="CompleteWizardStep1" runat="server" />
        news here

Here is the C# Code with the error 


How to develop a Create Site Wizard


When you create a new site in a SharePoint site collection, you get the first screen where you enter the site name, description, choose a site template etc. How can I develop a similar screen where I give users ore options to enter other information such as entering the name of default documents library, default list etc.?

I have created a custom site template that contains a document library with some preloaded documents, a task list with predefined tasks etc. My manager has asked me to develop a wizard like page that allows a user to create a site by selecting this custom template and entering a document library and task list name of their choice. There are some business reasons/logics behind all this, but I am just presenting a simpler version here to get me going.

I would greatly appreciate any advice, code sample, references, etc.


Collecting extra information using Create User Wizard

 I am trying to collect extra information about a user when the user account is created using the Create User Wizard. This info will be stored in a new table in the standard ASP membership SQL database. I have read several books and loads of online tutorials on the subject and they all take different approaches and seem to make the process hard work. Is there any reason why I can't add an SQL datasource and a number of textboxes  to the wizard step, 'connect' the values from the textboxes to the Insert Parameters and then put an Insert Statement in a suitable event handler to cause the insert? If this is possible what would be the best (ie simplest) way to 'connect' the textboxes to the insert parameters?   Regards Andy

Why is there no wizard control in WPF? Is there an easy way to create one, like with the TabControl

Hello, First, NO THIRD PARTY PRODUCTS!  In my search, it seems like anyone asking for a wizard control is sent to a third party to buy it.  I have no interest in buying a third party product, so if you are one of those that would suggest it, please don't, I'm simply not interested. If my understanding of page framework is correct, that is, the page is within a separate XAML file and the events are handled via its code behind, then I am not interested in such a scenario.  Nor am I interested in any fancy plumbing to make page framework work the way I want. All I want is the simple wizard control.  I'm amazed that such an important function was left out of WPF, especially since the TabControl is so close to being a Wizard Control. I'm thinking that the TabControl should be able to be made to function like a wizard, but my search finds nothing of any value.  Is the TabControl not suitable to be made to function like a wizard? Any help (other than third party products) would be greatly appreciated. Regards, Robert

Create user button in Create user wizard

Hey May i know how i can change postion of  Create user button in Create USer Wizard as i want to change according to requirement!!!

Error during configuring distribution wizard

TITLE: Configure Distribution Wizard------------------------------ An error occurred configuring SQL Server Agent. ------------------------------ADDITIONAL INFORMATION: SQL Server blocked access to procedure 'dbo.sp_set_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.  (Microsoft SQL Server, Error: 15281) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15281&LinkId=20476 ------------------------------     How do I solve this??     Thanks,   Frank System Engineer

Create user Wizard

Hello I m facing major problems as i want to clear fields i.e username password firstname in create user wizard as i have tried follwing option but not working  1) username texbox empty 2) username viewstate false 3) createUser wizard viestep false as nothing is working   nned big help for this!!!

VS , Where Create User Wizard Save User and Pass and info

Hi , First Sorry For My Bad English :DAnd Second:I Have Question : Can I Edit Create User Wizard To Save Info To My Project  Sql ? And Where Normal Create User Wizard Save Info Of Register ? TanX !! :D !

Trying to Create New user with Create User Wizard and getting name already exists! ??

hi, I am using a create User Wizard for registering a user and have converted it to a  a template to capture additional information.  In the CreatedUserEvent handler in Code Behind I  am getting the UserName of the new user and their unique GUID key. This is then added to a seperate data table with addditional info captured from the user. The textboxes within the create user Wizard have validation controls. If the user has missed an entry these fire and it shops the process of creating the user. BUT  If I then complete the textboxes and then click submit it says the USER NAME already Exists! This is not what I want as the User just needs to correct the errors in the form and they should be able to keep their iniital User Name choice. Do I need to change the Event handler and if so am I still able to capture the USerName and Key so that I can add the data to the other non membership table. any examples / advice most helpful thanks   P    

Configure Menu

I'm using VS 2008 I have the following menu as shown below. I have 2 questions. 1) After the "Solutions" item there is a black arrow. How do I get rid of that as I have specified Horizontal for the Menu Control 2) How do you configure each sub item in "Solutions" to have a grey backcolor when the "Solutions" item is hovered? and when you hover a sub item, the forecolor goes blue?   <td>        <asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" ForeColor="Black">            <StaticHoverStyle ForeColor="Blue" BackColor="#E4E4E4" />            <Items>                <asp:MenuItem Text="Home" Value="Home" NavigateUrl="~/Default.aspx"></asp:MenuItem>                <asp:MenuItem Text="Solutions" Value="Solutions">                    <asp:MenuItem Text="Technical Sup

Tab order in create user wizard

I have as 2 step create user wizard.  The second step collects shipping information.  I use a custom control for gathering the shipping information.  I have tabindexes set up, but the wizard always sets focus to the button instead of the next text box.  How can I change the tabindex of the button?

Configuration Wizard is failing when upgrading from MOSS2007 to SP2010: "failed to create the sharep

I have a In Place Upgrade running I have started looking into the Service Connection Warning im getting but the next error is the show stopper that I cannot get my head around to. o9/15/2010 10:51:20  14  WRN                          Failed to add the service connection point for this farm 09/15/2010 10:51:20  14  INF                          Entering function StringResourceManager.GetResourceString 09/15/2010 10:51:20  14  INF                            Resource id to be retrieved is ServiceConnectionPointNotCreatedEventLog for language English (United States) 09/15/2010 10:51:20  14  INF                            Resource retrieved id ServiceConnectionPointNotCreatedEventLog is Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domai

error message customization in create user wizard, change password wizard


Hi All,

Create User Wiard and Change Password Wizard contain error message literals. They display error messages when a user is trying to sign up with an username that already exists and so on.

These error messages are pre-set. How can they be customized. In particular, how can they be adjusted depending on the language.

How is this usually best achieved?

Thanks a lot.


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