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
Did you install the SQL Server 2008 client components on that machine?
No great genius has ever existed without some touch of madness. - Aristotle
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
- Edited by Kumar Venkatesan Wednesday, December 28, 2011 1:32 PM
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.
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