| 
	
 | 
 Posted by Jack on 06/11/61 11:55 
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.
 
  
Navigation:
[Reply to this message] 
 |