Re: Installed VS 2005 want to Manage SQL 2005 Server

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]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message news:bGlgf283HHA.2340@xxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx

%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" <scooter133@xxxxxxxxxxxxxxxx>
| From: "Scott Townsend" <scooter133@xxxxxxxxxxxxxxxx>
| References: <ED9DC3A7-9920-4C4E-9C20-2C8D5087D0DD@xxxxxxxxxxxxx>
<W7AwQin3HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| In-Reply-To: <W7AwQin3HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Installed VS 2005 want to Manage SQL 2005 Server
| Date: Wed, 15 Aug 2007 07:26:34 -0700
| Lines: 162
| Message-ID: <CA8CCAA8-6FEB-4FDC-B78D-9DF82E2C5D23@xxxxxxxxxxxxx>
| 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]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| news:W7AwQin3HHA.5204@xxxxxxxxxxxxxxxxxxxxxxxxx
| > 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:
| >
| > <SQL Server setup source or CD/DVD>\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@xxxxxxxxxxxxx
| >
| > 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" <scooter133@xxxxxxxxxxxxxxxx>
| > | From: "Scott Townsend" <scooter133@xxxxxxxxxxxxxxxx>
| > | Subject: Installed VS 2005 want to Manage SQL 2005 Server
| > | Date: Mon, 13 Aug 2007 15:41:38 -0700
| > | Lines: 13
| > | Message-ID: <ED9DC3A7-9920-4C4E-9C20-2C8D5087D0DD@xxxxxxxxxxxxx>
| > | 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<-
| > |
| > |
| >
|
|


.