Hi,

I can't seem to connect to SQL 2005. When I open Configuration Manager,
these is no information in any of the items in the tree.
I checked that WMI was configured correctly at:
http://msdn2.microsoft.com/en-us/library/ms188690.aspx
I can't see any instances at all here.

However, when I use Management Studio I CAN connect to an instance of SAL
2000 and see databases I have previously defined.

I'm running WIN 2003 with SQL 2005 standard and login as Administrator. SQL
books on line don't seem to have anything to say about this.

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.

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).

Any help is greatly appreciated...
Jack.

Jack (jack@nospam.com.uk) writes:
> 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,

How many sqlservr.exe do you see? If you only see one, that is obviously
the SQL 2000 instance.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx