Posted by Jack on 08/09/06 14:46

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.

• Next in forum: Skip rows where the first column with letter 'S' - BCP
• Prev in forum: Tying together tables
• Thread view: SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?

[Reply to this message]