Monday, February 20, 2012

NEWB Question - Runs as a Service?

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!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!|||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!
>|||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!
>>|||Here's what I get: "There are no items to show in this view." Wah!
"Ekrem Ã?nsoy" wrote:
> Will you open up SQL Server Configuration Manager from Configuration Tools
> and look for SQL Server services from SQL Server 2005 Services node?
> It would be good if you send us a list of those services listed in the SQL
> Server 2005 Services window.
> Also, tell us about their statuses (Running\Stopped)
> --
> Ekrem Ã?nsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>
> "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!
> >>
> >>
>|||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!
> >>
> >>
>|||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!
>> >>
>> >>
>>|||Will you open up SQL Server Configuration Manager from Configuration Tools
and look for SQL Server services from SQL Server 2005 Services node?
It would be good if you send us a list of those services listed in the SQL
Server 2005 Services window.
Also, tell us about their statuses (Running\Stopped)
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"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!
>>|||It's obviously clear that you have no any installed SQL Server instance.
Will you try to start the SQL Server setup and try to install an instance?
Do not skip checking Database Engine from the Components to Install window
that will appear in setup process.
After the setup, go to Configuration Manager and look for SQL Server
services and tell us what happens.
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:217AB314-58A5-4BA2-B9D8-48082526E886@.microsoft.com...
> Here's what I get: "There are no items to show in this view." Wah!
> "Ekrem Ã?nsoy" wrote:
>> Will you open up SQL Server Configuration Manager from Configuration
>> Tools
>> and look for SQL Server services from SQL Server 2005 Services node?
>> It would be good if you send us a list of those services listed in the
>> SQL
>> Server 2005 Services window.
>> Also, tell us about their statuses (Running\Stopped)
>> --
>> Ekrem Ã?nsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>>
>> "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!
>> >>
>> >>

No comments:

Post a Comment