Replication Issues Upgrade To SQL 2005.
Aug 13, 2006
Hi Everyone:
I am not sure if I should be posting this question in the setup forum. I apologise if this is the wrong forum. My question is simple and straightforward.
1). What are the things that I should consider while upgrading Replication from SQL 2000 to SQL 2005 Assuming
Case A : My SQL Server 2000 is the Publisher.
CASE B: My SQL Server 2000 is the Distributor
CASE C : My SQL Server 2000 is the Subscriber.
Any documents, whitepapers or KBs or related posts would be helpful. MS SMEs please share your thoughts.
Thanks
AK
View 1 Replies
ADVERTISEMENT
Aug 17, 2005
Where can i find some reference material on how to upgrade to 2005 in a replicated environment please?
does anyone know what order i need to tackle the servers, is it likely to be the same as the Service Pack process?
cheers
View 3 Replies
View Related
Apr 17, 2008
Hi All,
Currently we use SQL 2K SP4 and snapshot replication with a Central Publisher with Remote Distributor toplogy.
I am looking to upgrade or migrate our SQL servers to SQL 2005 and was wondering what is the best way to do this for our replicated architecture?
Is the best way to run the SQL 2005 Upgrade on all 3 servers (publisher, distributor, subscriber) and should it automatically upgrade the servers including the replication components? Is there anything i should consider/watch out for when doing the upgrade and it involves replication (namely snapshot replication)?
Thanks in advance.
View 1 Replies
View Related
May 15, 2006
I'm try to upgrade SQL Server 2005 Evaluation with tuned up and worked merge replication.
- I'm insert disk with licensed SQL Server 2005 Enterprise, start installation - in process, indicate instance for installing, in list of options appears I see option "ugrade"
- All passes fine and go on:
After upgarde I'm get completely broken merge replication!
Moreover, such feeling that certain strange troubles with SQL Agent:
all points context menu in Replication Monotor - disabled and if I try to start replication manually through jobs - too failed - with some error "agent shutdown" !
I'm try to build "clear" situation: install in Virtual PC Windows 2003 Ent SP1, SQL 2005 Eval and setup my test replication and upgrade SQL Server to Enterprise version - and get same trouble too!!!
What the best way to uprade my evaluations sql servers with replication to licensed version SQL Ent?
View 2 Replies
View Related
Jan 19, 2007
Hi,
We are performing a SQL 2005 SP1 upgrade from SQL 2000 on our Windows 2003 SP1 Standard Edition.
When we run the upgrade, we got a error "Upgrade Advisor Return -1" as a pop-up window.
When we run the Upgrade Advisor separately, we get this error :
===================================
Common Language Runtime detected an invalid program.
===================================
Common Language Runtime detected an invalid program. (System.Xml)
------------------------------
Program Location:
at System.Xml.Schema.SchemaInfo..ctor()
at System.Xml.Schema.XmlSchemaSet..ctor(XmlNameTable nameTable)
at System.Xml.XmlReaderSettings.get_Schemas()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReportController.LoadAndValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReport.ValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAIssueReport.Refresh()
at Microsoft.SqlServer.UpgradeAdvisor.ReportPanel.OpenReport(String reportFile)
We are in a lost for solutions. We do hope to hear from anyone asap...
Greatly appreciated for any kind assistance.
Thanks.
View 1 Replies
View Related
Feb 10, 2007
Hi,
We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got:
MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'.
Here is a portion of the error log:
Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
Database Mirroring Transport is disabled in the endpoint configuration.
Starting up database 'master'.
Converting database 'master' from version 589 to the current version 611.
Database 'master' running the upgrade step from version 589 to version 590.
Error: 946, Severity: 14, State: 1.
Cannot open database 'master' version 589. Upgrade the database to the latest version.
System Task Aggregate global counters produced an error that was not handled. Major: 9, Minor: 46, Severity:14, State:1
Error: 928, Severity: 20, State: 1.
During upgrade, database raised exception 15151, severity 16, state 1, address 01C4C50B. Use the exception number to determine the cause.
Error: 15151, Severity: 16, State: 1.
Cannot find the endpoint 'TSQL Local Machine', because it does not exist or you do not have permission.
Any help would be greatly appreciated
Thanks KR
View 7 Replies
View Related
Mar 7, 2002
Hi guys.
I have two scenerio.
One:
Two servers (SQL 7.0), transaction replication
Two:
Four servers (SQL 7.0), transactional replication one publisher, one distributor and 2 subsribers.
I need to upgrade these two scenerio to 2000.
Please advice me with suggestions and your experience.
Is Online replication possible?
-MAK
View 1 Replies
View Related
Mar 30, 2007
I have 2 sql server 2k systems to upgrade to sp4 from sp3.
The reason for replication is that the subscriber system backs up the
publisher/distributor system.
My understanding is that I should upgrade the Publisher first,
and then the subscriber.
Since these systems are a primary system, and a backup,
it is desirable to upgrade one, and then another at a later time.
I would prefer to upgrade the subscriber - the backup system - first.
Questions :
1) Is it possible to upgrade the subscriber first in a replicated environment ?
2) If I upgrade the publisher first, do I need to next upgrade the subscriber,
or can I wait a significant time before upgrading?
JYard
UCLA
View 3 Replies
View Related
Feb 8, 2007
Hello,
I have the following scenario. An application using SQL Server 2000 SP3 on the server side and clients using MSDE 2000A (SP3a) on the client machine. Since the client is offline quite often merge replication is used to keep the clients in sync.
Now we try to upgrade to SQL Server 2005 SP1. The publisher and distributor upgrade (on the same box) worked fine and all clients could still synchronize. Fine :-)
Now we try to upgrade the clients to SQL Express SP1. Now the problems start :-(
1) After the upgrade the entry within the Synchronization Manager is gone (we can overcome this by using sp_MSregistersubscription or by manually disable and enable Synchronization manager on the subscription properties)
2) Initial Synchronization (takes a long time but) works fine, if I apply changes to the subscriber or force a reinitialize all following synchronization will fail. With the following messages:
Error messages:
The merge process could not clean up the subscription to 'tstvmw23':'TestBase:'TestBase'. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200965)
Get help: http://help/MSSQL_REPL-2147200965
New request is not allowed to start because it should come with valid transaction descriptor. (Source: MSSQLServer, Error number: 3989)
Get help: http://help/3989
Remark the test system I use is a nearly empty db (only with full schema and a few lookup tables) with 15MB. The same error occures if I create a new database an subscribe to the same publication.
Please help otherwise I'm forced to step back to MSDE.
Thanks in advance,
Thomas Hotz
View 3 Replies
View Related
Jan 16, 2008
I am out of brain cells. I can not figure out how to upgrade instances of sql express to sql 2005 or even add an instance of sql 2005. I have installed/upgraded everything else (SSMS, etc.) to SQL 2005.
I am dazed and confused. I don't even know where to start in explaining what I have tried and done. I have 303 log files going back to 3/27/2007 from various attempts.
Where do I start in figuring this debacle out???
View 7 Replies
View Related
May 25, 2007
I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.
Any recommendations on the best way to do this would be greatly appreciated.
thanks!
View 3 Replies
View Related
Feb 25, 2008
I am trying to upgrade SQL Server Express 2005 Report Server to SQL 2005 Standard and it fails with the following error:
SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting ServicesReportServer
ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
After I click OK on the message, this whole path where the upgrade is bieng installed dissapears C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting Services. The error is a bit missleading because the file that it is trying to copy rssrvpolicy.config does appear in that upgrade folder so I am not sure why it would try to copy a file that has already been copied.
I was able to upgrade the Database Engine instance fine but can't upgrade Reporting Services due to that error. I have verified that the account that ran the setup had the administrator permissions. Your prompt reply to my question would be greatly appreciatted.
View 4 Replies
View Related
Jul 29, 2006
if i upgrade from sql server 2005 expressto sql server 2005 enterprise can i do it ?
am i need to uninstall 2005 express before ?
View 1 Replies
View Related
Dec 29, 2006
Hi
I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition.
(As a Preparation to install SQLServer2005 Service Pack 2 (CTP))
I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).
During the upgrade I get a message saying that ...
.....Your upgrade is blocked because of edition upgrade rules.....
All other components I selected for Installation are propertly installed (Analysis, Reporting)
The setup log contains the following detail information:
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29543
MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142
---- Context -----------------------------------------------
I also tried to explicitly upgrade the OFFICESERVERS instance by executing Setup from the command shell:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=OFFICESERVERS UPGRADE=SQL_Engine SKUU
PGRADE=1 /qb
The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...
Does anybody know about this problem?
Some more information about the system:
W2K3 R2 Enterprise Edition
WSS3.0
MOSS2007
previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)
Kinde regards
Andreas
View 5 Replies
View Related
Mar 12, 2008
I've been reading and looking over what to do for my situation for several days. I need to ask and see if I can get a clear answer.
My Scenario:
I have a SQL Server 2005 Eval installed that is currently running with live data. I need to upgrade that to a recently-purchased full version. I have several databases set up. I have ready the article 914158 that states it will fail. It's still running so I can access everything. If I restart or stop the service I'm screwed.
That do I do?
Thanks so much!
View 4 Replies
View Related
Aug 8, 2006
Can we upgrade from Express 2005 to Standard/Workgroup 2005??If possible with what complexities can it be done??
View 1 Replies
View Related
Jun 15, 2007
I'm getting this, after upgrading from 2000 to 2005.Replication-Replication Distribution Subsystem: agent (null) failed.The subscription to publication '(null)' has expired or does notexist.The only suggestions I've seen are to dump all subscriptions. Sincewe have several dozen publications to several servers, is there adecent way to script it all out, if that's the only suggestion?Thanks in advance.
View 3 Replies
View Related
Jun 8, 2006
Hi
we have installed SQL 2005 Standard and we are planning to upgrade to SQL 2005 Enterprise version. Do i need to uninstall SQL 2005 Standard and reinstall Enterprise or i can install SQL 2005 Enterprise on top of standard version to upgrade.
Thanks a lot in advance
View 1 Replies
View Related
Nov 1, 2007
Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place?
View 4 Replies
View Related
Nov 1, 2007
Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place.
View 12 Replies
View Related
May 7, 2008
i have a server which is configured with sql 2005 and when i schedule a backup all the databases do not get listed while selecting (all databases) while scheduling ...then i found that there are some databases with the cmpt level 70 and those databases do not get listed while scheduling backup,, is there any solution for this ... how to change the cmpt level.. from 70 to 90, is there any precautions i need to take care ....is it possible to do the above...pls help
View 1 Replies
View Related
Sep 25, 2007
Upgrading from 2000 to 2005. Just want to know what is going to break. I need to have a plan.
I know DTS is going to break. Any other things?
=============================
http://www.sqlserverstudy.com
View 13 Replies
View Related
Jun 20, 2006
I'm planning to upgrade a SQL server 7 database to a new server with SQL 2005 soon.
I will follow the migration path for the upgrade and my question has to do with my back-out plan.
When we go live on a Monday morning, I will leave my SQL server 7 box n stand-by mode in case anything goes wrong with the new server.
Is there a way to get the new data back into my stand-by SQL server 7 in case the new SQL 2005 server has issues after going live?
Let's say the new server runs for two hours and I need to revert back to my SQL 7 server, What would be the best approach for this scenario???
Thanks
Alfonzo
View 1 Replies
View Related
May 10, 2006
I am running MSDE2000
will the installation of MSDE2005 (sqlexpr.exe) recognise this
installation (and it's databases) and upgrade it
just to be sure ...
Regards
Patrick
View 3 Replies
View Related
Aug 17, 2006
Hi all,
We need to update our SQL 2000 to 2005. We plan to use it on a computer with 2 processors. Actually we update 2 servers that form a cluster, running web applications.
I think there is no update version from 2000 to 2005. So we have to buy 2 full versions of SQL 2005? For our case it's probably best to buy SQL 1CPU version? But we have 2 processors on each server. Is there a CPU license? Do we have to buy 2 SQL 2005 1CPU plus 2 licenses for 1 (more) CPU?
Sorry, I am not so familiar with SQL. I am not the guy making the upgrade. I just have to order the correct version and licenses.
View 1 Replies
View Related
Nov 15, 2007
We currently have a deployment of SQL 2000 on three production 32 Bit servers. One server to house the Data, one server for Analysis Service Cubes, and one for Reporting Services. At the time of this deployment, this was Microsoft's recommendation.
If we upgrade to SQL 2005 and also upgrade our systems to 64 Bit systems. What are the recommendations for Analysis Services and Reporting Services? Do they still require separate servers or can they reside on the same server?
Thanks
View 1 Replies
View Related
Nov 29, 2006
I have a Windows 2003 server running both a MSDE and SQL 2005 Database. I want to upgrade SQL to SP1. Does anyone know if upgrding SQL 2005 to SP1 will affect the MSDE?
Thanks -- Nor
View 3 Replies
View Related
Dec 11, 2007
Hello,
I have a project where I have to upgrade SQL 2000 to 2005. When we are upgrading we are going to move to new server so server name will change. Most of our applications have a hard coded connection string. Applications are developed with Classic ASP, .NET 1.1 and 2.0 as well.
Now the question is what is the best way to do this? Changing all the connection string will be a very painful task as we have many applications.
Can anyone suggest a way where we can achieve this without changing all the connection strings?
Thanks in advance.
Tareq
View 5 Replies
View Related
Aug 2, 2007
Hi Experts,
We have SQL Server 2005 Standard edition in a box. We need to update (install) that box with SQL Server Developer editions. Please let me know what are the ways to do it.
Thanks in advance,
Hariarul
View 4 Replies
View Related
Oct 20, 2007
hi All .
I use Micorosft SQL 2005 upgrade advisor to upgrade from sql 2000 to sql 2005, but I got problem .
here is my problem .
On my machine I have Sql 2000 Developer without server pack, and Sql server 20045 express edition .
Please help me to overcome this problem .
Many thanks in advance .
regards,
QuachNguyen
View 1 Replies
View Related
Oct 24, 2007
what are some of the issues that we might face while upgrading from SQl 2000 to SQl 2005? Actually I have to create upgrade plan for path from MS 2000 to MS 2005.
Any suggestions will be appreciated.
Thanks
View 1 Replies
View Related
Nov 27, 2007
Hi,
I was wondering if anyone could point me in the right direction for upgrading from SQL 2000 to SQL 2005?
I was under the impression that it was as easy as following an upgrade path after popping in the CD, but I realized it's not.
I'm a Systems Administrator who has installed both version in stand alone systems, but never tried an upgrade.
Thanks for your help.
View 2 Replies
View Related
Dec 4, 2007
Hello,
I'm getting an error when attempting to do an upgrade (from 2000 SP3) install of SQL 2005 on my W2K3 server. (The server is my AD controler as well.)
The error is as follows:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user WTBHOMEAdministrator to local group SQLServer2005SQLAgentUser$XXXXXX$MSSQLSERVER.
I Googled the error and tried the suggestion to manually add the account to the group, but when I run the setup again, I still have the same problem.
Any and all help is greatly appreciated!
View 4 Replies
View Related
