Newbie question about installation

Hi,

I have just downloaded SQL Server 2005 Express Edition and am trying to run the setup. I have Windows XP Home Edition SP2 and I have received an error message saying that my operating system does not meet Service Pack level requirements. The documentation on the website shows that my service pack level is correct. Additionally the message suggests that I install the service pack from http://go.microsoft.com/fwlink/?LinkId=50380 but when I select that I get transferred to another web page which is unrelated.

Any ideas?

Did you install the .NET Framework on the machine (.NET 2.0 with additional fixes) ?

HTH, Jens Suessmeyer.

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

I have seen a couple of people asking this question about the service pack, and it was already loaded on... One of the solutions that has been found is to re run the service pack install on the machine, I would try that.

|||Thanks for the suggestion. I have rerun the download and this time I have had no problem.sql

Newbie question

When the installation of the Enterprizd edition completed
there was a message as follows
Setup could not initialize the report server. You must
manually initialize the report server beforeusing it for
the first time. For more information , seethe Reporting
Services setup documentaion.
I looked through the readme doc bit did not see anything
about this. Can anyone tell me what this means?I found the command window command to initialize the
report server
rsactivate -c"%installdir%\Reporting
Services\ReportServer\RSReportServer.config"
It reurned a message saying that
" Failure to start the web service. The Report Server
Web Service has not generated a public key. The
Servermay not have started sucessfully. Check the log
files for more information.
>--Original Message--
>When the installation of the Enterprizd edition
completed
>there was a message as follows
>Setup could not initialize the report server. You must
>manually initialize the report server beforeusing it for
>the first time. For more information , seethe Reporting
>Services setup documentaion.
>I looked through the readme doc bit did not see anything
>about this. Can anyone tell me what this means?
>.
>|||I believe the documentation states that you aren't supposed to have to
activate and install of RS unless installing in a web farm configuration.
However, I ran into this problem when installing a non web farm install of
RS.
I was able to overcome this by accessing the report manager or report
service with a user account that has administrative priviledges. Initially,
I was using a lower priviledge account to execute reports programmatically
which was failing. Once I hit the service with an Admin account, it
activated and then my lower priviledge account worked fine after that for
what I needed it to do.
Dale
"jim abel" <jim.abel@.lmco.com> wrote in message
news:2d4e101c469b1$0889e840$a301280a@.phx.gbl...
> When the installation of the Enterprizd edition completed
> there was a message as follows
> Setup could not initialize the report server. You must
> manually initialize the report server beforeusing it for
> the first time. For more information , seethe Reporting
> Services setup documentaion.
> I looked through the readme doc bit did not see anything
> about this. Can anyone tell me what this means?

Newbie Q: SQL Redundancy

Hi, If I have two machine in a cluster
- if I install SQL on one will the installation replicate on the other or do I have to install both seperatly,
- if I have SQL operating on both nodes and I write SQL to one will it replicate over automatically (does it remove the need for SQL redundancy)
- would WebPages do the same.
sorry for the newbie questions but was finding it hard to get specific answers, any help would be appreciated.
Steve
SQL Cluster installation puts the binaries on whatever host nodes you
specify. You can add or remove nodes later if you need to. The clustered
data store is accessable from both nodes, but is arbitrated so that only one
host at a time owns it owns. The entire data store shifts to another node
during a failover. A failover appears like a SQL stop/start to the outside
world. If you have a SQL instance running on a different host node in the
same cluster, it will have a different set of databases and will appear like
(because it is) a separate SQL server.
I do not understand your question about WebPages.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve
|||Setup will install SQL Server 2000 on both nodes. That is, it will install
the binaries and utilities on a local drive on each node and the data and
log files on the shared drive.
There is only one set of shared databses between the nodes. There is no
data redundancy; only high availability. So if you want data redundancy you
will need to use something like replication or log shipping.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Even in a SQL cluster, you have only one set of data (mounted by one node or
the other, but not both).
If you lose the storage solution or corrupt the data, you're toast. That's
where replication comes in.
Look at either NSI product (www.nsisoftware.com).
GeoCluster splits the storage under MSCS, so each node has its own copy -
although only one is active at a time.
DoubleTake replicates data between servers, and also from the active MSCS
node, to another server. This can be built in such a way that you could do
backups or snaps from the redundant server (which gives you some additional
restore and rollback capabilities).
jason
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve

Newbie Installation Problem

I'm using Visual Studio.Net and have been unable to access SQL Server
Databases from the Server Explorer. Under SQL Servers I did see one from the
Office Business Contact Manager (BCM). So I down loaded the MSDE Sp3a file
and installed it from a command prompt, setup SAPWD="AStrongPassword"
(substituting an actual password within the quotes). The setup seemed to
proceed smoothly and then just ended. Now in VS.Net Server Exporer I see a
second SQL Server with simply the computer name, and when I click on the "+"
to expand it, a Login Box pops up with my username under Login. If have
tried typing the password I entered after the SAPWD parameter with my user
name and the following login names: sa, SA, Admin, Administrator, all to no
effect. I've entered the password with and without quotes. Each time I get
the server does not exist or access denied message. The only way I have been
able to tell if the MSDE is actually running is by looking under processes in
the task manager. There I do see an SQL2000 process. I've looked at the
knowledge base describing connection problems, and most of those seemed to be
related to access from other computers, and it really isn't clear to me which
of the problems they describe might apply to a local machine by itself. Is
there a different login name I should be using? Many of the wizards in
Visual Studio only work with MS SQL, so its a real hassle not having it
installed. Any suggestions would be greatly appreciated.
hi,
JerryKogan wrote:
> I'm using Visual Studio.Net and have been unable to access SQL Server
> Databases from the Server Explorer. Under SQL Servers I did see one
> from the Office Business Contact Manager (BCM). So I down loaded the
> MSDE Sp3a file and installed it from a command prompt, setup
> SAPWD="AStrongPassword" (substituting an actual password within the
> quotes). The setup seemed to proceed smoothly and then just ended.
> Now in VS.Net Server Exporer I see a second SQL Server with simply
> the computer name, and when I click on the "+" to expand it, a Login
> Box pops up with my username under Login. If have tried typing the
> password I entered after the SAPWD parameter with my user name and
> the following login names: sa, SA, Admin, Administrator, all to no
> effect. I've entered the password with and without quotes. Each
> time I get the server does not exist or access denied message. The
> only way I have been able to tell if the MSDE is actually running is
> by looking under processes in the task manager. There I do see an
> SQL2000 process. I've looked at the knowledge base describing
> connection problems, and most of those seemed to be related to access
> from other computers, and it really isn't clear to me which of the
> problems they describe might apply to a local machine by itself. Is
> there a different login name I should be using? Many of the wizards
> in Visual Studio only work with MS SQL, so its a real hassle not
> having it installed. Any suggestions would be greatly appreciated.
MSDE installs by default allowing only tusted WinNT authenticated
connections.. you have to provide the additional
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer to allow SQL Server (standard)
authenticated connections or, after install, to modify the Windows registry
as foillowing:
(named instance)
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
(default instance, your case)
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

newbie connection problem

I am just starting with MSDE switching from access2002.
The installation was done on a server pc with:
password="sa",
Authentication Mode = SQL, and
DisableNetworkProtocols=0
On the server, I can connect to it fine, both via my app and the configure
wiz'd in the SYSTEM-DSNs list (off of control panel-Admin tools).
But from another PC on a two computer network, I cannot connect to it.
The configure wiz;d gives a double error:
SQLstate 1000 connaction failed ANd
SQLState 8001 error 17: serber does not exist or connection denied.
Do I need to specify anything other than server's name as the server's ID,
e.g. the hard disk label or...?
Do I need to somehow tell the server to allow a conection from another
PC? If yes, I can't find where that might be done?
I'd really appreciate ANY help on this frustrating problem.
Thanks in advance,
Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.
|||Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.

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!
>> >>
>> >>