asked on

Something went wrong with my installation

Hi,
I installed a copy of MS SQL 2005 Developer on my XP machine. I might have specified the wrong domain name or the login password for the id during installation for a named instance. The installation was completed. However, when I click Start-Program, under the SQL 2005 there is a Configuration Tool and then 4 tools under that sub memu item. I found a Microsoft Sql Sever and there is a Enterprise Manager and Query Analyzer but in the About dialog, it shows version 8, that doesn't sound right. Is SQL 2005 version 8?
I opened the SQL enterprise Manager, clicked on the SQL server and I got an error message "A connection could not be established to localDomainName\namedInstanceName. Reason:[SQL-DMO] You must use SQL 2005 Management tool to access this server. Please verify SQL server is running and check your SQL server regisration properties and try again"
I don't see any SQL 2005 management tools anywhere under the Start->programs or on my desktop. And where is that Enterprise Manager 8.0 coming from? How can I un-install it?
Thank you.

SOLUTION

QPR

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Guy Hengel [angelIII / a3]

those tools you mention are sql 2000, and not 2005.
so, either you got the wrong edition, or had already the client tools of 2000 installed.

lapucca

ASKER

My PC now would not reboot. Something went very wrong wtih my SQL installation. Is this caused becuase I intall SQL 2005 when there is already SQL 2000 installed? I didn't see any warning about this and the installatio seem to complete just fine until I tried access the sql server in the Enterprise Manger. I can boot up in safe mode. Should I go into control panel and un-install everything of SQL?

Thanks.

ASKER CERTIFIED SOLUTION