Where is SQL Analyzer in SQL Server 2005?!?!

[AtW]

That's okay, thanks, I've got MSDN subscription - love downloading at 1.8 Mbytes per sec from it

[Spacecadet]

Yes it's definately a version conflict - need to install all tools/SQL2005 first BEFORE applying SP1 to it. Just one of those things they don't tell you...

New SQL management thingy better be good or I stick to good old SQL Analyser

I Like it

I also like SQL Prompt... PM me if you want the now unavailable free version

[AtW]

Yes it's definately a version conflict - need to install all tools/SQL2005 first BEFORE applying SP1 to it. Just one of those things they don't tell you...

New SQL management thingy better be good or I stick to good old SQL Analyser

[Spacecadet]

But I was not upgrading - I had first installed SQL 2005, then SP1, and then tools from SQL 2005 - there do not seem to be tools for SP1, so I had to roll back and start again ffs!

excellent, i'll watch out for that in future

[AtW]

But I was not upgrading - I had first installed SQL 2005, then SP1, and then tools from SQL 2005 - there do not seem to be tools for SP1, so I had to roll back and start again ffs!

[Spacecadet]

very sneak, you might have mentioned that you were trying to upgrade though

[AtW]

AH I get it, sneaky ******s did not make clear what's the problem:


------------------
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.
------------------

Looks like it is not happy about me having applied SP 1 to it, darn.

[Spacecadet]

are you trying to install the client tools on the server or a PC?

[AtW]

I am on Win XP Pro, using official SQL Server 2005 Standard (patched to SP1) from MSDN. Installed main server it definately runs fine - I connected to it via old SQL Analyser (I hoped for update of it).

Tried to install Tools from another dir on that ISO - allows to select all tools including that SQL management thing, but them tells me nothing to do - error as above.

Found this link: http://support.microsoft.com/default.aspx/kb/913967

It suggests very strange way of installing these tools, followed instructions but I get same error, ffs, it is just tools to install

[Spacecadet]

Can't install Tools actually - get error:

"None of the selected features can be installed or upgraded blah blah, click cancel" - I have selected ALL tools to be installed including Management Studio which probably replaced SQL Analyser (*****rs!)

what system are you using? has the preinstallation run?

[AtW]

Can't install Tools actually - get error:

"None of the selected features can be installed or upgraded blah blah, click cancel" - I have selected ALL tools to be installed including Management Studio which probably replaced SQL Analyser (*****rs!)

[Spacecadet]

Installed both SQL Server 2005 and tools for it, but can't find anywhere ISQLW.exe which is SQL Analyser?!?!?!

There is no SQL Analyser

Open SQL Server management Studio, set up your database instance connections then select New Query at the top left

[AtW]

Installed both SQL Server 2005 and tools for it, but can't find anywhere ISQLW.exe which is SQL Analyser?!?!?!