After Install of 2005 still 2000 Engine!

After Install of 2005 still 2000 Engine!

• Ilya Lehrman

  What should I look exactly at I see SQl Server (SQl Express) service...
  
  

• José Valim

  After ignoring the previous message I got the following:

   

  TITLE: Copy Database Wizard
  ------------------------------

  The server is SQL Server Express. This application will not work with Express Edition.

  ------------------------------
  BUTTONS:

  OK
  ------------------------------
  

  
  
  

• Timon Christl

  Radiogeneris, please read the Books Online that came with your SQL SErver 2005 installation, it will give you a good overview as well as help you better understand your installation process/problems.

  You can also access it online at http://msdn2.microsoft.com/ms165606(en-US,SQL.90).aspx.

  After you've read the documentation, please feel free to post any follow up questions.

  
  

• XBTester

  That is probably your named instance, which you installed instead of upgraded. 

  http://msdn2.microsoft.com/en-us/library/ms165614.aspx

  You can search msdn for more information regarding your named instance.

  
  

• Kate Wells

  Seems it never upgraded SQL Express.. I wonder... So it seems I have two versions: SQL 2000 and SQl Express. What is the version difference betwen SQL Express and SQl Server 2005 How to tell
  
  

• ReneL

  Thanks. I have executed the SQL:
  
  Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
  
  Seems I have still the old version of SQL, however I can not run Enetrprise Manager anymore, it gives me some strange errors. However it seems I can manage this instance as well as SQl Server Express instance from the new SQL Management Studio. The problem is that some options do not work (grayed out). I think the reason is that this version was not upgraded.
  
  Can I upgrade this version without using Setup My DVD has some scratches...
  
  
  

• Jeffrey Litch

  Is  not that SQl Server Express 2005 I had it installed before...
  
  
  

• Lorren

  Hi I wonder now. Is it possible that SQL Express 2005 has been upgraded to full version, but the instance is still called SQLExpress, even it is full version SQL Server 2005

  Please let me know. Thanks

  
  
  

• Morgan Cheng

  i just reread your post.  where do you see "8.9.193"   if you do "select @@version", that will tell you the version of your sql server installation.
  

• Torns

  I have tried to copy database from SQL 2000 instance but it does not accept this destination name: h001335\SQLEXPRESS

  I have checked the speeling, it is correct instance.

  Any idea

  
  
  

• rikidude

  Was your SQL Server 2005 installation successful   And did you do an upgrade, or a separate instance installation   Check to see if you have a second instance of sql server running, this may be your SQL 2005 installation.
  

• Radoslav Č&#225&#59;p

  How to tell the difference between SQL Express 2005 and SQL Server 2005 How to check
  
  

• Ejan

  look at your services in control panel.
  

• eajam

  How to check if I have second instance How to see all my instances Thanks

   

  
  
  
• After Install of 2005 still 2000 Engine!