|Subject:||SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?|
|Posted by:||Jack (email@example.com)|
|Date:||Wed, 9 Aug 2006|
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