You are here: SQL 2005-Config Manager contains no data « MsSQL Server « IT news, forums, messages
SQL 2005-Config Manager contains no data

Posted by Jack on 10/02/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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация