Date parsed: 19/10/2007 09:29:10
Date: Fri, 19 Oct 2007 13:29:10 -0400
Instance means SQL Service Instance. No other component of SQL is an
Instance.
Workstation components are not part of an instance, They are management
tools, documentation, examples, and config tools.
Unpack the image to a folder and point there when the installer wants the
install folder. You must select SQL Server Database Services (first item on
the Components to Install dialog box) if you want to install the SQL Server
engine.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@discussions.microsoft.com> wrote in message
news:17D32179-E8F6-44E0-A67D-AE6F92921610@microsoft.com...
>
> Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
> valid installation file. I downloaded and installed the SQL Server 2005
> full-version trial. I did it two ways; I saved the image file (which
> doesn't
> work for adding a component in the instance dialog) and I also just
> installed
> the .exe that was the Download link. Neither one will let me install an
> instance. When I use the Report button, it says that I do have a common
> instance installed:
> Workstation Components
> [Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
> level: 9.2.3042 Language: English (United States)]
>
> Thank you!
> azanna.
>
> "Geoff N. Hiten" wrote:
>
>> Instances are the SQL services. Common components is common across the
>> various SQL subsystems. Go back and install an instance. Default
>> instance
>> should be what you need.
>>
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>>
>> "azanna" <azanna@discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
>>
>>
