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


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

SQLCF 3.5 SP2 Replication Issue: An instance of the SQL Server Reconciler error object cannot be cre

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 
Hi, we have a desktop application synchronizing with our SQL server using merge replication via IIS6.

Previously we used SQL2005 Ent database server, SQLCF 3.5SP1 tools and runtime library were installed on IIS machine, the desktop application was compiled with SQLCF 3.5 SP1 runtime as well.

Last week we upgraded our server to SQL 2008 R2, the application has been broken since then.

We tried to upgrade to SQLCF 3.5 SP2 tools and runtime on IIS ==> didn't help
We tried to install SQLCF 3.5 SP2 on the desktop where the application running (but left the application unchanged) ==> didn't help

Could anybody here help me with this? Do I need to re-compile my application?

Here are some debug information:
SQLCESALOG.TXT: Thread=1284 RSCB=1 Command=SYNC Hr=00000000 Failed to use 10.0 error components. Exiting... 0

Diagnostics:
Impersonation and Access Tests Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

SQL Server Compact Modules Test Module Status ErrorCode Version
sqlcerp35.dll SUCCESS 0x0 3.5.8080.0
sqlcesa35.dll SUCCESS 0x0 3.5.8080.0

Reconciler Test Reconciler Status ErrorCode
10.0 Database Reconciler SUCCESS 0x0
9.0 Database Reconciler SUCCESS 0x0


Any help would be appreci


View Complete Post


More Related Resource Links

Error addning replication componet to existing SQL Server 2008 Instance

  

I have attempted to add the replication components to a named instance of SQL server 2008 running on a Windows 2008 server standard without Hyer-V SP2 and I get the following error entry in the Summary file:

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2068643839
  Exit facility code:            1203
  Exit error code:               1
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2011-05-16 20:59:26
  End time:             

error: 26 - Error Locating Server/Instance Specified

  
Today I installed a named instance on a SQL 2005 Standard X64 SP3 server running on Windows 2008 R2. From a remote server with SQL Server Management Studio I can connect to the default instance, but when I try to connect to the named instance it returns Cannot connect to <server>\<instance> A network-related or instance-specific error occurred while established a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server). Locally I can connect to both instances. Below is the output of portqry.exe. C:\Temp\PortQryV2>PortQry.exe -n <server> -p tcp -e 1433 Querying target system called:  <server> Attempting to resolve name to IP address... Name resolved to <ip> querying... TCP port 1433 (ms-sql-s service): LISTENING C:\Temp\PortQryV2>PortQry.exe -n <server> -p udp -e 1434 Querying target system called:  <server> Attempting to resolve name to IP address... Name resolved to <ip> querying... UDP port 1434 (ms-sql-m service): LISTENING or FILTERED Sending SQL Server query to UDP port 1434... UDP port 1434 (ms-sql-m service): FILTERED The SQL server, agent, and browser services are running.

Object reference not set to an instance of an object error.

  
i've installed the VSeWSS.msi on VS 2005, i'm using SPS 2007, i'm developing on my workstation in C#, i've added the Mircosoft.Sharepointserver dll reference to my project but i still can't deploy a very basic webpart. i get the "Object reference not set to an instance of an object" error but there's no reference to a line, column, project or anyhting. very frustrating. any suggestions/links whould be appreciated.

Login error - Object reference not set to an instance of an object.

  
Hi all,I've set up the login section as a user control. WheneverI log in I get a "Object reference not set to an instance of an object", with the code stopping on this line: if (Membership.ValidateUser(txtUserName.Text,txtPassword.Text))Can anyone tell me how to fix this please?protected void LoginButton_Click(object sender, EventArgs e) { TextBox txtUserName = loggedin.FindControl("UserName") as TextBox; TextBox txtPassword = loggedin.FindControl("Password") as TextBox; CheckBox ckbRememberMe = loggedin.FindControl("RememberMe") as CheckBox; if (Membership.ValidateUser(txtUserName.Text,txtPassword.Text)) { FormsAuthentication.RedirectFromLoginPage(txtUserName.Text, ckbRememberMe.Checked); } else { // Msg.Text = "Login failed. Please check your user name and password and try again."; } } <asp:LoginView ID="loggedin" runat="server"> <AnonymousTemplate> <asp:Login ID="Login1" runat="server"> <LayoutTemplate> <table id="mainbox" width="400"> <tr> <td width="150" class="label">

Error: 26 Error Locating Server/Instance Specified

  
hi All   i am Facing a problem to connect SQL Server 2008 Express on Local Server when i connect through below Connection String return @"Data Source=MAINSERVER\SQLEXPRESS;Initial Catalog=AccountMenagmenta;Integrated Security=SSPI"; i am facing a Error Error is "A Network - related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: SQL Network interface, error: 26 error locating server/Instance specified)   any help me to this shotout Regard!   Hitesh Patel

Error while export to pdf-Object reference not set to an instance of an object

  
Hello, I am getting error while rendering the report to pdf in SSRS 2008. This is happening randomly and sometimes I get this error. I have SQL Server 2008 SP1 installed in my system . I installed the cumulative update 1 for SP1 also but no luck. Every time when export to pdf fails, SSRS is creating the dump file in the logs. I have captured the log of this specific error. Please let me know if you have any idea about this.   reportrendering!ReportServer_0-297!1ec4!03/30/2010-10:32:57:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report., ; Info: Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object.   at Microsoft.ReportingServices.Rendering.HPBProcessing.Paragraph.get_SpaceBefore()   at Microsoft.ReportingServices.Rendering.RichText.LineBreaker.FlowParagraph(Paragraph paragraph, Directions direction, IntPtr hdc, Single dpiX, FontCache fontCache, FlowContext flowContext, Boolean keepLines, SizeF flowContextSize, Int32& contentOffset)   at Mi

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

  
I know what the problem is. I am just not sure how to fix it. I get the error below when I have this: < roleManager enabled="true" />  It works fine when I set rolemanager = false but I need to use membership roles.   my connection strings are:  <connectionStrings> <add name="ConnMSSQLASP" connectionString="Data Source=MISFS;Initial Catalog=ASPNetDB;User Id=----;Password=-----;" providerName="System.Data.SqlClient"/> <add name="DisasterRecoveryConnectionString" connectionString="Data Source=MISFS;Initial Catalog=ASPNetDB;User Id=----;Password=----" providerName="System.Data.SqlClient"/> </connectionStrings>    Can someone help me with this? ERROR Below: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error: The connection string s

network - related or instance-specific error occurred while establishing a connection to sql server

  
A co worker tried installing sql2008 express on his home laptop and had a problem, i downloaded the install and installed again (didnt remove orig install ( prob should have))  now when i try to connect using Server type : Database Engine  Server name : . or .\SqlExpress with window auth i get the message:Cannot connect to ..Additional Info : A network - related or instance-specific error occurred while establishing a connection to sql server

A network-related or instance-specific error occurred while establishing a connection to SQL Server

  
I got this error when i try to connect to sql server10.0  from c# 2008 express. any idea.Pedro

network-related or instance-specific error occurred while establishing a connection to SQL Server

  
I have two database one on sql server 2000 and other on 2005. When i am connecting my application through web serviceit gives exception:"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"with sql server 2000 no such problem occurs. I have cheked the firewall and web.config connection string also.

Help with Object reference not set to an instance of an object. error.

  
I was given a chunk of code to help with accessing dynamic forum controls about a week back and when I implemented the code I get the error "Object reference not set to an instance of an object". I asked in the thread the code was given but have not recived an answer yet (asked about 4 days ago) and I think that is beause  the thread is marked as resolved. The line of code  causing the error is   if(t.Equals(this.ddlAmountToAdd.ClientID)&&!string.IsNullOrEmpty(v))    And here is the full code for the c# .Net 4 page.using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class GameInformation_AddUpcomingRelease : System.Web.UI.Page { public string[] Regions = { "USA", "Japan", "Europe", "Other" }; //Create a string array of regions. public string[] Platforms = { "PlayStation 3", "X-Box 360", "Wii", "Computer", "PSP", "Other" }; //Create a string array of platforms. protected void Page_Load(object sender, EventArgs e) { ddlPlatform1.DataSource = Platforms; ddlPlatform1.DataBind(); ddlRegion1.DataSource = Regions; ddlRegion1.DataBind(); } protected override void OnInit(EventArgs e)

Unable to install SQL Server 2005 Express: The error is (-2146885628) Cannot find object or propert

  
I am installing 2 instances of SQL Server 2005 Express for 2 different accounting packages on Windows XP SP3.  I have the first installed, after much use of the forums.  The version of setup.exe was 2005.90.2047.0. I am not able to install the second, for Microsoft Office Accounting 2009, setup.exe version 2005.90.3042.0.  The error I am getting in Summary.txt is: Error String    : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is  (-2146885628) Cannot find object or property. Error Number    : 29503 The errorlog file for MSSQL.2 has a lengthier description: 2009-09-05 23:00:32.13 Server      Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)     Feb  9 2007 22:47:07     Copyright (c) 1988-2005 Microsoft Corporation     Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 2009-09-05 23:00:32.31 Server      (c) 2005 Microsoft Corporation. 2009-09-05 23:00:32.31 Server      All rights reserved. 2009-09-05 23:00:32.32 Server      Server process ID is 5516. 2009-09-05 23:00:32.32 Server      Authentication mode is MIXED. 2009-09-05 23:00:32.35 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'. 2009-09-05 23:00:32.38 Server      Regi

Configure managed accounts - object reference not set to an instance of an object - error

  
I was working in central admin and activated the managed accounts password change for the farm account with the option to change the password now.  I got the email notification that the password was changed and it seems in the log files that it did update all the credentials that were used with the account.  Problem is now that when I hit the configure managed accounts link in central admin all I get is the error: Error Object reference not set to an instance of an object.  Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: c6dc7a46-894f-4b85-8711-8af1e8ec7903 Date and Time: 8/23/2010 9:20:20 AM Added information from logs: 08/23/2010 10:41:33.24  w3wp.exe (0x0F2C)                        0x07FC SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (GET:http://cmtcalcium:33333/_admin/ManagedAccounts.aspx) b9fae5a9-7405-407d-87fc-239dc0ff59d0 08/23/2010 10:41:33.24  w3wp.exe (0x0F2C)                        0x07FC SharePoint Foundation     &n

Error message in opening a view after Replication server restored

  
Hi, Yesterday Replication was broken as Publisher was down. After it was restored, I tried to open a view in Subscriber and I get the following error message [Microsoft] [ODBC SQL Server Driver] [SQL Server] Login failed for user 'Repl admin'   Any suggestions to get around this problem.   Thanks in advance -Jaya

Giving me an error "Object reference not set to an instance of an object."

  
Hello Everyone, I am currently developing a website for online examination.  For that I have to collect user information at the time of registration. I want to develop a 3-tier application. I have SignUpWizard. Aspx page. I have also created 3 classes (Users.cs, UserDAL.cs and UserBAL.cs) and 1 stored procedure (InsertUserInfo).Code for Users.cs:using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; using System.Web.Security; using System.Data; namespace ITIL.DomainModels { public class Users { public int UserID { get; set; } public string FirstName { get; set; } public string LastName { get; set; } public string Username { get; set; } public string Password { get; set; } public string EmailAddress { get; set; } public string dateTime { get; set; } public string IPAddress { get; set; } public string SecurityQuestion { get; set; } public string SecurityAnswer { get; set; } } }Code for UserDAL.cs:using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using System.Configuration; using ITIL.DomainModels; namespace ITIL.DAL { public class UserDAL { publi

The SQL Server performance counter 'Page Splits/sec' (instance 'N/A') of object 'SQLServer:Acce

  
I am getting these page split errors every 5 minutes I have tried everything reindexing rebuilding working with different fill factor values But nothing seems to effect this problem. The threshold is now set to 100 (what the max threshold number i can set the alert to ?) Also please let me know how to get rid of the pagesplit alerts. thanks

Error Enrolling Instance In Utility Explorer SQL Server 2008R2

  
When I try enrolling an instance the enrollment errors with "The collection sets on the specified instance of SQL Server must be stopped." I have stopped all the collection sets in various manners including disabling the scheduled job, all with no success. Any suggestions as to what else I can check? I have successfully enrolled another instance on the same server. Thanks!  
Categories: 
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