Dynamics GP 2013

Below are the products that are no longer supported with Microsoft Dynamics GP 2013:

1. All editions of Microsoft SQL Server 2005
2. All editions of Microsoft Windows 2003
3. All editions of Microsoft Windows XP
4. All editions of Microsoft Windows Vista
5. Microsoft Office 2007
6. Windows SharePoint Services 3.0
7. Microsoft Office SharePoint Server 2007
8. Office Communicator 2007
9. Internet Explorer 7.0

Improve your presentation and demo skills

I went through the MCT Quarterly updates and one of the interesting videos was the " Improve your presentation and demo skills"

Speaking about the real life scenarios that occur when doing a presentation or a demo, how to prepare and what to avoid was really interesting.

You will find more details on the below link:

http://borntolearn.mslearn.net/mct/p/quarterlyupdates.aspx#fbid=bwWZrIAY8bt

Collections Management for Dynamics GP

Collections Management for Microsoft Dynamics® GP transitions back to the original Independent Software Vendor (ISV) After a successful 12 year licensing relationship, Microsoft is transferring the ongoing sales, maintenance and support of the Collections Management back to Professional Advantage, the authors of the software. Effective June 1, 2013, Collections Management for Microsoft Dynamics GP will no longer be offered by Microsoft and all associated SKUs will be removed from all versions of the Microsoft Dynamics GP Price List.  Please note that Collections Management will continue to be offered under the Microsoft Services Provider License Agreement (SPLA) until further notice.  Beginning June 1, 2013, new licenses to Collections Management will only be available for purchase via channel partners registered with Professional Advantage.  Microsoft Dynamics GP channel partners are requested to register with Professional Advantage to ensure their existing customers are able to obtain new releases, enhancements and support for Collections Management.   Microsoft will continue to meet its obligations for Collections Management that it released through the support lifecycle for the applicable version of Microsoft Dynamics GP. These changes affect Microsoft Dynamics GP customers on Module Based licensing (MBL) and Perpetual Licensing who previously obtained licenses to Collections Management via the Microsoft Dynamics GP price list, and all Microsoft Dynamics GP Advanced Management customers on Business Ready Licensing (BRL).  All of these customers with licenses to Collections Management will continue to receive new releases, enhancements and support by signing up for a maintenance plan with Professional Advantage through their channel partner.   As of this announcement, Professional Advantage will make a new release of Collections Management available June 1, 2013, that is enhanced with new features and functionality including: significant timesaving improvements, utilizing collection plans to automate collection steps; integration with non-Microsoft Dynamics GP invoicing systems; Quick Start setup wizards; and improved reporting. See Professional Advantage’s  roadmap for more details. More information about this relationship change is located on PartnerSource here.

Upgrade Great Plains 8.0 to Dynamics GP 10

This article describes the steps to upgrade a Great Plains 8.0 application running on top of SQL Server 2000 into Dynamics GP 10 running on top of SQL Server 2005.

1. Back up Dynamics database & company database from SQL Server 2000
2. Restore Dynamics database & company database to SQL Server 2005
3. In SQL Server 2005,  SQL Management Studio, select the properties of every database and change the compatibility level to SQL Server 2005 (90).
4. Install Dynamics GP 9.0 + SP3
5. Run Dynamics GP 9.0 utilities and upgrade the dynamics & the company databases
6. Install Dynamics GP 10.0 + SP3
7. Run Dynamics GP 10.0 utilities and upgrade the dynamics & company databases
8. Make sure you have enough space & memory on the machine that you are using for the upgrade.

Dynamics GP for Equipment Rentals

Check the below blog in case you are interested in the implementation of Dynamics GP in an equipment rental business:

http://mbsguru.blogspot.com/2009/04/dynamics-gp-for-equipment-rentals.html

Dynamics GP: Adding more comments on SOP Documents

Comments for Sales Order Processing (SOP) transactions are entered using a text field which allows for a maximum of 500 characters.  When the comments are saved, the text field is broken down into 4 string fields of 50 characters each.  The code that parses the text field into the 4 string fields is smart enough to avoid breaking words in half.  It will fit as many words as it can up to the last space before the 50 character mark or up to a carriage return (new line).  When the SOP documents are printed, it is these 4 comment string fields which are printed on the report.  This means that if you use carriage returns or type a comment longer than 180-200 characters, you are unlikely to see all of your comment text shown on the report.

The below blog shows step by step how you can add up to 8 lines on your SOP Documents...

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/02/02/adding-more-comments-to-sop-documents.aspx

ERP Project Management: How to conduct a Project Kick-off Meeting

ERP Project Management: How to conduct a Project Kick-off Meeting: By: Erwin L. Sison The Project Kick-off meeting is probably one of the most important meetings the project team will have to conduct ...

Community Post-Escalation, how to do it right

Community Post

Dynamics GP: Payables Applied Payments Report: Workaround

This article is to state a workaround that prints the applied payments from the Payables module in Dynamics GP 8 or newer. The workaround is a must since in the original applied payables document window, there is no print button to do so.

What can be done is to use the edit checks window (Transactions>>Purchasing>>Edit Checks) which shows the payments and the corresponding invoices that were applied to. A built in report "Computer Check Edit List" can be generated to show the needed information.

The report can be modified using report writer to add or change any fields needed.

Enjoy...

Passing the PMP certification test "Lessons Learned"

Hello Everybody,

I hope you are doing great...because actually I am J

Just wanted to tell you that I have passed my PMP certification exam on the 5^th of July 2011 and would like to share with you some points taken from my personal experience: "Lessons Learned"

A.    Ramona Boulos, PMP trainer: Simply great…

1.     The notes were superb especially the tips & tricks.

2.     The guidelines were excellent.

3.     The issues discussed during the course were just popping in the exam

4.     The duration of studying requested: Believe her you need 2 months with the average of 4 hours daily and in the weekend you need 8 hours J

5.     Driving the trainees to memorize the processes figure & formulas was invaluable.

B.     Studying for the exam: Hectic but really useful in all aspects…

1.     PMBOK guide 4th edition including all appendixes: twice…one time the hard copy and another time the pdf version being selective in searching important points.

2.     Rita Mulcahy: Well, I didn’t read the whole book, just some tips in the beginning.

3.     Sample questions: Very important, but don’t expect any of them in the exam. They are useful to put you in a state of mind on what to expect and how to respond.

4.     Google a lot: There are a lot of other PMPs who discuss sample questions and analyze the reason behind their answer.

5.     I really did a lot of research and found material that I don’t recall seeing them in the course like:

6.     Variance of triangular distribution: [(OP-PM)2 + (ML-PM)X(ML-OP)]/18

7.     Process Capability Index: PCI=(Upper Limit-Lower Limit)/6XSigma

8.     Standard Error= Sigma/Sqr Root of Number.

9.     Other info, however they didn’t show on the exam.

In case you are not able to have a study group, then you need someone to train / teach or test your knowledge with. My Fiancée here played a fantastic role; I guess she has reached a point where she is able to register for the exam J

C.     The Exam: Exquisite Experience, here are some tips...

1.     Take the morning exam if you can, you will be more concentrated; it worked for me. However you might have some hard time sleeping the night before J

2.     The 4 hours are not enough to finish the 200 questions more than once J

3.     If you are planning to do a full review; well, think twice before spending more than 5 minutes on a single question.

4.     Mark questions for review in case you don’t get the answer the first time. Believe me when you see it a second time, you will have a better perspective.

5.     Don’t do my mistake and start the exam before writing the famous processes figureJ in front of you.

6.     There were 15 minutes for review and preparation; by mistake, I pressed start and the exam time started counting. So I had to do the figure & formulas while the time was running and I lost 10 minutes.

7.     Read the questions well, watch out for LEAST, NOT, MOST, etc…

8.     Imagine yourself the project manager on the field and answer. Experience here plays an important role in choosing the best answer.

9.     The questions were too situational and needed analysis more than memorizing.

10.  About risk, well there were more than 10 questions on risk types: mitigation, avoidance, and acceptance, enhance, exploit and share.

11.  Earned value management: CPI, SPI, EAC, etc…

12.  Team development: forming, storming, norming, performing.

13.  PMI code of ethics and professional conduct: There were direct questions about respect & honesty.

14.  The processes figure is really helpful when answering questions because you can use it to link the whole project together.

15.  Don’t panic if you see the clock running quickly J; it means you have few questions left.

16.  If you finish all the 200 questions before the time is over, don’t hesitate to start a review from the beginning. You might answer questions the correct way.

17.  If time is over and you are still reviewing, cool down because you still need to do the survey and when you are finished…the result just pops in front of you. “ CONGRATULATIONS on passing the PMP examination” “Examination Result: PASS”

18.  In case you are over whelmed, don’t forget to return the locker key to the exam administrator. In my case, it was still in my pocket J

I hope I was able to give you the whole picture about my exam experience without omitting important details. Moreover, you have my contact details in case you have any queries.

Good luck to ALL.

Best Regards,

Joseph Abou Nader, PMP J

Quoted from http://www.globalknowledge.com/training/generic.asp?pageid=2252&country=United+States:

The Industry's 10 Best IT Certifications

The Industry's 10 Best IT Certifications

IT pros tend to have strong opinions when debating the value of professional certification - and views become even more polarized when it comes down to a discussion of which certs are meaningful. Erik Eckel put together a list of the accreditations he believes currently hold value for IT pros.

IT certifications boast numerous benefits. They bolster resumes, encourage higher salaries, and assist in job retention. But which IT certifications are best?

Technology professionals generate much debate over just that question. Many claim vendor-specific programs best measure a candidate's skills, while others propose vendor-independent exams are the only worthy way of measuring real-world expertise. Still other observers believe the highest-level accreditations - Microsoft's MCSE or new Architect Series certification, Cisco's CCIE, etc. - are the only credentials that truly hold value.
Myself, I don't fully subscribe to any of those mindsets. The best IT certification for you, after all, is likely to be different from that for another technology professional with different education, skills, and goals working at a different company in a different industry. For that reason, when pursuing any professional accreditation, you should give much thought and care to your education, experience, skills, goals, and desired career path.
Once a career road map is in place, selecting a potential certification path becomes much easier. And that's where this list of the industry's 10 best IT certifications comes into play. While this list may not include the 10 best accreditations for you, it does catalog 10 IT certifications that possess significant value for a wide range of technology professionals.

#1: MCITP

The new-generation Microsoft Certified IT Professional credential, or MCITP for short, is likely to become the next big Microsoft certification. Available for a variety of fields of expertise - including database developer, database administrator, enterprise messaging administrator, and server administrator - an MCITP validates a professional's proven job-role capabilities. Candidates must pass several Microsoft exams that track directly to their job role before earning the new designation.

As with Microsoft's other new-generation accreditations, the MCITP certification will retire when Microsoft suspends mainstream support for the platforms targeted within the MCITP exams. By matching the new certification to popular job roles, as has been done to some extent with CompTIA's Server+ (server administrator), Project+ (project manager), and A+ (desktop support) certifications, Microsoft has created a new certification that's certain to prove timely, relevant, and valuable.

#2: MCTS

The new-generation Microsoft Certified Technology Specialist (MCTS) helps IT staff validate skills in installing, maintaining, and troubleshooting a specific Microsoft technology. The MCTS certifications are designed to communicate the skills and expertise a holder possesses on a specific platform.

For example, candidates won't earn an MCTS on SQL Server 2008. Instead, they'll earn an MCTS covering SQL Server business intelligence (MCTS: SQL Server 2008 Business Intelligence), database creation (MCTS: SQL Server 2008, Database Development), or SQL server administration (MCTS: SQL Server 2008, Implementation and Maintenance).
These new certifications require passing multiple, tightly targeted exams that focus on specific responsibilities on specific platforms. MCTS designations will expire when Microsoft suspends mainstream support for the corresponding platform. These changes, as with other new-generation Microsoft certifications, add value to the accreditation.

#3: Security+

Security continues to be a critical topic. That's not going to change. In fact, its importance is only going to grow. One of the quickest ways to lose shareholder value, client confidence, and sales is to suffer a data breach. And no self-respecting technology professional wants to be responsible for such a breach.

CompTIA's Security+ accreditation provides a respected, vendor-neutral foundation for industry staff (with at least two years of experience) seeking to demonstrate proficiency with security fundamentals. While the Security+ accreditation consists of just a single exam, it could be argued that any IT employee charged with managing client data or other sensitive information should, at a minimum, possess this accreditation. The importance of ensuring staff are properly educated as to systems security, network infrastructure, access control, auditing, and organizational security principles is simply too important to take for granted.

#4: MCPD

There's more to information technology than just administration, support, and networking. Someone must create and maintain the applications and programs that power organizations. That's where the new-generation Microsoft Certified Professional Developer (MCPD) credential comes into play.

The MCPD accreditation measures a developer's ability to build and maintain software solutions using Visual Studio 2008 and Microsoft .NET Framework 3.5. Split into three certification paths (Windows Developer 3.5, ASP.NET Developer 3.5, and Enterprise Applications Developer 3.5), the credential targets IT professionals tasked with designing, optimizing, and operating those Microsoft technologies to fulfill business needs.
A redesigned certification aimed at better-measuring real-world skills and expertise, the MCPD will prove important for developers and programmers. Besides requiring candidates to pass several exams, the MCPD certification will retire when Microsoft suspends mainstream support for the corresponding platform. The change is designed to ensure the MCPD certification remains relevant, which is certain to further increase its value.

#5: CCNA

The Cisco Certified Internetwork Expert (CCIE) accreditation captures most of the networking company's certification glory. But the Cisco Certified Network Associate (CCNA) might prove more realistic within many organizations.

In a world in which Microsoft and Linux administrators are also often expected to be networking experts, many companies don't have the budgets necessary to train (or employ) a CCIE. But even small and midsize corporations can benefit from having their technology professionals earn basic proficiency administering Cisco equipment, as demonstrated by earning a CCNA accreditation.
As smaller companies become increasingly dependent upon remote access technologies, basic Cisco systems skills are bound to become more important. Although many smaller organizations will never have the complexity or workload necessary to keep a CCIE busy, Cisco's CCNA is a strong accreditation for technology professionals with a few years' experience seeking to grow and improve their networking skills.

#6: A+

Technology professionals with solid hardware and support skills are becoming tougher to find. There's not much glory in digging elbow-deep into a desktop box or troubleshooting Windows boot errors. But those skills are essential to keeping companies running.

Adding CompTIA's A+ certification to a resume tells hiring managers and department heads that you have proven support expertise. Whether an organization requires desktop installation, problem diagnosis, preventive maintenance, or computer or network error troubleshooting, many organizations have found A+-certified technicians to be more productive than their noncertified counterparts.
Changes to the A+ certification, which requires passing multiple exams, are aimed at keeping the popular credential relevant. Basic prerequisite requirements are now followed by testing that covers specific fields of expertise (such as IT, remote support, or depot technician). The accreditation is aimed at those working in desktop support, on help desks, and in the field, and while many of these staffers are new to the industry, the importance of an A+ certification should not be overlooked.

#7: PMP

Some accreditations gain value by targeting specific skills and expertise. The Project Management Professional (PMP) certification is a great example.

The Project Management Institute (PMI), a nonprofit organization that serves as a leading membership association for project management practitioners, maintains the PMP exam. The certification measures a candidate's project management expertise by validating skills and knowledge required to plan, execute, budget, and lead a technology project. Eligible candidates must have five years of project management experience or three years of project management experience and 35 hours of related education.
As organizations battle tough economic conditions, having proven project scheduling, budgeting, and management skills will only grow in importance. The PMI's PMP credential is a perfect conduit for demonstrating that expertise on a resume.

#8: MCSE/MCSA

Even years after their introduction, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA) credentials remain valuable. But it's important to avoid interpreting these accreditations as meaning the holders are all-knowing gurus, as that's usually untrue.

In my mind, the MCSE and MCSA hold value because they demonstrate the holder's capacity to complete a long and comprehensive education, training, and certification program requiring intensive study. Further, these certifications validate a wide range of relevant expertise (from client and server administration to security issues) on specific, widely used platforms.
Also important is the fact that these certifications tend to indicate holders have been working within the technology field for a long time. There's no substitute for actual hands-on experience. Many MCSEs and MCSAs hold their certifications on Windows 2000 or Windows Server 2003 platforms, meaning they've been working within the industry for many years. While these certifications will be replaced by Microsoft's new-generation credentials, they remain an important measure of foundational skills on Windows platforms.

#9: CISSP

As mentioned with the Security+ accreditation earlier, security is only going to grow in importance. Whatever an organization's mission, product, or service, security is paramount.

(ISC)², which administers the Certified Information Systems Security Professional (CISSP) accreditation, has done well building a respected, vendor-neutral security certification. Designed for industry pros with at least five years of full-time experience, and accredited by the American National Standards Institute (ANSI), the CISSP is internationally recognized for validating a candidate's expertise with operations and network and physical security, as well as their ability to manage risk and understand legal compliance responsibilities and other security-related elements.

#10: Linux+

While pursuing my first Microsoft certification 10 years ago, I remember debating the importance of Linux with several telecommunications technicians. They mocked the investment I was making in learning Microsoft technologies. These techs were confident Linux was going to displace Windows.

Well, didn't happen. Linux continues to make inroads, though. The open source alternative is an important platform. Those professionals who have Linux expertise and want to formalize that skill set will do well adding CompTIA's Linux+ certification to their resumes.
The vendor-neutral exam, which validates basic Linux client and server skills, is designed for professionals with at least six to 12 months of hands-on Linux experience. In addition to being vendor-neutral, the exam is also distribution neutral (meaning the skills it covers work well whether a candidate is administering Red Hat, SUSE, or Ubuntu systems).

Let the debate begin

Technology professionals almost always have strong reactions when debating certification's value. Listing the top 10 certifications leaves room, of course, for only 10 credentials. That means many favorite and popular designations, such as HIPAA and Sarbanes-Oxley (SOX) certifications, have been necessarily omitted. Other important accreditations, including those for VoIP providers and from PC manufacturers, Red Hat, and even Apple, have also been left out here.

Which certifications would you leave off this list and which would you add in their place? Join the discussion (link below) and share the logic behind your choices.

About the Author

Erik Eckel is president of two privately held technology consulting companies. He previously served as executive editor at TechRepublic. Read his full bio and profile.

This article reprinted courtesy of TechRepublic.

PMP: Examination Result: PASS

Congratulations on passing the PMP examination

Community Post

Community Post

Substantial Completion

The date at which the work or building project, or a designated portion of the work or building project thereof is sufficiently complete, in accordance with the construction contract documents, so that the owner may use or occupy the work or building project or designated portion thereof for the intened use for which it is originally designed and intended for.

This would include the completion of all life saftey systems, weathertight envelope, and adequate protection of building occupants and or equipment is ensured from hazzards posed by additional or possible construction activities or other potential harmful conditions that may exist or become evident during the final work effort to complete the project per the construction contract documents.

This date is then certified by the architect to the owner or client. From this date a number of other provisions are started such as warranty, guaranties, and liabilities

Read more: http://wiki.answers.com/Q/What_is_the_definition_of_substantial_completion#ixzz1PLGLlpYm

Product Scope

The product scope description can be used as an input to the Scope Definition process when the project charter and/or preliminary project scope statement are missing.

Utility Theory: Encyclopedia of Management

Quoted from http://www.enotes.com/management-encyclopedia/utility-theory:

Utility Theory: Encyclopedia of Management

Utility Theory

• Utility theory provides a methodological framework for the evaluation of alternative choices made by individuals, firms and organizations. Utility refers to the satisfaction that each choice provides to the decision maker. Thus, utility theory assumes that any decision is made on the basis of the utility maximization principle, according to which the best choice is the one that provides the highest utility (satisfaction) to the decision maker.

UTILITY THEORY IN CONSUMER BEHAVIOR

Utility theory is often used to explain the behavior of individual consumers. In this case the consumer plays the role of the decision maker that must decide how much of each of the many different goods and services to consume so as to secure the highest possible level of total utility subject to his/her available income and the prices of the goods/services.

Community Post

Community Post

Processes Changes in PMBOK guide 4th Edition

Here is a list of changed processes in the PMBOK guide from the third to the fourth editions:

4.2 - Develop Preliminary Scope Statement --> Deleted
4.7 - Close Project --> Changed to 4.6 Close Project or Phase
5.1 - Plan Scope -->Deleted
5.1 - Collect Requirements --> Added
9.4 - Manage Project Team --> Changed from a controlling to an executing process
10.1 - Identify Stakeholders --> Added
10.4 - Manage Stakeholders --> Changed to manage stakeholders expectations; changed from a controlling process to an executing process
12.1 - Plan Purchases and Acquisitions and 12.2 Plan Contracting --> Changed to 12.1 Plan Procurements
12.3 - Request Sellers Responses and 12.4 Select Sellers --> Changed to 12.2 Conduct Procurements

PMP sample questions

A project manager is working in a country where it is customary to pay the police for private protection services. The PM's senior manager tells him that in another country, that would be considered a bribe and should not be done.

What is the BEST way for the project manager to proceed?

A. Ask his senior manager for guidance.

B. Do not pay the police for private protection services, because that would definitely be a bribe.

C. Pay the police for private protection services, because it is customary in the country they are operating in.

D. Consult the Cost Management Plan about payments.

Answer: C

Explanation:Some questions might ask you about how to operate in another country. In this case, the question is about whether or not something is a bribe. Clearly, if it's a bribe, you can't pay it. However, if a payment to a government official (or anyone else) is customary, then it's not a bribe. You should go ahead and pay the police - as long as it's acceptable and legal in that country.


You are managing a construction project to install wiring in an office building. You discover that one of your team members has taken a box of cable from the job site so he can wire his attic at home.

What is the BEST way to respond?

A. Report the team member to PMI

B. Call the police

C. Report the team member to your manager

D. Do nothing

Answer: B
Explanation:If you discover that someone has broken the law, it is your duty to call the authorities and report that person. You need to do this, even if it seems like the offense is minor.



Which conflict resolution technique is most effective?
A. Withdrawal
B. Compromise
C. Smoothing
D. Confronting


Answer: D
Explanation:
Confronting means figuring out the cause of the problem and fixing it. That's the best way to be sure that the right decision is made.

Quoted from http://support.microsoft.com/kb/918685:

Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded"

Article ID: 918685 - Last Review: February 12, 2009 - Revision: 4.0

 

Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded"

 

SYMPTOMS When you install Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you rec...

When you install Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you receive the following error message: The file C:\Windows\Microsoft.NET\Framework\version_number\mscorlib.tlb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program.Note version_number is a placeholder for the version number of the Microsoft .NET Framework, such as v1.0.3705, v1.1.4870, or v2.0.50727.

After you install SQL Server 2005 or SQL Server 2008, you may receive an error message that resembles this error message every time that you start Microsoft SQL Server Management Studio.

 

CAUSE This issue occurs because the path of the Mscorlib.tlb file is incorrectly inter...

This issue occurs because the path of the Mscorlib.tlb file is incorrectly interpreted during the Setup process.

 

WORKAROUND Important This section, method, or task contains steps that tell you how to modi...

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756 (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

 

For SQL Server 2005

To work around this problem, you must manually specify the correct path of the Mscorlib.tlb file in the registry. To do this, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlbNotes
   • If you install SQL Server 2005 on 64-bit operating systems, locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlb
   • If you install SQL Server 2005 Express Edition with Advanced Services, locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb
3. In the right pane, double-click the registry entry TlbPath. The Edit String dialog box appears.
4. In the Value data box, replace %CLRVERSION% with the following value: v2.0.50727Note The value v2.0.50727 indicates the version of the .NET Framework that the original release version of SQL Server 2005 uses.
5. Click OK, and then exit Registry Editor.

Important If you install a SQL Server 2005 service pack or hotfix, the service pack or hotfix will change the value that you replace in step 4 back to %CLRVERSION%. If the problem that is described in this article still exists after you install the service pack or the hotfix, you must following these steps again to work around this problem.

 

For SQL Server 2008

To work around this problem, you must manually specify the correct path of the Mscorlib.tlb file in the registry. To do this, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\TlbAutoRepair\mscorlib.tlb NotesIf you install the 32-bit version of SQL Server 2008 on 64-bit operating systems, locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\100\Tools\Shell\TlbAutoRepair\mscorlib.tlbIf you install SQL Server 2008 Express Edition with Advanced Services, locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb
3. In the right pane, double-click TlbPath.
4. In the Value data box, replace %CLRVERSION% with the following value: v2.0.50727 Note The value v2.0.50727 indicates the version of the .NET Framework that the original release version of SQL Server 2008 uses.
5. Click OK, and then exit Registry Editor.

Important If you install a SQL Server 2008 service pack or hotfix, the service pack or hotfix will change the value that you replace in step 4 back to %CLRVERSION%. If the problem that is described in this article still exists after you install the service pack or the hotfix, you must following these steps again to work around this problem.