August 23, 2007 at 8:29 am
I have sql server 2000 running on laptop (win xp, centrino duo, 2GB RAM)
Wanted to use sql server 2005 - so someone installed the express version on my laptop. Wierd problems so I uninstalled sql server 2005 express and installed sql server 2005 standard edition.
When I run SQL Server Management Studio - it shows the 2000 database instance - but nothing for a 2005 database instance
How do I create a new 2005 instance?
Thanks
August 23, 2007 at 8:52 am
You can use SQL Server 2005 setup to create a new instance. Before that I'd make sure that the SQL Server Browser service is running. This is needed to connect to named instances if their listening port is not fixed (the default).
Regards,
Andras
August 23, 2007 at 11:59 am
Thanks - but I can not get to the SQL Server 2005 "new instance" wizard page. The wizard help says that I should see the "new instance" page - but I don't.
The pages of the Setup Wizard are:
Registration Information (name and company name)
Feature Selection (I have selected everything on disk)
Sometimes the next screen is:
****************************************
No features were selected for installation. Setup cannot proceed since no effective change is being made to the machine. To continue, select features to install.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28069
****************************************
If I click on SQL Server 2005 Surface Area Configuration - it keeps saying that I am running Windows Vista - when I am running XP
*************************************************
I found the information below about the installation. It is Standard Edition and not Enterprise. (enterprise will not install instance on win XP). I have service pack 2 installed
USSOG-L-0062466
The following components are installed on this server
Common components
Workstation Components
[Version: 9.2.3042.00 Edition: Standard Edition Patch level: 9.2.3042 Language: English (United States)]
August 23, 2007 at 12:15 pm
The short answer is "You can't".
Standard only installs client tools on a PC / Laptop. You need Developer version (or Express) to run a server instance on your laptop. Workgroup might work too, but I can't find anything on it at the moment.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply