View Complete Post
I tried to monitor the replication by running the query.
Now, one distribution agent is failed; however the status returned by the query doesn't show that. It is idle instead of failed. Do you know why this happens? What's the best way to monitor automatically?
In our environment we are maintaining Transactional replication between 2 servers.
Both servers are sql server 2005 with standard edittion.
By launching replication monitor in server 1 we can see both the servers publisher status.
But i found that server 2 publisher is not able to connect with distributor.I tried to connect to distributor.Here i am getting error like
Replication monitor could not connect to distributor of server 2.
Failed to connect to server 2 (Microsoft .Sqlserver.Conenctioninfo)
Login failed for user " .The user is not associated with a trusted sql server conenction .(Microsoft sql server ,error :18452)
Kindly help me to find out the exact rootcause.
Latency shows around 18 hrs today on the replication monitor and status shows Performance critical.Is that mean the subscriber is 18 hrs latency when compared to the publisher?Will it catch up eventually?
Thanks In advance.
I have created a replication topology on 2 servers. The distributor is located on the subscriber in order to reduce server load on the publisher. The publisher is a Sql Server 2005, the subscriber & distributor is Sql Server 2008.
When I want to examine the replication with replication monitor, I have to do this at the publisher. If I try to view synchronization status at the subscriber it throws the exception 'You must manage this subscription from the publisher because
it shares a distribution agent with subscriptions to other publications from the same publication database.' Also I don't even have the option to call the replication monitor at the subscriber. But when I try to open a replication monitor at the
publisher, it isn't able to connect to the distributor because it is Sql Server 2008.
Is there any way I can use the replication monitor in my deployment scenario?
I'm using SQL Server 2005 Replication Monitor to monitor a number of Publications.
One Publication node, will not expand however, that is to say that when clicked it's label changes to expanding and then never actually completes in order to provide details of the Publications at the Publisher. This means that I cannot highlight a specific
Publication at the Publisher for further investigation and instead have to review all Subscriptions in the subscription watch list, which is cumbersome.
I have tried removing the Publication and adding it back to Replication Monitor without success, the issue persists. I have also tried creating a SQL Server Login with SYSDBA rights in order to connect to the remote distributor in order to rule out a
Has anyone else come across this issue before or can perhaps provide further suggestions in order to troubleshoot?
So, I am using Replication monitor, and under one of my publisher nodes, I still see an old publication, which I do not see in SSMS Object explorer. This publication shows a red 'x', and I can't view the properties. I've tried using 'sp_droppublication' at
the publisher, 'sp_dropsubscription' at the publisher, 'sp_droppullsubscription' at the subscriber, and 'sp_subscription_cleanup' at the subscriber.
Any ideas on how to get rid of this? It's making the publisher node show a red 'x' also, which is misleading. Thanks!
In SQL 2005 and SQL 2008, in the Replication Monitor it will show a red X if any of the subscriptions have an error. Is there a TSQL statement i can run to see that without having to go into the Replication Monitor?
i am trying to come up with some way to see that information and present it to our customer from our application without them having to connect to SSMS and look at the replication monitor.
thanks for you help.
after updating a SQL Server 2008 (German) installation to SQL Server 2008 R2 (English), I get an error when I connect to the distributor by using the replication monitor on the same machine. I deinstalled the old version and made a complete new installation.
the error message is: "an error occurd while retrieving the puplisher data" and "Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt"
The last massage is in german, which means translated: "Object reference not set to an instance of an object"
When I open the distributor on this machine from an other machine everthing is fine.
I believe, there is somewhere a library which is still from the previous installation. But where?
Thats how it look like: http://ausgelesenes.de/rm_error.jpg
Server Info ===========================
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 3.86.3959
I am hosting my ASP.NET application on a Windows 2003 Server.
To browse to my application one has to type the path :http://serverName/applicationName
I want users to only type applicationName on the web adress area.I believe there is something to do with alias and CNAME on DNS records that can adress this.
Any help on how to go about doing this will be highly appreciated.
I am new to asp.net programming.
While working with windows form(windows application) i have created a window for editing purpose(just like popup window ) which contains three bounded dropdown list a button and a gridview. After making selections from the drop down when we press button the corresponding result should display in a grid.After that when you click on the grid row it will load the corresponding datas in my form. i want to create such control in asp.net . i have to use jquery or ajax.And this pop up window i have to use more than twenty times in my application.am using VS2008 ASP.NET and C# 3.5 . Plese suggest me what to do.
Thanks in advance
I am a long time ASP.NET developer, but have just encountered the issue of CSS vs Tables in a deep manner (so far I have just used the built-in controls or just created my own controls).
I bought a great book on this issue, but the book is reffering the ASP.NET 2.0 via VS2005.
I am using ASP.NET 3.5 and above via VS2008/2010.
My first question is: are the "CSS Friendly Control Adapters" still alive in 2010 or maybe there are a new techniques being used?
My second question is: are the "CSS Friendly Control Adapters" being used in ASP.NET 3.5 and above via VS2008/VS2010?
I will appreciate your help and advise.
This is driving me crazy... I cant find the .vsi file for installing the CSS Friendly Control Adapters Project. Does anyone know where I can get this?
The following link: http://www.asp.net/cssadapters/ only leads to the CodePlex wiki where I can download the dll and a partial solution. Essentially, I'm looking for the source code to implement the Menu adapter.
Any help is much appreciated!
Hi guys really new to ASP.NET I was trying to install the CSS Friendly control adapter but for some reason the instructions on the website seems outdated. I downloaded all the files (Source Code, DLL, Browser) I believe I need to add the DLL file to my website's Bin folder and the Browser file to the APP_Browsers folder is this correct? After I place this files how to I get it working? what do I have to do? Also if I want to create a new DLL file from the Source code how do I do these? I opened the web-site with Visual Studio 2008 and I can see all the files in the solution explorer? But how do I compile this to a DLL file? I tried doing a build solution but all I get is an .sln file???
Any help would be greatly appreciated
Thanks in advance
Hopefully someone can help.
I have an asp.net menu with horizontal static top tier followed by 2 dynamic vertical lower tiers.
It renders fine in all other browsers etc. etc. - apart from IE6.
In IE6 the menu is not rendered horizontally and insttead the items are stacked vertically.
It is my understanding that when using horizontal orientation, the menu items are effectively floated next to each other.
So I can get round this float problem in IE6 by specifying a width for the items i.e.:
*html .AdminMenu .AspNet-Menu-Horizontal ul.AspNet-Menu li
Problem is, I do not want to set the width for each item. If I do this then it means regardless of the length of the text the width will always be the same.
On other browsers I do not set a width but instead set left/right margin so that every item is evenly spaced.
How can I do this in IE6? Essentially each li should wrap the text and float nex
If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.
MSDN Magazine May 2009