Thursday, March 22, 2012
can use microsoft .net 2002
I want to know if I can install reporting services using microsoft .Net
version 2002...because I read the requirements and it said microsoft .net
2003...but I have .net version 2002...Do you think that I can use version 200?
cheers,No, you cannot. You need any version of VS 2003 (VB.Net is the cheapest at
about $100).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kellyc" <Kellyc@.discussions.microsoft.com> wrote in message
news:E4BD0C49-9655-453A-87F0-632E2345C360@.microsoft.com...
> Hi everybody,
> I want to know if I can install reporting services using microsoft .Net
> version 2002...because I read the requirements and it said microsoft .net
> 2003...but I have .net version 2002...Do you think that I can use version
200?
> cheers,
Monday, March 19, 2012
Can the SQL Server 2005 be installed on Windows 2003 SP1?
I recently attempted to install Windows 2003 SP1 on a machine on which someone had previously installed SQL Server 2005. The build number for the SQL Server 2005 installation is 9.0.1116. (BTW, which CTP is this build number?)
The installation of the service pack seemed to go okay, but I soon got calls from users reporting that they could not log in to the instance. I investigated, and discovered that the SQL Server service had not started. We were unable to start the service, and had to remove SP1.
This was the message I found in Event Viewer:
Event Type: Error
Event Source: SQLDUMPER
Event Category: None
Event ID: 5000
Date: 8/15/2005
Time: 10:30:30
User: N/A
Computer: YKOADS3
Description:
EventType sql90exception, P1 sqlservr.exe, P2 2000.90.1116.0, P3 4258cf76, P4 msvcrt.dll, P5 7.0.3790.1830, P6 4243785e, P7 0, P8 00038944, P9 a3a034ae, P10 NIL.
My questions are:
1) What happened?
2) Can I install the current CTP on Windows 2003 SP1?
That version corresponds to the April CTP of SQL Server.
You could log that as a bug in Product Feedback:
http://lab.msdn.microsoft.com/productfeedback/
Regards,
Vikram|||Well, if my issue occurred with the April CTP I see no need to log the issue now. I'm currently installing the June CTP, whose documentation says it works with 2003 SP1. I'll post the build number when I'm finished, as well as let everyone know the results.
Thanks for the reply,
Ken|||The Build number for June CTP needs is 9.0.1187. I have it running successfully on machine with Win2003 server with SP1. I installed SQL Server 2005 after installing SP1.
Regards,
Vikram|||
I installed the June CTP on Windows 2003 SP1 and I am up and running. Thanks.
Ken
Can the SQL 2005 install upgrade from SQL 2000 handle multiple instances?
HTH, jens SUessmeyer.
http://www.sqlserver2005.de
Thursday, March 8, 2012
Can SQL2005 run with Oracle 10g in the same Server?
Sure. They're independent products and can work side-by-side. Though, they will both content for system resources.
Can SQL tools be installed from server install?
Can SQL Server tools (QA, EM) can be installed on a client machine from
a full SQL Server installation on a server? I can't find the CD.
Thanks for your time.
EricEric Bragas (ericbragas@.yahoo.com) writes:
> Can SQL Server tools (QA, EM) can be installed on a client machine from
> a full SQL Server installation on a server? I can't find the CD.
Probably, but you would have to spend some time registering DLLs etc,
and it would be quite messy.
So finding the CD is a good idea.
If you are an MSDN Universal Subscribler, you can get it from MSDN
Downloads.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can load it
from there. The tools will not expire, just make sure you only select
client tools and not the database engine
Akinja Richards
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9686B453DA798Yazorman@.127.0.0.1...
> Eric Bragas (ericbragas@.yahoo.com) writes:
>> Can SQL Server tools (QA, EM) can be installed on a client machine from
>> a full SQL Server installation on a server? I can't find the CD.
> Probably, but you would have to spend some time registering DLLs etc,
> and it would be quite messy.
> So finding the CD is a good idea.
> If you are an MSDN Universal Subscribler, you can get it from MSDN
> Downloads.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Akinja (akinja@.sbcglobal.net) writes:
> If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can
> load it from there. The tools will not expire, just make sure you only
> select client tools and not the database engine
And if you don't have it, you can download it from www.microsoft.com.
There might be two issues:
1) License may not permit connecting to production environments.
2) It used to be that service packs can be applied to EvalEdition. I
don't know if this still is the case.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I think MS has smart to that trick. I haven't tried it.
Akinja
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9686EB719AA49Yazorman@.127.0.0.1...
> Akinja (akinja@.sbcglobal.net) writes:
>> If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can
>> load it from there. The tools will not expire, just make sure you only
>> select client tools and not the database engine
> And if you don't have it, you can download it from www.microsoft.com.
> There might be two issues:
> 1) License may not permit connecting to production environments.
> 2) It used to be that service packs can be applied to EvalEdition. I
> don't know if this still is the case.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
Can SQL Server7.0 be installed in XP Professional O/S
SQL Server7.0 or 2000 Server Components in XP Professioal
operating system. I have SP1 installed.
I want both the Server and Client components to be
installed on the same machine running XP Professional. Is
there any way...please let me know.
Thanks,
Sivatechnically, yes. it is however crippled. I had installed it (SQL2000) on my
laptop to test at home but it is missing some managment utils and you will
be limited to 10 connections inbound. it's not useful though and really just
drags you system down. (not worth the license).
Neil MacMurchy
"Siva" <vssivakumar33@.yahoo.com> wrote in message
news:1b4c01c3fc0f$0b876f00$a301280a@.phx.gbl...
> I would appreciate to know, Is it possibale to install
> SQL Server7.0 or 2000 Server Components in XP Professioal
> operating system. I have SP1 installed.
> I want both the Server and Client components to be
> installed on the same machine running XP Professional. Is
> there any way...please let me know.
> Thanks,
> Siva|||Hi Siva.
Yes - they can, as long as you're installing the correct EDITION of SQL
Server for XP.
There's a list of which editions can be installed on which O/Ss here:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
Short answer though is that you probably want Developer Edition if you're
developing databases, stored procs etc. It is cheap too - approx $50 I
believe..
HTH
Regards,
Greg Linwood
SQL Server MVP
"Siva" <vssivakumar33@.yahoo.com> wrote in message
news:1b4c01c3fc0f$0b876f00$a301280a@.phx.gbl...
> I would appreciate to know, Is it possibale to install
> SQL Server7.0 or 2000 Server Components in XP Professioal
> operating system. I have SP1 installed.
> I want both the Server and Client components to be
> installed on the same machine running XP Professional. Is
> there any way...please let me know.
> Thanks,
> Siva
Can sql server run on XP Pro?
Windows XP Professional.
Check the Url for more details:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp|||Yes, it can run on XP Pro. I have done it before.|||Thanks, I have downloaded evaluation edition on XP. To Pjmcb: do you mean you run the full version on XP Pro?I can get free software from my college but they would not give it to me without Server OS(which they are out of + I would need to change OS)|||I have ran the Standard Edition of SQL Server 2000 on XP Pro and 2000 Pro, no problem.
Wednesday, March 7, 2012
Can SQL Server 2000/2005 Co-Exist On One Server?
Can I install SQL Server 2000 and SQL Server 2005 on the same physical server and be able to access them independently through their respective tools (E/M, Q/A, SSMS) and through ADO, OLEDB?
We have an upgrade issue that involves some parallel testing without buying a new server. Hey, i just work here right?
can sql 7 and sql 2000 coexist on the same machine
in standalone disconnected mode. I need to install a relatively old piece
of software which was developed for sql 7.
My question is if I can safely install sql 7 server on the laptop without
conflict with the already installed sql 2000 server?
Sincerely,
Zvi Weiss
You can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7 is
the default instance and SQL 2000 is a named instance.
The easiest is probably to install the database for your piece of software
on SQL 2000 and set the database to 70 compatibility mode.
If that doesn't work, I guess that you have already installed SQL 2000 as
the default instance on your laptop, so you would have to change that to a
named instance. The most "straightforward" way would be to detach the
databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL 2000
as a named instance and reattach the databases.
Jacco Schalkwijk
SQL Server MVP
"Zvi Weiss" <zvweiss@.optonline.net> wrote in message
news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> I have sql server 2000 installed on my laptop. I use this laptop for
demos
> in standalone disconnected mode. I need to install a relatively old piece
> of software which was developed for sql 7.
> My question is if I can safely install sql 7 server on the laptop without
> conflict with the already installed sql 2000 server?
> Sincerely,
> Zvi Weiss
>
|||Perfect. Worked like a charm.
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:eZ1V4n6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> You can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7
is
> the default instance and SQL 2000 is a named instance.
> The easiest is probably to install the database for your piece of software
> on SQL 2000 and set the database to 70 compatibility mode.
> If that doesn't work, I guess that you have already installed SQL 2000 as
> the default instance on your laptop, so you would have to change that to a
> named instance. The most "straightforward" way would be to detach the
> databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL
2000[vbcol=seagreen]
> as a named instance and reattach the databases.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Zvi Weiss" <zvweiss@.optonline.net> wrote in message
> news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> demos
piece[vbcol=seagreen]
without
>
can sql 7 and sql 2000 coexist on the same machine
in standalone disconnected mode. I need to install a relatively old piece
of software which was developed for sql 7.
My question is if I can safely install sql 7 server on the laptop without
conflict with the already installed sql 2000 server?
Sincerely,
Zvi WeissYou can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7 is
the default instance and SQL 2000 is a named instance.
The easiest is probably to install the database for your piece of software
on SQL 2000 and set the database to 70 compatibility mode.
If that doesn't work, I guess that you have already installed SQL 2000 as
the default instance on your laptop, so you would have to change that to a
named instance. The most "straightforward" way would be to detach the
databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL 2000
as a named instance and reattach the databases.
--
Jacco Schalkwijk
SQL Server MVP
"Zvi Weiss" <zvweiss@.optonline.net> wrote in message
news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> I have sql server 2000 installed on my laptop. I use this laptop for
demos
> in standalone disconnected mode. I need to install a relatively old piece
> of software which was developed for sql 7.
> My question is if I can safely install sql 7 server on the laptop without
> conflict with the already installed sql 2000 server?
> Sincerely,
> Zvi Weiss
>|||Perfect. Worked like a charm.
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:eZ1V4n6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> You can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7
is
> the default instance and SQL 2000 is a named instance.
> The easiest is probably to install the database for your piece of software
> on SQL 2000 and set the database to 70 compatibility mode.
> If that doesn't work, I guess that you have already installed SQL 2000 as
> the default instance on your laptop, so you would have to change that to a
> named instance. The most "straightforward" way would be to detach the
> databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL
2000
> as a named instance and reattach the databases.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Zvi Weiss" <zvweiss@.optonline.net> wrote in message
> news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> > I have sql server 2000 installed on my laptop. I use this laptop for
> demos
> > in standalone disconnected mode. I need to install a relatively old
piece
> > of software which was developed for sql 7.
> >
> > My question is if I can safely install sql 7 server on the laptop
without
> > conflict with the already installed sql 2000 server?
> >
> > Sincerely,
> > Zvi Weiss
> >
> >
>
can sql 7 and sql 2000 coexist on the same machine
in standalone disconnected mode. I need to install a relatively old piece
of software which was developed for sql 7.
My question is if I can safely install sql 7 server on the laptop without
conflict with the already installed sql 2000 server?
Sincerely,
Zvi WeissYou can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7 is
the default instance and SQL 2000 is a named instance.
The easiest is probably to install the database for your piece of software
on SQL 2000 and set the database to 70 compatibility mode.
If that doesn't work, I guess that you have already installed SQL 2000 as
the default instance on your laptop, so you would have to change that to a
named instance. The most "straightforward" way would be to detach the
databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL 2000
as a named instance and reattach the databases.
Jacco Schalkwijk
SQL Server MVP
"Zvi Weiss" <zvweiss@.optonline.net> wrote in message
news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> I have sql server 2000 installed on my laptop. I use this laptop for
demos
> in standalone disconnected mode. I need to install a relatively old piece
> of software which was developed for sql 7.
> My question is if I can safely install sql 7 server on the laptop without
> conflict with the already installed sql 2000 server?
> Sincerely,
> Zvi Weiss
>|||Perfect. Worked like a charm.
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:eZ1V4n6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> You can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7
is
> the default instance and SQL 2000 is a named instance.
> The easiest is probably to install the database for your piece of software
> on SQL 2000 and set the database to 70 compatibility mode.
> If that doesn't work, I guess that you have already installed SQL 2000 as
> the default instance on your laptop, so you would have to change that to a
> named instance. The most "straightforward" way would be to detach the
> databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL
2000
> as a named instance and reattach the databases.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Zvi Weiss" <zvweiss@.optonline.net> wrote in message
> news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> demos
piece[vbcol=seagreen]
without[vbcol=seagreen]
>
Saturday, February 25, 2012
can SQL 2000 evaluation install on XP
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:
>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en...ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
|||thks everyone for the help given
"Mike Hodgson" wrote:
> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
>
can SQL 2000 evaluation install on XP
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsThis is a multi-part message in MIME format.
--020107020505020303050800
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020107020505020303050800
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020107020505020303050800--|||This is a multi-part message in MIME format.
--020009090209050906080707
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--020009090209050906080707
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--020009090209050906080707--|||This is a multi-part message in MIME format.
--090003090205020301090702
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>
--090003090205020301090702
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
maxzsim wrote:
<blockquote cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</body>
</html>
--090003090205020301090702--|||This is a multi-part message in MIME format.
--000409060207070309090809
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
--000409060207070309090809
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Sorry about the multi-posts. Thunderbird spat the dummy.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
</div>
<br>
<br>
<br>
Mike Hodgson wrote:
<blockquote cite="mid421D4005.3080803@.mallesons.nospam.com" type="cite">
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<tt>Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma"
size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
maxzsim wrote:
<blockquote
cite="midE0C7A008-8152-49CF-888B-F3CB9A87E7F8@.microsoft.com"
type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</body>
</html>
--000409060207070309090809--|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
> > Which edition? Personal, standard or enterprise? Standard &
> > Enterprise must go on a server O/S. Personal edition can go on a
> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> > Developer edition is the same as the Enterprise edition except just
> > licensed differently.
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> > http://www.mallesons.com
> >
> >
> >
> > maxzsim wrote:
> >
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
>|||This is a multi-part message in MIME format.
--060404050301060308050608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
--060404050301060308050608
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>You'd need one of the Windows NT Server, Window 2000 Server or
Windows 2003 Server O/S families for Enterprise Edition (even if it is
just an eval - that just means it's time bombed for 120 days). For
Windows XP Pro you'll need the Personal Edition of SQL Server 2000.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
maxzsim wrote:
<blockquote cite="mid1AFC65A9-8C8F-4F0B-ADF8-A7E78AD678BC@.microsoft.com"
type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--060404050301060308050608--|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>> Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>> Mike Hodgson wrote:
>> > Which edition? Personal, standard or enterprise? Standard &
>> > Enterprise must go on a server O/S. Personal edition can go on a
>> > workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>> > Developer edition is the same as the Enterprise edition except just
>> > licensed differently.
>> >
>> > --
>> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
>> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>> > http://www.mallesons.com
>> >
>> >
>> >
>> > maxzsim wrote:
>> >
>> >>Hi ,
>> >>
>> >> i am using sql server 2000 evaluation copy , can it be installed on XP
>> >>professional ?
>> >>
>> >>rdgs
>> >>
>> >>
>> >>
>> >>|||This is a multi-part message in MIME format.
--030203010807050905000109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:
>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>>Hi Mike ,
>>i am using the evaluation copy of the Enterprise Edition
>>rdgs
>>"Mike Hodgson" wrote:
>>
>>Sorry about the multi-posts. Thunderbird spat the dummy.
>>
>>Mike Hodgson wrote:
>>
>>Which edition? Personal, standard or enterprise? Standard &
>>Enterprise must go on a server O/S. Personal edition can go on a
>>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
>>Developer edition is the same as the Enterprise edition except just
>>licensed differently.
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>http://www.mallesons.com
>>
>>maxzsim wrote:
>>
>>Hi ,
>> i am using sql server 2000 evaluation copy , can it be installed on XP
>>professional ?
>>rdgs
>>
>>
>>
>
>
--030203010807050905000109
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hmmm...oops. Sorry 'bout my errata. <span class="moz-smiley-s6"><span>
:-[ </span></span> I'm having a shocker lately. Maybe I should
take a break from the newsgroups for a while and going back to playing
chess.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Sue Hoegemeier wrote:
<blockquote cite="midalkq11h6gpb048hoi2rum3otilivp4ci8q@.4ax.com"
type="cite">
<pre wrap="">Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp">http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp</a>
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:maxzsim@.discussions.microsoft.com"><maxzsim@.discussions.microsoft.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Which edition? Personal, standard or enterprise? Standard &
Enterprise must go on a server O/S. Personal edition can go on a
workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
Developer edition is the same as the Enterprise edition except just
licensed differently.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
maxzsim wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi ,
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgs
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--030203010807050905000109--|||thks everyone for the help given
"Mike Hodgson" wrote:
> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Sue Hoegemeier wrote:
> >Yes...the Enterprise Evaluation Edition is supported on XP
> >Pro. You can find the supported operating systems at:
> >http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp
> >
> >-Sue
> >
> >On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> > <maxzsim@.discussions.microsoft.com> wrote:
> >
> >
> >
> >>Hi Mike ,
> >>
> >>i am using the evaluation copy of the Enterprise Edition
> >>
> >>rdgs
> >>
> >>"Mike Hodgson" wrote:
> >>
> >>
> >>
> >>Sorry about the multi-posts. Thunderbird spat the dummy.
> >>
> >>
> >>
> >>Mike Hodgson wrote:
> >>
> >>
> >>
> >>Which edition? Personal, standard or enterprise? Standard &
> >>Enterprise must go on a server O/S. Personal edition can go on a
> >>workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> >>Developer edition is the same as the Enterprise edition except just
> >>licensed differently.
> >>
> >>--
> >>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
> >>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> >>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> >>http://www.mallesons.com
> >>
> >>
> >>
> >>maxzsim wrote:
> >>
> >>
> >>
> >>Hi ,
> >>
> >> i am using sql server 2000 evaluation copy , can it be installed on XP
> >>professional ?
> >>
> >>rdgs
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
>|||No problem Mike...we all have those moments. Don't worry
about it.
-Sue
On Thu, 24 Feb 2005 15:26:40 +1100, Mike Hodgson
<mike.hodgson@.mallesons.nospam.com> wrote:
>Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
>lately. Maybe I should take a break from the newsgroups for a while and
>going back to playing chess.
can SQL 2000 evaluation install on XP
i am using sql server 2000 evaluation copy , can it be installed on XP
professional ?
rdgsWhich edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Which edition? Personal, standard or enterprise? Standard & Enterprise
must go on a server O/S. Personal edition can go on a workstation O/S
(XP Pro, Win 2000 pro, NT 4.0 Workstation). The Developer edition is
the same as the Enterprise edition except just licensed differently.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
>Hi ,
> i am using sql server 2000 evaluation copy , can it be installed on XP
>professional ?
>rdgs
>
>|||Sorry about the multi-posts. Thunderbird spat the dummy.
Mike Hodgson wrote:
[vbcol=seagreen]
> Which edition? Personal, standard or enterprise? Standard &
> Enterprise must go on a server O/S. Personal edition can go on a
> workstation O/S (XP Pro, Win 2000 pro, NT 4.0 Workstation). The
> Developer edition is the same as the Enterprise edition except just
> licensed differently.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> maxzsim wrote:
>|||Hi Mike ,
i am using the evaluation copy of the Enterprise Edition
rdgs
"Mike Hodgson" wrote:
> Sorry about the multi-posts. Thunderbird spat the dummy.
>
> Mike Hodgson wrote:
>
>|||You'd need one of the Windows NT Server, Window 2000 Server or Windows
2003 Server O/S families for Enterprise Edition (even if it is just an
eval - that just means it's time bombed for 120 days). For Windows XP
Pro you'll need the Personal Edition of SQL Server 2000.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
maxzsim wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>
>|||Yes...the Enterprise Evaluation Edition is supported on XP
Pro. You can find the supported operating systems at:
http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
-Sue
On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
<maxzsim@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Mike ,
> i am using the evaluation copy of the Enterprise Edition
>rdgs
>"Mike Hodgson" wrote:
>|||Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
lately. Maybe I should take a break from the newsgroups for a while and
going back to playing chess.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Sue Hoegemeier wrote:
>Yes...the Enterprise Evaluation Edition is supported on XP
>Pro. You can find the supported operating systems at:
>http://msdn.microsoft.com/library/e..._ar_ts_7eur.asp
>-Sue
>On Wed, 23 Feb 2005 19:11:02 -0800, "maxzsim"
> <maxzsim@.discussions.microsoft.com> wrote:
>
>
>
>|||thks everyone for the help given
"Mike Hodgson" wrote:
> Hmmm...oops. Sorry 'bout my errata. :-[ I'm having a shocker
> lately. Maybe I should take a break from the newsgroups for a while and
> going back to playing chess.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* [url]http://www.mallesons.com[/url
]
>
> Sue Hoegemeier wrote:
>
>
Can SQL 2000 Enterprise Manager & SQL 2005 Mgnt Studio coexist ?
I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC.
Can they be coexisted and both can be used ? OR
I have to uninstall 2000 client first.
Regards,
Johnny
Hello,
They can co-exist. Make sure you installl the software in seperate
directory.
Thanks
Hari
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:F553693B-19D1-4EA7-9EEC-062287EE1628@.microsoft.com...
> Hi,
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC. I
> would like to install SQL 2005 native client (Mgnt Studio etc) on the same
> PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
> Regards,
> Johnny
|||Johnny (Johnny@.discussions.microsoft.com) writes:
> I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC.
> I would like to install SQL 2005 native client (Mgnt Studio etc) on the
> same PC.
> Can they be coexisted and both can be used ? OR
> I have to uninstall 2000 client first.
They can co-exist as Hari said.
I just like to make a clafication: SQL Native Client is a single DLL
which contains an updated ODBC driver and an updated OLE DB provider
for SQL 2005. SQL Native is a redistributable component. SQL Native is
about the first which is installed when you run the SQL Server installation.
You are apparently thinking of the Workstation components, of which some
may use SQL Native Client, but far from all do. Management Studio, for
instance, uses SqlClient, a .Net provider. ("Native" in SQL Native Client
refers to that it is in native code, as opposed to the managed code of
..Net.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Can Sql 2000 and Sql 2005 exist on same server?
My instructions are to install Sql 2005 on server BIGPETE2. I found that there was already an installation of Sql 2000, with databases that I was quite sure should remain as SQL 2000.
According to info I found on the internet, it should be possible to have separate instances of 2000 and 2005, so I went ahead and tried to install, giving the 2005 version a different name, BIGPETE2005. It didn't hit me with any error messages, but neither did it install a different database server. When I was finished, I was able to open Management Studio, but the only database server it could find to open was BIGPETE2, which is not what I wanted.
Enterprise Manager still works, and the mdf dates haven't updated, so I'm guessing the data is still safe, but I need both servers up and running.
Okay, I just read through the installation report, and I saw this:
Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
1. What service pack is it asking for?
2. And doesn't that imply that it's upgrading my Sql 2000 installation instead of installing a new instance of Sql 2005?
In Management Studio, you will be able to connect to both instances. To connect to your SQL 2005 instance, you'll need to supply machine name / instance name (ex: MACHINE/BIGPETE2005).
Thanks,
Sam Lester (MSFT)
Sunday, February 19, 2012
Can RS 2005 point to SQL 2000 DB?
separate SQL Server 2000 box which would be used to host its two databases
(ReportingServer and ReportingServerTempDB).
Will this work?
--
LulkYes. You need a 2005 license on the IIS box but the databases can be on 2000
(I am running in this configuration).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Yes, this will work. The database will have to have its schema updated, but
can be hosted on SQL Server 2000. You can use the Reporting Services
Configuration Tool to accomplish this easily enough.
Rodney
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Does it require two SQL Server licenses if you are going to run RS 2005 on a
separate ISS server and point to a separate 2000 SQL Server? What if I point
to a separate SQL 2005 Server, would that configuration still require two SQL
Server licenses?
--
Lulk
"Bruce L-C [MVP]" wrote:
> Yes. You need a 2005 license on the IIS box but the databases can be on 2000
> (I am running in this configuration).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
> >I would like to install Reporting Services 2005 on one IIS box and point to
> >a
> > separate SQL Server 2000 box which would be used to host its two databases
> > (ReportingServer and ReportingServerTempDB).
> >
> > Will this work?
> > --
> > Lulk
>
>|||Yes. Whatever box RS is running on needs a license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:3A86DA3A-674D-4F8E-BAF2-9CB0823DEF9A@.microsoft.com...
> Does it require two SQL Server licenses if you are going to run RS 2005 on
> a
> separate ISS server and point to a separate 2000 SQL Server? What if I
> point
> to a separate SQL 2005 Server, would that configuration still require two
> SQL
> Server licenses?
> --
> Lulk
>
> "Bruce L-C [MVP]" wrote:
>> Yes. You need a 2005 license on the IIS box but the databases can be on
>> 2000
>> (I am running in this configuration).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
>> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>> >I would like to install Reporting Services 2005 on one IIS box and point
>> >to
>> >a
>> > separate SQL Server 2000 box which would be used to host its two
>> > databases
>> > (ReportingServer and ReportingServerTempDB).
>> >
>> > Will this work?
>> > --
>> > Lulk
>>
Can Reporting Services use IIS on another server?
installation prerequisite). Well, I really don't want to put IIS on a
production SQL Server. I like IIS, but it certainly exposes a lot more
potential security holes on the server because any website hosting product
is always a security risk to that machine. Besides, my SQL Server is not
exposed to the internet like my web servers, so I don't quite get why I
would even want IIS on the SQL Server.
I want to use Reporting Services, though. Can I somehow use Reporting
Services against IIS on another server? I'm not describing it well because
I've never used Reporting Services and I don't know if it, too, would be on
the other server, or what. Can someone guide me as to my options here, and
what to install where to keep the SQL Server machine more secure and stable
but still have Reporting Services capabilities? Thank you.Yes. You can install Reporting Services on an application (web) server
apart from your SQL database server. In fact, this is a very common
installation technique. Install and configure IIS on the desired server. I
strongly recommend having a certificate on that server. You can then
install Reporting Services 2005 on that server. Once it is installed, you
can configure it to use your production SQL server for its back-end
databases using the Reporting Services Configuration tool.
I have two suggestions for getting started. One, build a throwaway test
server to do your first testing and deployment on. Second, purchase a good
book on Reporting Services. Both will save you a lot of headaches.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
> Reporting Services on SQL 2005 says that I must install IIS (its an
> installation prerequisite). Well, I really don't want to put IIS on a
> production SQL Server. I like IIS, but it certainly exposes a lot more
> potential security holes on the server because any website hosting product
> is always a security risk to that machine. Besides, my SQL Server is not
> exposed to the internet like my web servers, so I don't quite get why I
> would even want IIS on the SQL Server.
> I want to use Reporting Services, though. Can I somehow use Reporting
> Services against IIS on another server? I'm not describing it well
> because
> I've never used Reporting Services and I don't know if it, too, would be
> on
> the other server, or what. Can someone guide me as to my options here,
> and
> what to install where to keep the SQL Server machine more secure and
> stable
> but still have Reporting Services capabilities? Thank you.
>|||and what book would be a good book, Geoff?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
> Yes. You can install Reporting Services on an application (web) server
> apart from your SQL database server. In fact, this is a very common
> installation technique. Install and configure IIS on the desired server.
> I strongly recommend having a certificate on that server. You can then
> install Reporting Services 2005 on that server. Once it is installed, you
> can configure it to use your production SQL server for its back-end
> databases using the Reporting Services Configuration tool.
> I have two suggestions for getting started. One, build a throwaway test
> server to do your first testing and deployment on. Second, purchase a
> good book on Reporting Services. Both will save you a lot of headaches.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
>|||Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
Reporting Services" by Peter BlackBurn and William Vaughn, I will have to go
with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
written against the beta release which was very close to the production
version, and is geared towards the beginning Reporting Services user. I
think there is a BI/Reporting Services volume forthcoming for the "Inside
SQL Server 2005" series, but I haven't seen a formal announcement yet.
Amazon has several other volumes in this series available for pre-order.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
> and what book would be a good book, Geoff?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
>|||thanks Geoff
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23rccjA4UGHA.4792@.TK2MSFTNGP14.phx.gbl...
> Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
> Reporting Services" by Peter BlackBurn and William Vaughn, I will have to
> go with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
> written against the beta release which was very close to the production
> version, and is geared towards the beginning Reporting Services user. I
> think there is a BI/Reporting Services volume forthcoming for the "Inside
> SQL Server 2005" series, but I haven't seen a formal announcement yet.
> Amazon has several other volumes in this series available for pre-order.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
>
Can Reporting Services use IIS on another server?
installation prerequisite). Well, I really don't want to put IIS on a
production SQL Server. I like IIS, but it certainly exposes a lot more
potential security holes on the server because any website hosting product
is always a security risk to that machine. Besides, my SQL Server is not
exposed to the internet like my web servers, so I don't quite get why I
would even want IIS on the SQL Server.
I want to use Reporting Services, though. Can I somehow use Reporting
Services against IIS on another server? I'm not describing it well because
I've never used Reporting Services and I don't know if it, too, would be on
the other server, or what. Can someone guide me as to my options here, and
what to install where to keep the SQL Server machine more secure and stable
but still have Reporting Services capabilities? Thank you.
Yes. You can install Reporting Services on an application (web) server
apart from your SQL database server. In fact, this is a very common
installation technique. Install and configure IIS on the desired server. I
strongly recommend having a certificate on that server. You can then
install Reporting Services 2005 on that server. Once it is installed, you
can configure it to use your production SQL server for its back-end
databases using the Reporting Services Configuration tool.
I have two suggestions for getting started. One, build a throwaway test
server to do your first testing and deployment on. Second, purchase a good
book on Reporting Services. Both will save you a lot of headaches.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
> Reporting Services on SQL 2005 says that I must install IIS (its an
> installation prerequisite). Well, I really don't want to put IIS on a
> production SQL Server. I like IIS, but it certainly exposes a lot more
> potential security holes on the server because any website hosting product
> is always a security risk to that machine. Besides, my SQL Server is not
> exposed to the internet like my web servers, so I don't quite get why I
> would even want IIS on the SQL Server.
> I want to use Reporting Services, though. Can I somehow use Reporting
> Services against IIS on another server? I'm not describing it well
> because
> I've never used Reporting Services and I don't know if it, too, would be
> on
> the other server, or what. Can someone guide me as to my options here,
> and
> what to install where to keep the SQL Server machine more secure and
> stable
> but still have Reporting Services capabilities? Thank you.
>
|||and what book would be a good book, Geoff?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
> Yes. You can install Reporting Services on an application (web) server
> apart from your SQL database server. In fact, this is a very common
> installation technique. Install and configure IIS on the desired server.
> I strongly recommend having a certificate on that server. You can then
> install Reporting Services 2005 on that server. Once it is installed, you
> can configure it to use your production SQL server for its back-end
> databases using the Reporting Services Configuration tool.
> I have two suggestions for getting started. One, build a throwaway test
> server to do your first testing and deployment on. Second, purchase a
> good book on Reporting Services. Both will save you a lot of headaches.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
>
|||Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
Reporting Services" by Peter BlackBurn and William Vaughn, I will have to go
with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
written against the beta release which was very close to the production
version, and is geared towards the beginning Reporting Services user. I
think there is a BI/Reporting Services volume forthcoming for the "Inside
SQL Server 2005" series, but I haven't seen a formal announcement yet.
Amazon has several other volumes in this series available for pre-order.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
> and what book would be a good book, Geoff?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
>
|||thanks Geoff
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23rccjA4UGHA.4792@.TK2MSFTNGP14.phx.gbl...
> Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
> Reporting Services" by Peter BlackBurn and William Vaughn, I will have to
> go with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
> written against the beta release which was very close to the production
> version, and is geared towards the beginning Reporting Services user. I
> think there is a BI/Reporting Services volume forthcoming for the "Inside
> SQL Server 2005" series, but I haven't seen a formal announcement yet.
> Amazon has several other volumes in this series available for pre-order.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
>
Thursday, February 16, 2012
Can Reporting Services use IIS on another server?
installation prerequisite). Well, I really don't want to put IIS on a
production SQL Server. I like IIS, but it certainly exposes a lot more
potential security holes on the server because any website hosting product
is always a security risk to that machine. Besides, my SQL Server is not
exposed to the internet like my web servers, so I don't quite get why I
would even want IIS on the SQL Server.
I want to use Reporting Services, though. Can I somehow use Reporting
Services against IIS on another server? I'm not describing it well because
I've never used Reporting Services and I don't know if it, too, would be on
the other server, or what. Can someone guide me as to my options here, and
what to install where to keep the SQL Server machine more secure and stable
but still have Reporting Services capabilities? Thank you.Yes. You can install Reporting Services on an application (web) server
apart from your SQL database server. In fact, this is a very common
installation technique. Install and configure IIS on the desired server. I
strongly recommend having a certificate on that server. You can then
install Reporting Services 2005 on that server. Once it is installed, you
can configure it to use your production SQL server for its back-end
databases using the Reporting Services Configuration tool.
I have two suggestions for getting started. One, build a throwaway test
server to do your first testing and deployment on. Second, purchase a good
book on Reporting Services. Both will save you a lot of headaches.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
> Reporting Services on SQL 2005 says that I must install IIS (its an
> installation prerequisite). Well, I really don't want to put IIS on a
> production SQL Server. I like IIS, but it certainly exposes a lot more
> potential security holes on the server because any website hosting product
> is always a security risk to that machine. Besides, my SQL Server is not
> exposed to the internet like my web servers, so I don't quite get why I
> would even want IIS on the SQL Server.
> I want to use Reporting Services, though. Can I somehow use Reporting
> Services against IIS on another server? I'm not describing it well
> because
> I've never used Reporting Services and I don't know if it, too, would be
> on
> the other server, or what. Can someone guide me as to my options here,
> and
> what to install where to keep the SQL Server machine more secure and
> stable
> but still have Reporting Services capabilities? Thank you.
>|||and what book would be a good book, Geoff?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
> Yes. You can install Reporting Services on an application (web) server
> apart from your SQL database server. In fact, this is a very common
> installation technique. Install and configure IIS on the desired server.
> I strongly recommend having a certificate on that server. You can then
> install Reporting Services 2005 on that server. Once it is installed, you
> can configure it to use your production SQL server for its back-end
> databases using the Reporting Services Configuration tool.
> I have two suggestions for getting started. One, build a throwaway test
> server to do your first testing and deployment on. Second, purchase a
> good book on Reporting Services. Both will save you a lot of headaches.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
>> Reporting Services on SQL 2005 says that I must install IIS (its an
>> installation prerequisite). Well, I really don't want to put IIS on a
>> production SQL Server. I like IIS, but it certainly exposes a lot more
>> potential security holes on the server because any website hosting
>> product
>> is always a security risk to that machine. Besides, my SQL Server is
>> not
>> exposed to the internet like my web servers, so I don't quite get why I
>> would even want IIS on the SQL Server.
>> I want to use Reporting Services, though. Can I somehow use Reporting
>> Services against IIS on another server? I'm not describing it well
>> because
>> I've never used Reporting Services and I don't know if it, too, would be
>> on
>> the other server, or what. Can someone guide me as to my options here,
>> and
>> what to install where to keep the SQL Server machine more secure and
>> stable
>> but still have Reporting Services capabilities? Thank you.
>>
>|||Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
Reporting Services" by Peter BlackBurn and William Vaughn, I will have to go
with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
written against the beta release which was very close to the production
version, and is geared towards the beginning Reporting Services user. I
think there is a BI/Reporting Services volume forthcoming for the "Inside
SQL Server 2005" series, but I haven't seen a formal announcement yet.
Amazon has several other volumes in this series available for pre-order.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
> and what book would be a good book, Geoff?
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
>> Yes. You can install Reporting Services on an application (web) server
>> apart from your SQL database server. In fact, this is a very common
>> installation technique. Install and configure IIS on the desired server.
>> I strongly recommend having a certificate on that server. You can then
>> install Reporting Services 2005 on that server. Once it is installed,
>> you can configure it to use your production SQL server for its back-end
>> databases using the Reporting Services Configuration tool.
>> I have two suggestions for getting started. One, build a throwaway test
>> server to do your first testing and deployment on. Second, purchase a
>> good book on Reporting Services. Both will save you a lot of headaches.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
>> Reporting Services on SQL 2005 says that I must install IIS (its an
>> installation prerequisite). Well, I really don't want to put IIS on a
>> production SQL Server. I like IIS, but it certainly exposes a lot more
>> potential security holes on the server because any website hosting
>> product
>> is always a security risk to that machine. Besides, my SQL Server is
>> not
>> exposed to the internet like my web servers, so I don't quite get why I
>> would even want IIS on the SQL Server.
>> I want to use Reporting Services, though. Can I somehow use Reporting
>> Services against IIS on another server? I'm not describing it well
>> because
>> I've never used Reporting Services and I don't know if it, too, would be
>> on
>> the other server, or what. Can someone guide me as to my options here,
>> and
>> what to install where to keep the SQL Server machine more secure and
>> stable
>> but still have Reporting Services capabilities? Thank you.
>>
>>
>|||thanks Geoff
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23rccjA4UGHA.4792@.TK2MSFTNGP14.phx.gbl...
> Since I haven't seen an update to "Hitchhikers Guide to SQL Server 2000
> Reporting Services" by Peter BlackBurn and William Vaughn, I will have to
> go with "Microsoft SQL 2005 Reporting Services" by Brian Larson. It was
> written against the beta release which was very close to the production
> version, and is geared towards the beginning Reporting Services user. I
> think there is a BI/Reporting Services volume forthcoming for the "Inside
> SQL Server 2005" series, but I haven't seen a formal announcement yet.
> Amazon has several other volumes in this series available for pre-order.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Alex" <me@.isp.net> wrote in message news:fDDWf.8879$Ph4.1246@.edtnps90...
>> and what book would be a good book, Geoff?
>> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>> news:ekzZm91UGHA.5660@.TK2MSFTNGP12.phx.gbl...
>> Yes. You can install Reporting Services on an application (web) server
>> apart from your SQL database server. In fact, this is a very common
>> installation technique. Install and configure IIS on the desired
>> server. I strongly recommend having a certificate on that server. You
>> can then install Reporting Services 2005 on that server. Once it is
>> installed, you can configure it to use your production SQL server for
>> its back-end databases using the Reporting Services Configuration tool.
>> I have two suggestions for getting started. One, build a throwaway test
>> server to do your first testing and deployment on. Second, purchase a
>> good book on Reporting Services. Both will save you a lot of headaches.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:RIzWf.19201$%d.2027@.tornado.socal.rr.com...
>> Reporting Services on SQL 2005 says that I must install IIS (its an
>> installation prerequisite). Well, I really don't want to put IIS on a
>> production SQL Server. I like IIS, but it certainly exposes a lot more
>> potential security holes on the server because any website hosting
>> product
>> is always a security risk to that machine. Besides, my SQL Server is
>> not
>> exposed to the internet like my web servers, so I don't quite get why I
>> would even want IIS on the SQL Server.
>> I want to use Reporting Services, though. Can I somehow use Reporting
>> Services against IIS on another server? I'm not describing it well
>> because
>> I've never used Reporting Services and I don't know if it, too, would
>> be on
>> the other server, or what. Can someone guide me as to my options here,
>> and
>> what to install where to keep the SQL Server machine more secure and
>> stable
>> but still have Reporting Services capabilities? Thank you.
>>
>>
>>
>