|
|
Posted by Erland Sommarskog on 08/09/06 16:31
Jack (jack@nospam.com.uk) writes:
> 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.
Did you actually try to connect to it? Your Express instance was presumably
called SQLEXPRESS, but you did not use this instance name when you installed
Enterprise/Standard edition.
You can use SQL Configuration Manager to view which instances you have
installed, and whether they are running.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|