3
2012
SSIS package 2k5-> 2k8 R2 upgrade failed with error – Failed to decrypt protected XML node “DTS:Property”…
Scenario is when you are trying to open or upgrade SSIS package created in SQL 2005 to SQL 2008 R2 then you may encounter below error and your package upgrade will fail, please find few tips on resolving this error below. Error Description: Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”. You may not be authorized to access this information. This error occurs when […]
11
2012
Upgrade SQL Server 2000 Active/Active cluster to SQL Server 2005 and Windows 2003 with High Availability
Part 1: Team composition and upgrade option pros and cons – http://searchsqlserver.techtarget.com/tip/Upgrade-Active-Active-cluster-to-SQL-Server-2005-and-Windows-2003 Part 2: Restoring a SQL Server database to a transition server – http://searchsqlserver.techtarget.com/tip/How-to-restore-SQL-Server-database-to-transition-server-during-an-upgrade Part 3: SQL Server high availability when upgrading to SQL Server 2005 – http://searchsqlserver.techtarget.com/tip/SQL-Server-high-availability-when-upgrading-to-SQL-Server-2005 Part 4: Upgrade live applications to SQL Server 2005 for high availability – http://searchsqlserver.techtarget.com/tip/Upgrade-live-applications-to-SQL-Server-2005-for-high-availability Part 5: Monitor database mirroring and replication after upgrade – http://searchsqlserver.techtarget.com/tip/Monitor-database-mirroring-and-replication-after-a-SQL-Server-upgrade
15
2011
Redirecting SQL Client connection to different instance of SQL who is listening to 1433 (default port) without altering client ConnectionString
Here is a very useful article by Vipul T. Shah via his blog http://blogs.technet.com/b/vipulshah/archive/2010/06/07/redirecting-sql-client-connection-to-different-instance-of-sql-who-is-listening-to-1433-default-port-without-altering-client-connectionstring.aspx Excerpt from his article, Scenario: Current Setup: SQL Server 2005 Default instance – PRODServer listening at default port 1433 Client Connection String using SQL Native Client – Provider=SQLNCLI ; Server=PRODServer; Database=PRODDB; Trusted_Connection=Yes; with TCP/IP protocol with default port 1433 Now – Upgrade Happens… a side-by-side upgrade on a same server. New Setup: SQL Server 2008 Named Instance – PRODServer\NewPRO Now if […]
6
2010
Useful resources for migrating to SQL Server 2005
Looking for SQL Server 2000 to SQl Server 2005 migration, useful resources available at following link: http://blogs.technet.com/b/vipulshah/archive/2006/11/30/useful-resources-to-pitch-for-migrating-to-sql-server-2005.aspx Comparing Enterprise Development Productivity: SQL Server 2005 versus SQL Server 2000 http://www.microsoft.com/sql/prodinfo/compare/devprod2000.mspx “This independent productivity study, conducted by 3 Leaf, compares two developers working independently to provide the same added features and functionality to a baseline application. One developer worked with SQL Server 2005, and the other used SQL Server 2000. Bycomparing the time required by each developer […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5