SQL Server Upgrade Assistant Error

Question

SQL 2000 SP4 Upgrade to SQL 2008 R2

 

When using SQL Server Upgrade Assistance and I have the baseline server setup in a SQL 2000 environment I try to run the trace replay.  As soon as I click "Replace Trace" button I get the error "Failed to initialize object as reader".  I assume that this tool is having problems spawning some SQL Profiler sessions.  Did anyone have a work-a-round for this issue.  The SQL Profiler tool works fine when running from Enterprise Manager.

 

Thanks in Advance...Heier

Answer 1

Did you install the SQL Server 2008 client components on that machine?

 

---

No great genius has ever existed without some touch of madness. - Aristotle

Answer 2

I am also getting the same error when setup base line (step 2).  The error said by "Joe Yong" did not  have chance to get. becuase 2008 client component is a prerequisite to install "Upgrade Assistant". Please help us to fix "Object reference not set to instance of an object" Error.

Thanks, - Kumar

Answer 3

The user running Upgrade Assistant must have administrator privileges on the test environment computers and related SQL Server instances. Make sure that the BUILTIN\Administrators Windows login is part of the SQL Server sysadmin server role. 

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 4

Yes I am part of BUILTIN\Administrator group and BUILTIN\Administrator has mapped with sysadmin server role in both the instances.

Is there anyother thing to take care to resolve this issue.

Thanks, -Kumar

Answer 5

please check out the below link, it may help you.

http://social.technet.microsoft.com/wiki/user/settings.aspx?ReturnUrl=%252fwiki%252fcontents%252farticles%252f2558.upgrade-assistant-tool-for-sql-server-2012.aspx