When trying to create a replication it is necessary to have an Alias in order to correctly name the server and open the connection. You can create the alias in SQL Server Configuration Manager.
These should be the steps:
Aliases created with SQL Server Configuration Manager can be used with any client application. The connection strings described in SQL Server Configuration Manager Help can be useful for programmers who create their own connection strings.
To access alias information in SQL Server Configuration Manager Help
1. In SQL Server Configuration Manager, expand SQL Native Client Configuration, right-click Aliases, and then click New Alias.
2. Press F1, or click Help.
3. The New Alias (Alias Tab) topic describes the New Alias dialog box, and contains links to valid connection strings for each type of protocol.
Then you should be able to use the Server’s name in the Replication creation process.
Thursday, May 12, 2011
SQL Server
On occasion we have had trouble with Microsoft SQL Server 2005 causing us an issue with Replication.
It returns an error message like the following:
Error messages:
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
An error occurred while processing the log for database 'TursSearchEngine'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. (Source: MSSQLServer, Error number: 9004)
Get help: http://help/9004
The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)
Get help: http://help/MSSQL_REPL22017
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
It is still unknown as how it happens or when.
The work around solution is to:
1. Run a query on the screener Database server with the following:
a. Set [DatabaseName]
b. exec sp_replrestart
c. GO
2. Then you will have to reinitialize the subscription.
This should allow the service to restart and fix the problem. If anyone has any further pointers as to why this occurs or How to fix it better, please post a comment.
It returns an error message like the following:
Error messages:
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
An error occurred while processing the log for database 'TursSearchEngine'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. (Source: MSSQLServer, Error number: 9004)
Get help: http://help/9004
The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)
Get help: http://help/MSSQL_REPL22017
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
It is still unknown as how it happens or when.
The work around solution is to:
1. Run a query on the screener Database server with the following:
a. Set [DatabaseName]
b. exec sp_replrestart
c. GO
2. Then you will have to reinitialize the subscription.
This should allow the service to restart and fix the problem. If anyone has any further pointers as to why this occurs or How to fix it better, please post a comment.
Tuesday, May 10, 2011
Creative Strategy
We have been working on our team to improve its function through training. It will take time to learn all that Don has to offer. But we keep moving forward. This post is dedicated to the effort that one of our team members has put into one of our trainings.
We needed to develop some new marketing and the requirements were not quite known. The first impression was to jump right in to start writing the text, but we have learned this only leads to marginally acceptable content. So this team member was requested to return with a Strategy.
Why do we need this information, and what will it be used for? These questions must be answered. He was given an outline to build this Creative Brief. I will try to develop the ideas posed by this outline.
Who will be using the content? The first section is to define the Client. This section was a little light in my eyes but it doesn't always have to be explicit. This may even include the name of the one who will receive the Deliverables.
Next, the Background or Overview for the proposed content. Give a quick description of Why this content is needed. Share the reasons this content will be important.
The Objective of the content should portray the message that must be presented by the content or advertising. It should be very succinct so as to not cause any deviation from the desired outcome.
The Values that will be presented as part of the marketing follow the Objective so the group that will be building the content can tie the Objective to why the buyer should pursue the Call to Action. The values can be a list of items that gives the product worth.
What is the actual Target Audience? Try to describe the Audience in detail: what appeals to them, how they might differ from other groups, their locale, how they will use the product. There are many questions and ways to approach this section but this is where the content will be built specific to the audience. If this is not filled out correctly the content will fall short of meeting your overall objective.
The outline suggests you add the Single Most Important Thing to Say. The main point must come across in the content. So write what you think should be said.
The last section that relates to the actual content is reasons to buy, both logical and emotional. Expand the value of the product in this section. Again a list will help you organize your thoughts on this subject.
An outline of Deliverables with dates will provide the necessary schedule for the development of the content. The time line will allow those building the content to properly plan their time and set meetings that may be necessary to approve resources.
Further Requirements may be included to ensure that anything not included above can be supplied to the development group. Items may include specific quotes from the client that must be included. Names and information about logos, images and text size.
After all this you only need to review the document to ensure you have sold the strategy and the product. You have to enough info that will make it possible for marketing to make it work and described the content well enough for management to sign off to provide resources.
We needed to develop some new marketing and the requirements were not quite known. The first impression was to jump right in to start writing the text, but we have learned this only leads to marginally acceptable content. So this team member was requested to return with a Strategy.
Why do we need this information, and what will it be used for? These questions must be answered. He was given an outline to build this Creative Brief. I will try to develop the ideas posed by this outline.
Who will be using the content? The first section is to define the Client. This section was a little light in my eyes but it doesn't always have to be explicit. This may even include the name of the one who will receive the Deliverables.
Next, the Background or Overview for the proposed content. Give a quick description of Why this content is needed. Share the reasons this content will be important.
The Objective of the content should portray the message that must be presented by the content or advertising. It should be very succinct so as to not cause any deviation from the desired outcome.
The Values that will be presented as part of the marketing follow the Objective so the group that will be building the content can tie the Objective to why the buyer should pursue the Call to Action. The values can be a list of items that gives the product worth.
What is the actual Target Audience? Try to describe the Audience in detail: what appeals to them, how they might differ from other groups, their locale, how they will use the product. There are many questions and ways to approach this section but this is where the content will be built specific to the audience. If this is not filled out correctly the content will fall short of meeting your overall objective.
The outline suggests you add the Single Most Important Thing to Say. The main point must come across in the content. So write what you think should be said.
The last section that relates to the actual content is reasons to buy, both logical and emotional. Expand the value of the product in this section. Again a list will help you organize your thoughts on this subject.
An outline of Deliverables with dates will provide the necessary schedule for the development of the content. The time line will allow those building the content to properly plan their time and set meetings that may be necessary to approve resources.
Further Requirements may be included to ensure that anything not included above can be supplied to the development group. Items may include specific quotes from the client that must be included. Names and information about logos, images and text size.
After all this you only need to review the document to ensure you have sold the strategy and the product. You have to enough info that will make it possible for marketing to make it work and described the content well enough for management to sign off to provide resources.
Subscribe to:
Comments (Atom)