Hi there
I am working in CR 9.0 and have included subreports in the main report.
Whenever I run the main report and have to give the Login ID & password for the " HiT ODBC / 400 Driver" (DataSource - AS400) I get the following warning/error.
"Failed to open a rowset.
Details: HY000:{HiT][HiT ODBC/400][SQL/400][ODBS Error][SQL0128] Use of NULL is not valid"
If I click the OK button the report is generated.
If I run the same report the second/third time - where I do not have to specify the Login ID & password the error/warning does not occur.
How do I get rid of this warning/error msg.
rkpYou need to pass them in the Front End coding
Showing posts with label warning. Show all posts
Showing posts with label warning. Show all posts
Thursday, March 29, 2012
Friday, March 9, 2012
Fail to install RS 2k on windows 2k3 with IIS configuration error
***Environment:
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.
Subscribe to:
Posts (Atom)