Install RS 2000 with SQL 2005

Hello,
i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
this possible? Any problems?
THX
Andre ScheiberleBooks On LIne says that this functionality will be added to SQL Express soon
( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
for it...I don't think you'll get Report Builder however
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Andre Scheiberle" wrote:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> this possible? Any problems?
> THX
> Andre Scheiberle
>|||"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express
> Edition. Is this possible? Any problems?
> THX
> Andre Scheiberle
>
WHY'?|||Maybe because no license needs to be paid?
Jan D''Hondt
Jade bvba
Belgium
Database and .NET development
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
"Asher_N" wrote:
> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> <AndreScheiberle@.discussions.microsoft.com> wrote in
> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express
> > Edition. Is this possible? Any problems?
> > THX
> > Andre Scheiberle
> >
> WHY'?
>|||You need a SQL 2000 license to install RS2000.
"=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> Maybe because no license needs to be paid?
>
> --
> Jan D''Hondt
> Jade bvba
> Belgium
> Database and .NET development
> <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>
>
> "Asher_N" wrote:
>> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> > Hello,
>> > i want to install Reporting Services 2000 with SQL 2005 Express
>> > Edition. Is this possible? Any problems?
>> > THX
>> > Andre Scheiberle
>> >
>> WHY'?
>|||Do you know a date when this functionality will be a added?
The installation and configuration works (tricky), but now I have a
Web-Application developed in .Net 2.0. Is it possible to configure RS 2000 to
run with .Net 2.0?
THX
Andre Scheiberle
"Wayne Snyder" wrote:
> Books On LIne says that this functionality will be added to SQL Express soon
> ( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
> for it...I don't think you'll get Report Builder however
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Andre Scheiberle" wrote:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> > this possible? Any problems?
> > THX
> > Andre Scheiberle
> >|||We have a free SQL 2000 license and can use that. The installation with SQL
Express works (tricky) but now I have a Web-Application developed in .Net
2.0. Is there a way to configure RS 2000 to run with .Net 2.0?
THX
Andre Scheiberle
"Asher_N" wrote:
> You need a SQL 2000 license to install RS2000.
>
> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
> in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> > Maybe because no license needs to be paid?
> >
> >
> > --
> > Jan D''Hondt
> > Jade bvba
> > Belgium
> > Database and .NET development
> >
> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
> >
> >
> >
> >
> > "Asher_N" wrote:
> >
> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> >>
> >> > Hello,
> >> > i want to install Reporting Services 2000 with SQL 2005 Express
> >> > Edition. Is this possible? Any problems?
> >> > THX
> >> > Andre Scheiberle
> >> >
> >>
> >> WHY'?
> >>
> >
> >
>|||I don'r believe it is possible.
"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:67FB0B63-622B-4791-969C-E1F9117526C1@.microsoft.com:
> We have a free SQL 2000 license and can use that. The installation
> with SQL Express works (tricky) but now I have a Web-Application
> developed in .Net 2.0. Is there a way to configure RS 2000 to run with
> .Net 2.0?
> THX
> Andre Scheiberle
> "Asher_N" wrote:
>> You need a SQL 2000 license to install RS2000.
>>
>> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com>
>> wrote in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
>> > Maybe because no license needs to be paid?
>> >
>> >
>> > --
>> > Jan D''Hondt
>> > Jade bvba
>> > Belgium
>> > Database and .NET development
>> >
>> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>> >
>> >
>> >
>> >
>> > "Asher_N" wrote:
>> >
>> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> >>
>> >> > Hello,
>> >> > i want to install Reporting Services 2000 with SQL 2005 Express
>> >> > Edition. Is this possible? Any problems?
>> >> > THX
>> >> > Andre Scheiberle
>> >> >
>> >>
>> >> WHY'?
>> >>
>> >
>> >
>>
>|||You will not be able to make RS2000 run under .NET 2.0, however you can
run .NET 2.0 websites side-by-side with .NET 1.1 or 1.0 websites
without any problem. To do this, you can use the "aspnet_regiis.exe"
utility to switch the sites to the correct .NET version of ASP.NET.
For example, if you have both v1.1 and v2.0 installed on your server,
but all websites are setup as v2.0 (since its installation updates the
ASP.NET settings)
You could do the following to reset the SRS websites to the v1.1
version of ASP.NET:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/ReportServer
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/Reports
I hope this helps,
Lance Hunt
http://www.lance-hunt.net/

insisting on a password policy for sql

Hi
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
> AndreThe 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|||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|||Hi
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