Dear Scott,

I just want to say hi and check if there is anything further I can do for
you. If there is, please don't hesitate 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.

--------------------
| X-Tomcat-ID: 169204005
| References: microsoft.com>

microsoft.com>

<1C890A48-4EB7-4823-BB0F-8A665F30D51C@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Fri, 17 Aug 2007 09:16:58 GMT
| Subject: Re: Installed VS 2005 want to Manage SQL 2005 Server
| X-Tomcat-NG: microsoft.public.sqlserver.setup
| Message-ID:
| Newsgroups: microsoft.public.sqlserver.setup
| Lines: 423
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2745
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| 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<-
| | > | > |
| | > | > |
| | > | >
| | > |
| | > |
| | >
| |
| |
|
|