SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?

Giganews Newsgroups
Subject: SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
Posted by:  Jack (jack@nospam.com.uk)
Date: Wed, 9 Aug 2006

Hello,

I had SQL2000 server running fine on the windows 2003 box. I then installed
SQL 2005 Express. They both worked together fine. I then uninstalled SQL
2005 Express and installed SQL 2005 Server. But when I open SQL Server
Management Studio, I can only connect to the SQL 2000 engine. In the Object
explorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I can
see the existing SQL 2000 databases).

How can I get SQL Server Management Studio to 'see' the SQL 2005 database
engine so I can create tables? I *think* its running because there is the
'sqlservr.exe' process running, and during installation there is no issues.

When I open SQL Server Management Studio, I choose 'Database Engine', then
my local Servername with Windows Authentication. How do I connect to the SQL
2005 instance?

Thanks,
Jack.

Replies