Dear Scott,

Thank you for your update.

I am glad to hear that we are able to go through with the install of the
Tools via the "SKUUPGRADE=1" switch box. Your efforts are appreciated.

Regarding your question, I would like to explain that the version
"9.2.3042.00" just applies to the Microsoft SQL Server Management Studio
client tool and this version is the latest one. The Service Pack 2 for SQL
Server is used to fix some known issues and add some feature of the SQL
engine and it will not do any changes on the management client tool. So, if
you find the version of Management Studio keeps being 9.2.3042.00 even
after re-applying SQL Server SP2, this is a normal behavior.

For your reference, we can run the command "select SERVERPROPERTY
('productlevel')" to manually check the version of SQL DB engine to confirm
if the SQL Server 2005 SP2 has been installed successfully,

In addition, I also notice that the SP version is 050727-7600. It indicates
that the current version of Visual Studio is Service Pack 1.

From all the information you uploaded, it seems that all the components are
up to date and everything works fine now.

If you have any question or need my further assistance, please feel free to
let me know. I am glad to help.

Have a nice day!

Best regards,

Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "Scott Townsend"
| From: "Scott Townsend"
| References: microsoft.com>

microsoft.com>

| In-Reply-To:
| Subject: Re: Installed VS 2005 want to Manage SQL 2005 Server
| Date: Thu, 16 Aug 2007 09:19:54 -0700
| Lines: 361
| Message-ID: <1C890A48-4EB7-4823-BB0F-8A665F30D51C@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| format=flowed;
| charset="iso-8859-1";
| reply-type=original
| Content-Transfer-Encoding: 7bit
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
| X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
| X-MS-CommunityGroup-PostID: {1C890A48-4EB7-4823-BB0F-8A665F30D51C}
| X-MS-CommunityGroup-ThreadID: E4172F48-0065-4790-9951-02A03EE1EEE8
| X-MS-CommunityGroup-ParentID: 096F3689-3860-4BF6-B54B-80B322A02B9C
| Newsgroups: microsoft.public.sqlserver.setup
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2737
| NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| So I did the SKUUPGRADE=1 as a parameter to Setup.exe inthe tools folder.
|
| It went through with the install of the Tools.
|
| Though the thing that concerns me is that the version went from
9.2.3042.00
| to 9.0.3042.00.
| I did reapply SP1 for Visual Studio and SP2 for SQL (in that order) and
it
| still shows 9.0.3042.00 for the SQL Management Studio.
|
| My Concern is that I might be missing something?
|
| Thanks,
| ------------------------------------------------------
| ----Here is the Info for SQL Management Studio----
| ------------------------------------------------------
| Microsoft SQL Server Management Studio 9.00.3042.00
| Microsoft Analysis Services Client Tools 2005.090.3042.00
| Microsoft Data Access Components (MDAC) 2000.086.3959.00
| (srv03_sp2_rtm.070216-1710)
| Microsoft MSXML 2.6 3.0 5.0 6.0
| Microsoft Internet Explorer 7.0.5730.11
| Microsoft .NET Framework 2.0.50727.832
| Operating System 5.2.3790
|
| -----------------------------------------
| ----Here is the Info for Visual Studio----
| -----------------------------------------
| Microsoft Visual Studio 2005
| Version 8.0.50727.762 (SP.050727-7600)
| Microsoft .NET Framework
| Version 2.0.50727
|
| Installed Edition: Professional
|
| Microsoft Visual Basic 2005 77626-009-0000007-41548
| Microsoft Visual Basic 2005
|
| Microsoft Visual C# 2005 77626-009-0000007-41548
| Microsoft Visual C# 2005
|
| Microsoft Visual C++ 2005 77626-009-0000007-41548
| Microsoft Visual C++ 2005
|
| Microsoft Visual J# 2005 77626-009-0000007-41548
| Microsoft Visual J# 2005
|
| Microsoft Visual Web Developer 2005 77626-009-0000007-41548
| Microsoft Visual Web Developer 2005
|
| Microsoft Web Application Projects 2005 77626-009-0000007-41548
| Microsoft Web Application Projects 2005
| Version 8.0.50727.762
|
| Crystal Reports AAC60-G0CSA4B-V7000AY
| Crystal Reports for Visual Studio 2005
|
|
| Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1
| (KB926601)
| This service pack is for Microsoft Visual Studio 2005 Professional
Edition -
| ENU.
| If you later install a more recent service pack, this service pack will
be
| uninstalled automatically.
| For more information, visit http://support.microsoft.com/kb/926601
|
| SQL Server Analysis Services
| Microsoft SQL Server Analysis Services Designer
| Version 9.00.3042.00
|
| SQL Server Integration Services
| Microsoft SQL Server Integration Services Designer
| Version 9.00.3042.00
|
| SQL Server Reporting Services
| Microsoft SQL Server Reporting Services Designers
| Version 9.00.3042.00
|
|
|
|
| "Adams Qu [MSFT]" online.microsoft.com> wrote in message
| news:bGlgf283HHA.2340@TK2MSFTNGHUB02.phx.gbl...
| > Dear Scott,
| >
| > Thank you for posting back.
| >
| > According to the information in your last post, it appears that the
issue
| > is that the Microsoft SQL Server 2005 Tools Express Edition has already
| > been installed on the machine and causes the version conflict issue.
| >
| > We can try to manually remove the Client Tools for Microsoft SQL Server
| > 2005 Express Edition and then install the SQL Server Management tools
| > again. To do so, please refer to the following steps:
| >
| > 1. Click Start, and then click Control Panel.
| > 2. Double-click Add or Remove Programs.
| > 3. In the list of installed programs, click Microsoft SQL Server 2005,
and
| > then click Change.
| > 4. On the Component Selection page, select Workstation components, and
| > then
| > click Next.
| > 5. Click Next.
| > 6. On the Change or Remove Instance page, click Change Installed
| > Components.
| > 7. Click Client Components, and then select Entire Feature will be
| > Unavailable.
| > 8. Click Next.
| > 9. Click Install.
| >
| > After that, please rerun the setup wizard and then check if the SQL
Server
| > Client tools are able to install on the system.
| >
| > Related KB article
| > ------------------------
| > How to uninstall SQL Server Management Studio
| > http://support.microsoft.com/kb/909953/en-us
| >
| > However, if the Client tools still fail to install, please send the
| > following log files to me at v-adamqu@microsoft.com
| >
| > %%ProgramFiles%%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
| > %%ProgramFiles%%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files (all
the
| > log files in it)
| >
| > Have a nice day!
| >
| > Best regards,
| >
| > Adams Qu
| > MCSE, MCDBA, MCTS
| > Microsoft Online Support
| >
| > Microsoft Global Technical Support Center
| >
| > Get Secure! - www.microsoft.com/security
| > =====================================================
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| > =====================================================
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --------------------
| > | Reply-To: "Scott Townsend"
| > | From: "Scott Townsend"
| > | References: microsoft.com>
| >
| > | In-Reply-To:
| > | Subject: Re: Installed VS 2005 want to Manage SQL 2005 Server
| > | Date: Wed, 15 Aug 2007 07:26:34 -0700
| > | Lines: 162
| > | Message-ID: microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | format=flowed;
| > | charset="iso-8859-1";
| > | reply-type=original
| > | Content-Transfer-Encoding: 7bit
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
| > | X-MS-CommunityGroup-PostID: {CA8CCAA8-6FEB-4FDC-B78D-9DF82E2C5D23}
| > | X-MS-CommunityGroup-ThreadID: E4172F48-0065-4790-9951-02A03EE1EEE8
| > | X-MS-CommunityGroup-ParentID: 9301AFD4-A7FE-45E6-88FC-9BE17441191B
| > | Newsgroups: microsoft.public.sqlserver.setup
| > | Path: TK2MSFTNGHUB02.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2707
| > | NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
| > | X-Tomcat-NG: microsoft.public.sqlserver.setup
| > |
| > | Okay so I found the Tools Folder on a Physical Disk. I Guess I didn't
| > copy
| > | it to the Install Source on the Server.
| > |
| > | I run the Setup and it says there is an Edition Conflict and to run
| > setup
| > | from a command prompt and use the switch:
| > | - Edition Change Check (Warning)
| > | Messages
| > | Edition Change Check
| > |
| > | To change an existing instance of Microsoft SQL Server 2005 to a
| > different
| > | edition of SQL Server 2005, you must run SQL Server 2005 Setup from
the
| > | command prompt and include the SKUUPGRADE=1 parameter.
| > |
| > |
| > |
| > | There is a 'Next' Button so I continued. I then got the Following:
| > | The Following Components that you chose to install are already
installed
| > | onthe machine. To vire a report of available options and alternatives
| > click
| > | Details.
| > |
| > | Then there is a greyed out like that reads:
| > | workstation components, books online and development tools
| > 9.2.3042.00
| > |
| > | Clicking Details gives me:
| > |
| > | Name: Microsoft SQL Server 2005 Tools Express Edition
| > | Reason: 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.
| > |
| > | Build version check:
| > | Your upgrade is blocked because the existing component is a later
| > version
| > | than the version you are trying to upgrade to. To modify an existing
SQL
| > | Server component, go to Add or Remove Programs in Control Panel,
select
| > the
| > | component you would like to modify, and then click Change/Remove.
| > |
| > | So I'll attempt the SKUUPGRADE=1 option
| > |
| > | "Adams Qu [MSFT]" online.microsoft.com> wrote in message
| > | news:W7AwQin3HHA.5204@TK2MSFTNGHUB02.phx.gbl...
| > | > Dear Scott,
| > | >
| > | > Thank you for posting here.
| > | >
| > | > From the problem description of the post you submitted, my
| > understanding
| > | > is: You would like to install the SQL Server Management tools on the
| > | > Visual
| > | > Studio 2005 Development machine but received an "Edition Version
| > Conflict"
| > | > message. If I have misunderstood about your concern, feel free to
let
| > me
| > | > know.
| > | >
| > | > Based on my experience and test, I am able to install the SQL Server
| > | > Management tools on the machine with VS 2005 SP1 installed. My test
| > | > process
| > | > was as following:
| > | >
| > | > 1. Install the Visual Studio 2005 on my test server
| > | > 2. Install the Service Pack 1 for Visual Studio 2005
| > | > 3. Run the following setup file to install Client tools for SQL
Server
| > | > 2005
| > | > only:
| > | >
| > | > \Tools\setup.exe
| > | >
| > | > 4. Select all the client tools (include Management tools) for SQL
| > Server
| > | > 2005 in the installation wizard
| > | > 5. The installation can be completed successfully.
| > | >
| > | > Please check my steps and compare with yours to see if there are
some
| > | > hints. If the error message still occurs, please help me to capture
a
| > | > screenshot.
| > | >
| > | > How to capture a Screenshot:
| > | > ----------------------
| > | > 1. When the error appears, please press the Print Screen key
(PrtScn)
| > on
| > | > your keyboard.
| > | > 2. Click Start, click Run, type MSPAINT, and click OK.
| > | > 3. In Paint, click Paste under the Edit Menu, click Save under the
| > File
| > | > menu, type a file name for the snap shot, choose JPEG as "Save as
| > type",
| > | > click "Desktop" on the left pane, and click Save.
| > | > 4. Please find the screenshot on the Desktop and send it as an
| > attachment
| > | > to: v-adamqu@microsoft.com
| > | >
| > | > At the same time, let's also test if we are able to install the
| > Microsoft
| > | > SQL Server Management Studio (Express) tool individually on the
| > | > development
| > | > machine. It can be downloaded from the following download link:
| > | >
| > | > Microsoft SQL Server Management Studio Express Service Pack 2
| > | >
| >
http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-
| > | > b25b-9aca13141c9e&DisplayLang=en
| > | >
| > | > If you have any other questions or concerns, please feel free to
let
| > me
| > | > know.
| > | >
| > | > Have a nice day!
| > | >
| > | > Best regards,
| > | >
| > | > Adams Qu
| > | > MCSE, MCDBA, MCTS
| > | > Microsoft Online Support
| > | >
| > | > Microsoft Global Technical Support Center
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | > =====================================================
| > | > When responding to posts, please "Reply to Group" via your
newsreader
| > so
| > | > that others may learn and benefit from your issue.
| > | > =====================================================
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > | > rights.
| > | >
| > | > --------------------
| > | > | Reply-To: "Scott Townsend"
| > | > | From: "Scott Townsend"
| > | > | Subject: Installed VS 2005 want to Manage SQL 2005 Server
| > | > | Date: Mon, 13 Aug 2007 15:41:38 -0700
| > | > | Lines: 13
| > | > | Message-ID: microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | format=flowed;
| > | > | charset="iso-8859-1";
| > | > | reply-type=original
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
| > | > | X-MS-CommunityGroup-MessageCategory:
| > | > {E4FCE0A9-75B4-4168-BFF9-16C22D8747EC}
| > | > | X-MS-CommunityGroup-PostID: {ED9DC3A7-9920-4C4E-9C20-2C8D5087D0DD}
| > | > | Newsgroups:
| > | > microsoft.public.vsnet.setup,microsoft.public.sqlserver.setup
| > | > | NNTP-Posting-Host: 204-145-245-215.enm.com 204.145.245.215
| > | > | Path:
| > TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| > | > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2689
| > | > microsoft.public.vsnet.setup:547
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.setup
| > | > |
| > | > | So I have a Development machine that I have installed Visual
Studio
| > 2005
| > | > on
| > | > | and SP1, The Dev Environment works great and I have been Terminal
| > | > Serving
| > | > to
| > | > | my SQL 2005 Server to do Administration. It would be real handy
to
| > | > install
| > | > | the SQL 2005 Management tools on the VS2005 Development machine.
| > | > |
| > | > | When I go to do the Managment tools install, it complains that I
| > have
| > an
| > | > | Edition Version Conflict.
| > | > |
| > | > | What are my options?
| > | > |
| > | > | Thanks,
| > | > | Scott<-
| > | > |
| > | > |
| > | >
| > |
| > |
| >
|
|