Installed SQLServer 2005 TrialEdition

Hi Fellows,

I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here .

My site is : Windows XP Professional SP2

Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network.

I ran setup from : server directory and also from tools directory.

In my programes menu I can only see Configuration Toolsunder which there are three options :

1) SQL Server Configuration Tool

2) SQL Server Surface Configuration Tool and

3) SQL Server Error and Usage Reporting

Is it SQL Server 2005 Enterprise edition? XP SP2 does not support Enterprise edition. You need server operating systems to support Enterprise edition such as W2K SP4, W2K3 EE SP2, Longhorn Server.

|||

I dont know . I just downloaded the server from MSDN site it was an x86 executable file . My PC is a Win XP Professional on our internal Domain .

|||What does the Splash screen tell you ? After calling the installer you should get the splah screen showing the dition type you are trying to install.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi

I just uninstalled everything and run the installer again . It says SQL 2005 Server but does not give anytype of edition. However now I find that the Management Console is appearing in the program menu.

Thanks to all . But I am still mystified as to why it should do like this .

Regards

|||Strange thing, I just started my ISO and it directly gives me the edition type as of [1]

[1] http://www.sqlserver2005.de/SharedFiles/SplashScreen.jpg

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Two questions:

1/How did you uninstall everything? I uninstalled in the wrong order from add/remove programs now I am in three quarters installed limbo. [Ghosting the machine seems the simplest way out].

2/I did not get the tools setup to work, or the sample database install in the server directory, the error message was (in both cases)
"The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details."
Clicking on details was unhelpful (said to maintain components from add/remove programs)
[The components that were already installed did not mention the sample databases]

This is on Windows 2000 SP4, with sqlserver 2005 evaluation edition.

Thank you for your time,
Turloch|||

Hi

I simply went to the Add/remove programs and selected the Microsoft SQL Server 2005 , clicked remove . It asked and it simply removed it clean including the native client etc. Although the Add/Remove page still shows the name it has actually removed the product. To remove the name from the list you will have to select them one by one and click remove. It will prompt you with something like 'This program can only be used for removing installed options' Just click Ok and the entry will go away .

For the tools setup to work when you install you will get a page after the SQL support files and Native client are installed wherein you are asked to choose what you wish to install . Select both the SQL database services as well as the Client tools ( Last option on the page ) then click next .

Regards

|||Thanks...

I went add/remove [the wrong sql server component first] and the computer removed the entry in add/remove programs but left the program (mostly) intact [I had to repair .net from the add/remove programs section]

>For

the tools setup to work when you install you will get a page after the

SQL support files and Native client are installed wherein you are asked

to choose what you wish to install . Select both the SQL database

services as well as the Client tools ( Last option on the page ) then

click next .

I still get the error/warning:

"The following

components that you chose to install are already installed on the

machine. To view a report of available options and alternatives click

on Details."

[Component is:

Workstation components, Books Online and development tools 9:00.1399.06]

Maybe I was just unlucky not to choose the databases on my first install.

I can install the sample databases that have there own msi, I suppose I can create a test

database and or try to attach those database files for now, thanks.

Thank you for your time,

Turloch

|||[FYI: I attached the demo databases installed as .msi files into my limping sql server install]|||I didn′t understand your last reply, is the problem solved ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Yes I managed to resolve the problem . Here is what I did

1) Went to Add/Remove programs

2) Select MS SQL Server 2005

3) Clicked on Remove ( It asked me what components I want to remove so I checked Both Database Server and Workgroup Client )

4) Then removed everything else that was MS SQL

5) Re-ran the setup file

Wala .. I had the SQL Server Management Console in the Program List.

Thanks all

Regards