Installed both SQL Server 2005 and tools for it, but can't find anywhere ISQLW.exe which is SQL Analyser?!?!?!
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Where is SQL Analyzer in SQL Server 2005?!?!
Collapse
X
-
-
Originally posted by AtWInstalled both SQL Server 2005 and tools for it, but can't find anywhere ISQLW.exe which is SQL Analyser?!?!?!
Open SQL Server management Studio, set up your database instance connections then select New Query at the top leftCoffee's for closers -
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!)Comment
-
Originally posted by AtWCan'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!)Coffee's for closersComment
-
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 installComment
-
Comment
-
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.Comment
-
Comment
-
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!Comment
-
Originally posted by AtWBut 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!Coffee's for closersComment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment