<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Replication: Publication error
13 posts, Page 1 of 2
1
2
»»
Replication: Publication error
Rate Topic
Display Mode
Topic Options
Author
Message
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 9:36 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
any help on this Publication error
SQL Server could not create publication 'Publication_Name'.
------------------------------
ADDITIONAL INFORMATION:
A log reader agent can only be installed for a database enabled for transactional/snapshot replication. (Microsoft.SqlServer.Rmo)
------------------------------
BUTTONS:
OK
------------------------------
Post #1360861
MysteryJimbo
MysteryJimbo
Posted Tuesday, September 18, 2012 10:00 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 1,125,
Visits: 14,511
You need to enable the db for replication.
You can do it through publisher properties or this TSQL
exec sp_replicationdboption @dbname='dbname', @optname= 'publish', @value= 'true'
GO
Post #1360871
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 10:12 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
I get an error
OLE DB provider "SQLNCLI11" for linked server "Linkserver_Name" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "Linkserver_Name" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
Post #1360881
MysteryJimbo
MysteryJimbo
Posted Tuesday, September 18, 2012 10:17 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 1,125,
Visits: 14,511
Thats nothing to do with replication.
How are you trying to enable replication?
Post #1360885
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 10:30 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
we did as per the Microsoft regular process.
I am also confused about his error message.
Any help is greatly appreciated.
Thanks
Post #1360891
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 12:45 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
1)WHen I execute the below SP on publisher. I get the below info, How could I Updated distribution server column with server name instead of Linkedserver_Name, that row below?
sp_get_distributor:
installed |distribution server | distribution db installed |is distribution publisher| has remote distribution publisher
0 Linkedserver_Name 0 0 0
2) I am confused, Does the publisher is thinking it as an distributor is configured for linked server.
3) How could I Update the SELECT * FROM Master.sysservers
for datasource coulun.
Post #1360952
MissTippsInOz
MissTippsInOz
Posted Tuesday, September 18, 2012 7:21 PM
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 7:43 PM
Points: 286,
Visits: 520
Danzz (9/18/2012)
1)WHen I execute the below SP on publisher. I get the below info, How could I Updated distribution server column with server name instead of Linkedserver_Name, that row below?
sp_get_distributor:
installed |distribution server | distribution db installed |is distribution publisher| has remote distribution publisher
0 Linkedserver_Name 0 0 0
2) I am confused, Does the publisher is thinking it as an distributor is configured for linked server.
3) How could I Update the SELECT * FROM Master.sysservers
for datasource coulun.
If your publisher and distributor are on separate boxes, i.e. you have a remote distributor configuration, a linked server will have been configured in order to achieve this - thats how it works. If you look in your Linked Servers container I suspect you will see a 'repl_distributor' there. To get rid of the remote distributor you will need to drop any publications on this server, then run 'exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1', to remove the distributor.
Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)
Hey, just a thought.....did you check Books Online yet?
Post #1361078
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 7:45 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
Cannot add server to Replication monitor,
It show red cross mark? what does this mean? as of my understand is that it is not ready to monitor.
How can I add to Replication monitor?
Post #1361084
MissTippsInOz
MissTippsInOz
Posted Tuesday, September 18, 2012 7:50 PM
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 7:43 PM
Points: 286,
Visits: 520
ok stop posting random questions. No one is going to help you when you're posting in this way.
You began posting about being unable to create a publication and now you're stressing over Replication Monitor. Let me be blunt; you are new to replication and you have clicked left, right and centre all over Management Studio, trying to get this thing to fly and you're now at the point where you really have no idea what you've done. \
If I'm going to help you out you are going to have to tell me:
1. what are you trying to achieve. That is tell me where your publication, distribution and subscription databases are (or are intended to be)
2. What type of replication you are attempting to set up
3. What stage you are currently at in the process.
Once I understand this, I will POSSIBLY be able to assist you to wind the whole thing back and then start again from the beginning.
In the meantime, stop flooding the board with multiple threads about the same issue.
Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)
Hey, just a thought.....did you check Books Online yet?
Post #1361087
Ranzz
Ranzz
Posted Tuesday, September 18, 2012 8:01 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 12:42 PM
Points: 138,
Visits: 510
Pub :2008r2
Dist and Sub : 2012
seems now every thing is working.
Cannot add server to Replication monitor,
It show red cross mark? what does this mean?
I have run sp_removedbreplication on Dist and Pub to delete and recreate. I am done successfully
I am not sure this caused issue in the replication monitor shows a red cross mark.
Post #1361089
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
