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

I inherited a 2000 Advanced Server SQL 2000 Ent, Active-Passive setup. The
architect never got it working correctly, so he turned off the second node
and just left it running of the primary. We've been having reporting errors
in our application so I checked to see if everything was up-to-date and the
SQL Installation was still at the RTM level, no SPs at all (no wonder he had
problems). Because it's the end of the year and we needed to fix the problem
ASAP I evicted the second node and ran SP3a on the primary node to get our
reports on time.
Now what I'd like to do is set the thing up correctly, but am unsure of how
to approach bringing the evicted node back online as a failover node and get
it up to SP3a.
I'd be happy to hire an expert for a few hours if one of you MVPs lives in
Southern California, or wants to do a conference call and thinks that my
situation is too messed up to fix via newsgroup. If there is a good book I
can read on SQL clustering I'd like to hear about that as well.
Thanks.
Patrick Rouse
Microsoft MVP - Terminal Server
http://www.workthin.com
I think I may have found my answer here?
http://www.microsoft.com/windowsserv...5-d622b5b61369
&mid=8665605b-5a16-452f-8183-02b06b312b7f
"Patrick Rouse" wrote:

> I inherited a 2000 Advanced Server SQL 2000 Ent, Active-Passive setup. The
> architect never got it working correctly, so he turned off the second node
> and just left it running of the primary. We've been having reporting errors
> in our application so I checked to see if everything was up-to-date and the
> SQL Installation was still at the RTM level, no SPs at all (no wonder he had
> problems). Because it's the end of the year and we needed to fix the problem
> ASAP I evicted the second node and ran SP3a on the primary node to get our
> reports on time.
> Now what I'd like to do is set the thing up correctly, but am unsure of how
> to approach bringing the evicted node back online as a failover node and get
> it up to SP3a.
> I'd be happy to hire an expert for a few hours if one of you MVPs lives in
> Southern California, or wants to do a conference call and thinks that my
> situation is too messed up to fix via newsgroup. If there is a good book I
> can read on SQL clustering I'd like to hear about that as well.
> Thanks.
> --
> Patrick Rouse
> Microsoft MVP - Terminal Server
> http://www.workthin.com
|||Yep.. That is the correct procedure. See 'Maintaining a Failover Cluster'
in BOL for a detailed version. Pretend your second node has failed
completely.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Patrick Rouse" <PatrickRouse@.discussions.microsoft.com> wrote in message
news:12DFE27E-534D-4B31-94B3-03E15EFD3AA9@.microsoft.com...
> I think I may have found my answer here?
>
http://www.microsoft.com/windowsserv...5-d622b5b61369
&mid=8665605b-5a16-452f-8183-02b06b312b7f[vbcol=seagreen]
>
> "Patrick Rouse" wrote:
The[vbcol=seagreen]
node[vbcol=seagreen]
errors[vbcol=seagreen]
the[vbcol=seagreen]
had[vbcol=seagreen]
problem[vbcol=seagreen]
our[vbcol=seagreen]
how[vbcol=seagreen]
get[vbcol=seagreen]
in[vbcol=seagreen]
book I[vbcol=seagreen]

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 MSDTC question

What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...
Thanks
MSDTC or the Microsoft Distributed Transaction Cordinator is used for
distributed transactions.
A good description of it can be found in SQL Server Books Online:
http://msdn.microsoft.com/library/de...ar_cs_321x.asp
As you can see in the following article; MS DTC is not required for the
clustered SQL Server to work:
http://support.microsoft.com/default...b;en-us;260758
However if you have it installed on your server you need to run it in a
clustered state as you can see in the following article:
http://support.microsoft.com/default...b;en-us;301600
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
news:11273pop2eunj40@.news.supernews.com...
> What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K
> cluster? Cluster is already setup and virtual sql instance running ok...
> Thanks
>
>
|||While we are on the subject of MSDTC within a SQL Cluster, Simon has
referred to the standard (in my mind superficial) documentation on MSDTC, I
am looking for more detailed information:
1. The detailed architecture and how a transaction enlists target
databases.
2. How the authentication and permissions work for MSDTC in detail
(e.g.. why Cluster permissions are required for services enlisting MSDTC in
a cluster).
I have configured several high-availability applications requiring
distributed transactions and fully understand the requirements for
successfully implementing MSDTC/SQL, however I would like to understand the
internal operations of MSDTC.
Regard
Gary Hope
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:eHmSQLeHFHA.896@.TK2MSFTNGP10.phx.gbl...
> MSDTC or the Microsoft Distributed Transaction Cordinator is used for
> distributed transactions.
> A good description of it can be found in SQL Server Books Online:
> http://msdn.microsoft.com/library/de...ar_cs_321x.asp
> As you can see in the following article; MS DTC is not required for the
> clustered SQL Server to work:
> http://support.microsoft.com/default...b;en-us;260758
> However if you have it installed on your server you need to run it in a
> clustered state as you can see in the following article:
> http://support.microsoft.com/default...b;en-us;301600
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
> "Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
> news:11273pop2eunj40@.news.supernews.com...
>

Newbie in SQL Server admin

Can you give me the step-by-step procedure to setup some alerts in SQL
2000 to get pager or email notification once the :

1- SQL Server (service) is down
2- Trans log is full"Frank" <soal6570@.yahoo.com> wrote in message
news:42601b2.0404061558.62fda9af@.posting.google.co m...
> Can you give me the step-by-step procedure to setup some alerts in SQL
> 2000 to get pager or email notification once the :
> 1- SQL Server (service) is down
> 2- Trans log is full

For #1, look at the Windows Service manager.

This has a "Recovery" tab, and the ability to run a custom program on
service failure.

...

Steven|||soal6570@.yahoo.com (Frank) wrote in message news:<42601b2.0404061558.62fda9af@.posting.google.com>...
> Can you give me the step-by-step procedure to setup some alerts in SQL
> 2000 to get pager or email notification once the :
> 1- SQL Server (service) is down
> 2- Trans log is full

1. SQL Server Agent can send an alert if the MSSQL process reports a
fatal error, but if it's down as well, it won't be able to alert you.
So you may want to look at it as a general Windows issue - if you
already have a Windows event monitoring system in place, then you can
use that to do something when the MSSQL services stop and start (by
default, they are set to auto restart). You can also use the Control
Panel Services applet to do something (run a script etc.) when a
service fails to start.

2. Email/pager notifications require SQL Mail:

http://support.microsoft.com/defaul...kb;EN-US;263556

After doing that, then you can use Enterprise Manager to create
whatever alerts you need. There is a demo alert already created for a
full log condition, so you can use it as a template.

Simon

Newbie Datetime Parameter problem

Hi, I have setup start date and end date parameters, however when my select gets the results from between the dates, if the dates are both set to today, no results are produced. I think its because I need to add a day to the end date parameter. How can I do this?

Thanks, Dan

Dan,

What you'll need to do is add one to your end date, like you said. You can do that by updating your SQL coding to something like this:

where ....
and DateField between @.StartDate and dateadd(day, 1, @.EndDate)
...

Hope this helps.

Jarret

|||

Thats perfect.

Thank you.

newbie column header line break question

Hi,
Can anyone tell me the syntax to setup a table column header with a
line break embedded like:
Shares
Voted
ThanksI think this is what you need. Type exactly in the header textbox:
="Shares" & vbcrlf & "Voted"
'vbcrlf' will embed a carriage return.
Hope that helps
rgorslin
"tom" wrote:
> Hi,
> Can anyone tell me the syntax to setup a table column header with a
> line break embedded like:
>
> Shares
> Voted
>
> Thanks
>