Install reporting services (not DB) on 2003 Web Edition?

I am looking to deploy reporting services on two serves, one already running
SQL2000 plus an exisitng IIS Server.
The IIS server is running Windows 2003 Web Edition - is installing the
non-DB components of this edition of windows supported - cannot find the
into in the deployment guide!
Any thanks much appreciated.
Ian.Yes.
--
| From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
| Subject: Install reporting services (not DB) on 2003 Web Edition?
| Date: Thu, 28 Jul 2005 16:06:47 +0100
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 217.206.61.36
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am looking to deploy reporting services on two serves, one already
running
| SQL2000 plus an exisitng IIS Server.
|
| The IIS server is running Windows 2003 Web Edition - is installing the
| non-DB components of this edition of windows supported - cannot find the
| into in the deployment guide!
|
| Any thanks much appreciated.
|
| Ian.
|
|
||||http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
This article talks about deployment scenarios.
HTH,
""Brad Syputa - MS"" wrote:
> Yes.
> --
> | From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
> | Subject: Install reporting services (not DB) on 2003 Web Edition?
> | Date: Thu, 28 Jul 2005 16:06:47 +0100
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 217.206.61.36
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I am looking to deploy reporting services on two serves, one already
> running
> | SQL2000 plus an exisitng IIS Server.
> |
> | The IIS server is running Windows 2003 Web Edition - is installing the
> | non-DB components of this edition of windows supported - cannot find the
> | into in the deployment guide!
> |
> | Any thanks much appreciated.
> |
> | Ian.
> |
> |
> |
>

Install both SQL7 and SQL8 on same server

Hello all,

Is there any special procedure to install a SQL7 (plus sp3) and a SQL8 server on a Windows 2000 Server.

I did succed installing both of them, but all of my applications are behaving strangely ()error msg ect)...So I may supose that there some kind of predefined process to have those kind of installation working properly..?

Any idea would be welcomed !

Thanks a lot in advance,

Regards,

Benj.how did you do it? there should'nt be any problems if you used named instances. If however you did'nt used named instances and you installed SQL 2K on top of SQL7, yes you can have a number of problems. off the top of my head I think there is an issue with programmers that used qoutes in their stored procedures.|||Just two standard installs...nothing really complex.

Yes, I did use instances for SQL8:

MYSERVER => for accessing SQL7 DB

MYSERVER\APLTEST => for accessing SQL8 DB

But year I tried to trace from both side (profiler and ODBC trace log), and did find some weird error messages:

DIAG [S0002] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'ScalaDBProperties'. (208)...

And basically my application crashes after trying to do this command (checking if the table exists):

SELECT NULL FROM SY050000 WHERE 1 = 2

Here it dies...

Ghost

But what's the best is that this table exist, I can querry it without any issue.. Also tried to do a connection from another server with MS Access..just in case...It also worked fine..

Also last point I tried to recreate a user for this DB by deleting the main software user called Scala and recreating it.. Nothing worked..

I'm really lost here, so if anyone would have a hint..I would be very happy !

Thanks again,

Benj.|||Am I missing something here? Your query does not seem to make any sense.

It seems you are returning the value null when the number 1 = number 2 which is a mathmatical impossibility.

1 is not a column name. I seem to remember that column names can not start with numbers.

Am I wrong?|||Erf... that's the SQL statement the program we have issue.

From what I was thinking, the program is just trying to check if the table SY050000 exists but I'm not certain of it and since my knowledge of SQL is pretty limited (just trying to debug the thingy) I cannot assure you that this command syntax is actually right..

But I tried from a querry analyzer and it doesn't give me any error and it returns me :

(No column Name)

If I try the same command on a table that doesn't exists I have this erro message:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'SY05000'.

Would there be any tests to do from a SQL point of view, on the SY050000 table to check if everything is alright ? Is there anything else I could try to test my SQL install or my ODBC connection please ?

In any case thanks for trying to help :) that's much apreciated :D

insisting on a password policy for sql

Is it possible to force users with sql accounts to use secure passwords say
6 plus characters long with numbers and letters. Is it also possible to have
sql insist that the passwords be changed every X days.
I am of course talking about when sql server 2000 uses sql authentication.
Please advise
AndreHi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||The short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre