download location

We own SQL 2000 Std server license.
We'd like to get access to Reporting Services for SQL2k. Where can I
download? (all i can find is the download to the trial)Did you get any response on this
I'm in the same boat, I can find the Service Packs, but I can't find the
base software.
Any direction will be much appreciated.
"john doe" wrote:
> We own SQL 2000 Std server license.
> We'd like to get access to Reporting Services for SQL2k. Where can I
> download? (all i can find is the download to the trial)
>
>

Downgrade SQL2K Enterprise to SQL2K Standard

Is it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.

No. Downgrading from SQL Enterprise edition to Standard edition is not supported.

But if you also have licsense and media of SQL Standard edition and your machine has enough resources such as free disk space, you can install SQL Standard edition side by side with Enterprise Edition, which is supported. Then you can transfer data from Enterprise edition to Standard edition. At the end, you can uninstall Enterprise edition if necessary.

sql

downgrade SQL2005 to SQL2k - Unicode ANSI issue

Hello,

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
?ffnendes Anführungszeichen vor der Zeichenfolge '????
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'????

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

thanks
candide_sh(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)
>
Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
><blabla>'
>
In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??
>
In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

"Database publishing wizard" I will have to admit that this tool is unknown
to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?

In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

--
candide_sh

On 26 Jan., 14:36, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

>

Quote:

Originally Posted by

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
<blabla>'

>

Quote:

Originally Posted by

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??

>

Quote:

Originally Posted by

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?"Database publishing wizard" I will have to admit that this tool isunknown

to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?
>
In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Zitierten Text ausblenden -- Zitierten Text anzeigen -

|||(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.
>
Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

I downloaded the DB Publish Wizard, and it does indeed generate a Unicode
file. I had created this table on SQL 2005:

CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))

and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.

Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)

What is in that extended property on SQL 2005?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hello Erland

the GUID-value was created by the upsizing wizard of MS-Access2003 and
I really don't know what for it is. But the conservative way is to not
touch the values created by this wizard. As the script generated by DB
Pub wizard crashed at only this one GUID-value (others worked fine) I
commented this line out and manually copy/pasted this value. Well
done...

On 26 Jan., 23:42, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

>

Quote:

Originally Posted by

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.I downloaded the DB Publish Wizard, and it doesindeed generate a Unicode

file. I had created this table on SQL 2005:
>
CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))
>
and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.
>
Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)
>
What is in that extended property on SQL 2005?
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Domain Change for W2K/SQL2k

I am looking for information/procedures for changing the domain for an
existing W2K/SQL2K cluster. The cluster currently is a part of an NT4.0
domain and will be migrating to a W2K AD domain. This seems like it should
be a simple change but I can't seem to find any info or anyone who has done
this. Any assistance/lessons learned would be greatly appreciated. The
process I think should work is below:
1. Move all cluster resources to a node A and stop cluster services on node
B.
2. Stop cluster services on node A
3. Join node A to the W2K AD domain
4. Change the account used for cluster services on node A to be the cluster
account in the new AD domain.
5. Change the account used for SQL services on node A to be the SQL account
in the new AD domain.
6. Start cluster services on node A and bring the cluster back online.
7. Join node B to the W2K AD domain.
8. Change the account used for cluster services on node B to be the cluster
account in the new AD domain.
9. Change the account used for SQL services on node B to be the SQL account
in the new AD domain.
10. Move the node B resources back to node B and test applications.
Jeff Teall
Dude are you in luck.
Changing Domains for a SQL Server 2000 Failover Cluster
http://www.sqljunkies.com/HowTo/14E7...BAB3F0254.scuk
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Teall" <jteall57@.yahoo.com> wrote in message
news:uu%23Lx3NaEHA.1840@.TK2MSFTNGP11.phx.gbl...
> I am looking for information/procedures for changing the domain for an
> existing W2K/SQL2K cluster. The cluster currently is a part of an NT4.0
> domain and will be migrating to a W2K AD domain. This seems like it
should
> be a simple change but I can't seem to find any info or anyone who has
done
> this. Any assistance/lessons learned would be greatly appreciated. The
> process I think should work is below:
> 1. Move all cluster resources to a node A and stop cluster services on
node
> B.
> 2. Stop cluster services on node A
> 3. Join node A to the W2K AD domain
> 4. Change the account used for cluster services on node A to be the
cluster
> account in the new AD domain.
> 5. Change the account used for SQL services on node A to be the SQL
account
> in the new AD domain.
> 6. Start cluster services on node A and bring the cluster back online.
> 7. Join node B to the W2K AD domain.
> 8. Change the account used for cluster services on node B to be the
cluster
> account in the new AD domain.
> 9. Change the account used for SQL services on node B to be the SQL
account
> in the new AD domain.
> 10. Move the node B resources back to node B and test applications.
> Jeff Teall
>

Doing demos with SQL2K RS Developer

Hi there.
I need to know if there's a proper setup to have SQL 2k Developer Edition
and SQL 2k RS Developer Edition on top of Win XP Pro to demo some reports.
I have locally installed VS .Net 2003 professional, SQL 2K Developer, SQL 2K
RS Developer, SQL 2K AS and IIS on top of Windows XP and RS does not ran if
I'm not connected to corporate network.
I have no way to make RS work on the road or at customers networks to show
some nice reports we have built...
I even installed SQL 2K RS Sp1 and it has no effect
Do I need to format my notebook and Install Win 2000?
Is it a setup problem?
Is it a licensing restriction?
Thank you very much for your support
Michael PrendergastSearch this newsgroup for "loopback":
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=loopback&qt_g=1&searchnow=Search+this+group
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MPS" <mps@.udd.cl> wrote in message
news:u$M4kf29EHA.2996@.TK2MSFTNGP10.phx.gbl...
> Hi there.
> I need to know if there's a proper setup to have SQL 2k Developer Edition
> and SQL 2k RS Developer Edition on top of Win XP Pro to demo some reports.
> I have locally installed VS .Net 2003 professional, SQL 2K Developer, SQL
> 2K RS Developer, SQL 2K AS and IIS on top of Windows XP and RS does not
> ran if I'm not connected to corporate network.
> I have no way to make RS work on the road or at customers networks to show
> some nice reports we have built...
> I even installed SQL 2K RS Sp1 and it has no effect
> Do I need to format my notebook and Install Win 2000?
> Is it a setup problem?
> Is it a licensing restriction?
> Thank you very much for your support
> Michael Prendergast
>