.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Identity Range Management: What pool does the Republisher use?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

What I am trying to figure out is on a re-publisher what range does it use for it's subscribers?

I see, in SSMS, Publisher Range Size and Subscriber Range Size.  What do each of these go towards?  Does my re-publisher use the Publisher Range size, as set at the Primary Publisher, for it's Identity Range for it's subscribers?  I understand that the Identity Range at P1 > P2(S).  

I am just trying to figure out from which pool it pulls.

Thank you,

View Complete Post

More Related Resource Links

How to user Appol pool Identity for WCF authorization

One of my client has unique requirement.          Details Has Web application, WCF Service both are hosted in IIS6, and runs under a Domain Account (say MyAppAdmin) App_pool. Web application has anonymous access, and service is protected by Windows Authentication. Web App will calls the Service without any impersonation. So Serivice will be called by using App_pool Identity. Below is the code...objClient.ClientCredentials.Windows.ClientCredential = System.Net.CredentialCache.DefaultNetworkCredentials;objClient.ClientCredentials.Windows.AllowNtlm = true;objClient.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation;objClient.Open();svcResult = objClient.MyMethod(input);Problem & requirement: App_pool user is coming to Service, able access using HttpContext.Current.User.Identity, with the properties IsAuthenticated=true; Name=MyAppAdmin. I need check, if this App_Pool user in an Active Directory Group or not. If he is part of allowed group then only I should allow to continue execution of method. For this I am using below codeWindowsIdentity wi = (WindowsIdentity)HttpContext.Current.User.Identity;PrincipalPermission permission = new PrincipalPermission(wi.Name, allowedRoleName, true);permission.Demand();But it is throwing Security.SecurityAccessDe

Identity Range Value (Max Limit Finished) SQL Server 2005 (Merge Replication Problme)


Hi ,

I am using SQL Server 2005 enterprise edition, I Confirured the Merge Replication to my database). I have a replication of 21 database from various locations.

Problem is: When is trying to remove one subriction from the publisher and add a fresh subriciton to it. it is poping any error saying the Identity Range value exceed its Max Limit try to change from int to bigint. is there any solution for it not changing from int to bigint.

Thank you.


Peer-to-Peer Identity Management

Is there a way to make identity management work in peer-to-peer replication similar to the way it works in merge replication?

I do not want to be dependent on a central publisher, but I would rather not have to assign arbitrarily large starting identity values.

Forefront Identity Management Service does not support workflows of type 'Microsoft.ResourceManagem


I have a client that has a Named instance of SQL Server 2008 R2, as this can cause issues with the User Profile Service I have deployed the June 2010 CU to this SharePoint Farm. Farm consists of 1 WFE, 1 App and a SQL 2008 R2 cluster. While applying the June I also went ahead and deployed the August 2010 CU. This is a new environment and is still in the design phase.

Well on to the problem.

After these CU's were added we were able to configure the Profile import and everything is importing as expected.

But now the Event logs (Windows Application) are throwing a Forefront Identity Manager Event ID 3, every min, these are coming in groups of 2 with the same ID but slightly different messages.

Message 1:

Microsoft.ResourceManagement.Workflow.Hosting.WorkflowManagerException: Forefront Identity Management Service does not support workflows of type 'Microsoft.ResourceManagement.Workflow.Activities.SequentialWorkflow, Microsoft.ResourceManagement, Version=4.0.2450.9, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.

Message 2:

Microsoft.ResourceManagement.Service: Microsoft.ResourceManagement.Workflow.Hosting.WorkflowManagerException: Forefront Identity Management Service does not support workflows of type 'Microsoft.ResourceManagement.Workflow.Activities.SequentialWorkflow, Microsoft.ResourceManagement, Version=4.0.

SAP NetWeaver Identity Management RMS & SharePoint 2010



In one of our client, they are using SAP Netweaver Identity Managment, and also SharePoint 2010. They wanted to protect Office doucments in SharePoint by integrating with Netweaver. Can someone help me or direct me how to configure that in the SharePoint server.


User.Identity.Name returns app pool user instead of domain user


2 server web farm windows 2008 r2 nlb.  In IIS I enable windows authentication all other authentication is disabled.


code behind

       protected void Page_Load(object sender, EventArgs e)
            if (!Page.IsPostBack)
                Response.Write("Auth user: " + Request.ServerVariables["Auth_User"]);
                Response.Write("Logon user: " + Request.ServerVariables["LOGON_USER"]);


        <authentication mode="Windows" />        
            <deny users="?" />            

        <compilation debug="true" targetFramework="4.0" />

The code returns the application pool custom account e.g. DOMAIN\WebApp_user.  What I want is the logged in user's username.  How do I get this? 

Identity column in Management Studio


I am teaching a beginning class on SQL Server 2008 (not Express, and not R2), and we have begun using Management Studio.  One of the exercises included creating a small table with an identity column.  I then asked the students to insert some data just to see how the identity column works.

Strangely enough several of the students discovered that the identity column was increasing not by 1 but by some other integer.  I checked the Increment property and it was 1 in all cases.

What would cause this?  I have never see this before.

Merge Replication - Publisher Identity Range Assignment with Disconnected Subscriber


Hello everyone,

I have a merge replication topology setup as follows...  Publisher - SQL 2008 SP1, Distributor - SQL 2008 R2 (RTM), Subscriber - SQL 2008 SP1.

I recently had my subscriber disconnected for a couple days.  During this time, I was getting the following error on my publisher:

The insert failed. It conflicted with an identity range check constraint in database 'production', replicated table 'dbo.CustomerOrder', column 'CustomerOrderId'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.

I understand why I would normally get this error, but if the publisher and distributor are both online, why didn't the publisher attain a new range from the distributor after it hit its threshold?  Is this expected behavior whenever a subscriber is disconnected?

Thanks in advance.


Trouble with Identity Range Sizes


I am trying to setup our replication with a republisher.  We, unfortunately, have some tables with an int PK IDENTITY and I am getting the following error when trying to create the publication.

SQL Server Management Studio could not create article 'tblAdminBusinessType'. (New Publication Wizard)


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The republisher's republishing range obtained from its publisher is not large enough to allocate the specified @pub_identity_range.
The article 'tblAdminBusinessType' could not be added to the publication 'Stage_Connect'.
Changed database context to 'Stage_Connect'. (Microsoft SQL Server, Error: 20660)

I changed the Publisher range size to 100000 and the Subscriber range size to 100.  What I am not understanding is why this even matters, this table is marked as download only at both the Primary Publisher and the Re-Publisher.  It can't be updated anywhere BUT directly on the Primary so what's the issue.  

Secondly, how do I overcome this?  Do I just keep massaging the numbers till it works?  What, specifically, is it looking for?



Thank you,

ListViewControl - how to group items by their value, for eg. date range



I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)


Yoga Class (15th Feb 2010 - 16th Feb 2010)

Thanks for help.

Pass ASP.NET membership identity object across domain?


I am trying to figure a way to SSO with ASP.NET membership and role model.

I can implement custom membership provider which consume web services hosting on a server.

With encryption of data. No problem.

But my question is, If I sign on a website with my provider, got my identity object on that application,

could I pass it to another website on another domain which use the same provider and by doing so, do not need to login again?

If this is possible, I am going to implement this solution. Please tell me what's your take on this.

System.DateTime.AddDays: Value to add was out of range.


I'm getting the following error:

[ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value]
   System.DateTime.Add(Double value, Int32 scale) +7657639
   System.DateTime.AddDays(Double value) +19

The line from which this error originates has the following code:

expires = Now.AddDays(30)

It occurs irregularly and irreproducably. The server date/time is correct and set to GMT. I've heard that it could be some curiosity to do with timezones, but that is speculative.

It seems that we're some time from the year 10,000 yet, so I can't understand why adding thirty days to the current time could cause this! Any ideas? Culture settings perhaps?

Federated Identity: Passive Authentication for ASP.NET with WIF


The goal of federated security is to provide a mechanism for establishing trust relationships between domains. Platform tools like Windows Identity Foundation (WIF) make it much easier to support this type of identity federation. We show you how.

Michele Leroux Bustamante

MSDN Magazine August 2010

AD FS 2.0 in Identity Solutions: Using Active Directory Federation Services 2.0 in Identity Solution


This article explains how you can use Active Directory Federation Services (AD FS) 2.0 to claims-enable Windows Communication Foundation (WCF) services and browser-based applications. The focus is on the token issuance functionality in AD FS 2.0. You'll find out how to use AD FS 2.0 as an identity provider; set up an AD FS 2.0 security token service (STS) to interact with WCF; federate AD FS 2.0 with your custom STS or another AD FS 2.0; enable Web single sign-on and federation with WS-Federation and SAML 2.0 protocols; and externalize authentication logic through Visual Studio. You'll come away appreciating how AD FS 2.0 and Windows Identity Foundation make programming identity solutions in Windows less of a chore.

Zulfiqar Ahmed

MSDN Magazine November 2009

CLR Inside Out: Thread Management In The CLR


Getting the performance you want in concurrent applications is not as straightforward as you might think. See how common threading issues can affect your application.

Erika Fuentes and Eric Eilebrecht

MSDN Magazine December 2008

Pooled Threads: Improve Scalability With New Thread Pool APIs


The new threadpool APIs in Windows Vista and in the upcoming Windows Server 2008 provide advances that even native Windows developers can benefit from.

Robert Saccone

MSDN Magazine October 2007

Security Briefs: Exploring Claims-Based Identity


Keith Brown introduces you to the new identity model in the Microsoft .NET Framework 3.0.

Keith Brown

MSDN Magazine September 2007

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