help!...sp1 or sp2

After I install SP1 of SP2 for reporting services, I get the following
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,

Help! SQL Service Manager is not connected

After completing a successful installing of MSDE build 2000.80.760.0
on my Windows XP Version 5.1.2600 Service Pack 1 Build 2600 I am
encountering the following issue:
The SQL Service Manager Tray icon indicator is in solid white state and when I
mouse over, it displays "Not Connected = \\".
Attempting to double click the guy results with both the Server and the
Service textboxes being empty. Same when I collapse their drop down
menus, they do not list any database instances. Refresh does not
solve the problem either.
I get the following error in the event log:
Event Type:Warning
Event Source:MSSQL$VSDOTNET
Event Category:(8)
Event ID:19011
Date:4/13/2004
Time:10:59:05 AM
User:N/A
Computer:TOOTI
Description:
The description for Event ID ( 19011 ) in Source ( MSSQL$VSDOTNET
) cannot be found. The local computer may not have the necessary
registry information or message DLL files to display messages from a
remote computer. You may be able to use the /AUXSOURCE= flag to
retrieve this description; see Help and Support for details. The
following information is part of the event: (SpnRegister) : Error 1231.
Some notes:
* I have installed MSDE using the following command-line:
setup INSTANCENAME=VSDOTNET SAPWD=<my password>
* My system has Office 2003 Pro and Visual Studio 2003.net
* I removed Business Contact Manager and attempted to install MSDE
once again, however the issue remains.
* I am running file and print sharing on my internal (disconnected) nic
adapter
My configuration is:
OS NameMicrosoft Windows XP Professional
Version5.1.2600 Service Pack 1 Build 2600
OS ManufacturerMicrosoft Corporation
System ManufacturerAcer
System ModelTravelMate 800
System TypeX86-based PC
Processorx86 Family 6 Model 9 Stepping 5 GenuineIntel
~1598 Mhz
BIOS Version/DateACER 4A14, 9/19/2003
SMBIOS Version2.31
Windows DirectoryC:\WINDOWS
System DirectoryC:\WINDOWS\System32
Boot Device\Device\HarddiskVolume1
LocaleUnited States
Hardware Abstraction LayerVersion = "5.1.2600.1106
(xpsp1.020828-1920)"
Total Physical Memory512.00 MB
Available Physical Memory265.73 MB
Total Virtual Memory1.72 GB
Available Virtual Memory1.27 GB
Page File Space1.22 GB
Page FileC:\pagefile.sys
LOG\ERROR.LOG:
2004-04-13 10:59:01.71 server Microsoft SQL Server 2000 -
8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service
Pack 1)
2004-04-13 10:59:01.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-04-13 10:59:01.76 server All rights reserved.
2004-04-13 10:59:01.76 server Server Process ID is 652.
2004-04-13 10:59:01.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL$VSDOTNET\LOG\ERRORLOG'.
2004-04-13 10:59:01.89 server SQL Server is starting at priority
class 'normal'(1 CPU detected).
2004-04-13 10:59:03.67 server SQL Server configured for thread
mode processing.
2004-04-13 10:59:03.83 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2004-04-13 10:59:04.77 spid3 Starting up database 'master'.
2004-04-13 10:59:05.51 server Using 'SSNETLIB.DLL' version
'8.0.766'.
2004-04-13 10:59:05.51 spid5 Starting up database 'model'.
2004-04-13 10:59:05.75 spid3 Server name is 'TOOTI\VSDOTNET'.
2004-04-13 10:59:05.75 spid3 Skipping startup of clean database id
4
2004-04-13 10:59:05.90 server SQL server listening on Shared
Memory.
2004-04-13 10:59:05.92 server SQL Server is ready for client
connections
2004-04-13 10:59:07.20 spid5 Clearing tempdb database.
2004-04-13 10:59:12.75 spid5 Starting up database 'tempdb'.
2004-04-13 10:59:13.44 spid3 Recovery complete.
2004-04-13 10:59:13.44 spid3 SQL global counter collection task is
created.
I thank anyone in advance for a quick response.
-Itai
hi Itai,
"Itai" <itaindia2002@.yahoo.com> ha scritto nel messaggio
news:ab661ff4.0404130215.18d18b5c@.posting.google.c om...
> After completing a successful installing of MSDE build 2000.80.760.0
> on my Windows XP Version 5.1.2600 Service Pack 1 Build 2600 I am
> encountering the following issue:
> The SQL Service Manager Tray icon indicator is in solid white state and
when I
> mouse over, it displays "Not Connected = \\".
> Attempting to double click the guy results with both the Server and the
> Service textboxes being empty. Same when I collapse their drop down
> menus, they do not list any database instances. Refresh does not
> solve the problem either.
> I get the following error in the event log:
sometimes the service manager fails to load the combo with the available SQL
Server instances when they are installed with disabled network protocols,
due to ODBC related "features" at this regard... but your logs seems to
show your instance is running... try typing the server instance name in the
combobox like YourComputerName\VSDOTNET ...
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

HELP! Err whn changing Stored Proc used

We had to make a change to a stored procedure and wanted to test out the
change. So made a test version of the sp (all done correctly and verified by
dba). I changed the name of the stored proc used in my report to be the test
version. I could run the sp fine from the data tab and it picked up the
change and displayed the correct results. When I wanted to run it from the
Preview tab ... different story. I tried EVERYTHING and couldnt get it to
not throw an error (SQL0444N Routine "*S_UPTIME" (specification name
"SQL050707202207020") is implemented with code in library or path"
...RES_UPTIME", function "DANTEST.SP_RPT_RES_UPTIME" which cannot be
accessed. Reason code: "4". SQLSTATE=42724. Permissions on the sp are
correct, grant was run, everything is correct from DBA standpoint. IN FACT
... if I create a NEW report and use that stored proc then I dont get an
error. SO ... where to look for the problem. I need to use the new stored
procedure in an existing report and I CANNOT REWRITE that just to use a new
stored procedure. Something is being remembered in the project I need to
make the change in and I dont know where to look. Thanks for any help.I had an issue similar to this and it seems to be that even though you can
run the dataset on the data tab after changing the stored procedure using
the ! it doesn't update the field list. If you look in the config for the
dataset after running it you still see the field list from the old SP, I
tried using the refresh fields button, rerunning the new SP several times
but the field list wouldn't update.
As a work around I just nuked the dataset and recreated a new one with the
same name and the new SP and then the new field list was available.
Hope this helps.
Peace,
Dan
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:63BCFB5C-8196-4622-8D3F-5A336CE07A96@.microsoft.com...
> We had to make a change to a stored procedure and wanted to test out the
> change. So made a test version of the sp (all done correctly and verified
> by
> dba). I changed the name of the stored proc used in my report to be the
> test
> version. I could run the sp fine from the data tab and it picked up the
> change and displayed the correct results. When I wanted to run it from
> the
> Preview tab ... different story. I tried EVERYTHING and couldnt get it to
> not throw an error (SQL0444N Routine "*S_UPTIME" (specification name
> "SQL050707202207020") is implemented with code in library or path"
> ...RES_UPTIME", function "DANTEST.SP_RPT_RES_UPTIME" which cannot be
> accessed. Reason code: "4". SQLSTATE=42724. Permissions on the sp are
> correct, grant was run, everything is correct from DBA standpoint. IN
> FACT
> ... if I create a NEW report and use that stored proc then I dont get an
> error. SO ... where to look for the problem. I need to use the new
> stored
> procedure in an existing report and I CANNOT REWRITE that just to use a
> new
> stored procedure. Something is being remembered in the project I need to
> make the change in and I dont know where to look. Thanks for any help.|||Dan,
I have had that issue before and dealt with it as you mention here. This
issue is different. It doesnt have to do with the fields list as the fields
as there - that isnt the problem. I dont understand the different behavior
between running the stored proc using the ! and running the report against it
using the preview. The report didnt change from before ...just the stored
proc ... shouldnt be such a problem!
"Dan Christjohn" wrote:
> I had an issue similar to this and it seems to be that even though you can
> run the dataset on the data tab after changing the stored procedure using
> the ! it doesn't update the field list. If you look in the config for the
> dataset after running it you still see the field list from the old SP, I
> tried using the refresh fields button, rerunning the new SP several times
> but the field list wouldn't update.
> As a work around I just nuked the dataset and recreated a new one with the
> same name and the new SP and then the new field list was available.
> Hope this helps.
> Peace,
> Dan
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:63BCFB5C-8196-4622-8D3F-5A336CE07A96@.microsoft.com...
> > We had to make a change to a stored procedure and wanted to test out the
> > change. So made a test version of the sp (all done correctly and verified
> > by
> > dba). I changed the name of the stored proc used in my report to be the
> > test
> > version. I could run the sp fine from the data tab and it picked up the
> > change and displayed the correct results. When I wanted to run it from
> > the
> > Preview tab ... different story. I tried EVERYTHING and couldnt get it to
> > not throw an error (SQL0444N Routine "*S_UPTIME" (specification name
> > "SQL050707202207020") is implemented with code in library or path"
> > ...RES_UPTIME", function "DANTEST.SP_RPT_RES_UPTIME" which cannot be
> > accessed. Reason code: "4". SQLSTATE=42724. Permissions on the sp are
> > correct, grant was run, everything is correct from DBA standpoint. IN
> > FACT
> > ... if I create a NEW report and use that stored proc then I dont get an
> > error. SO ... where to look for the problem. I need to use the new
> > stored
> > procedure in an existing report and I CANNOT REWRITE that just to use a
> > new
> > stored procedure. Something is being remembered in the project I need to
> > make the change in and I dont know where to look. Thanks for any help.
>
>

HELP! Custom authentication WITHOUT a login

Am I missing something when setting up Custom Authentication? We are testing
with the Enterprise version but only in development. We'd LOVE to do it with
the Standard Version so we don't have to buy Enterprise just for web apps.
Bascially, I don't want to require users to login to the report server AFTER
they've already logged in to our web application. I built the custom
authentication sample and had it working fine but when I try and use
logonUser to force credentials in, it still redirect to the login.aspx for
the reportserver.
Also, I don't want to use the SOAP API because our reports need to have a
toolbar
Is it possible to use Custom Forms Authentication with an internet app where
my reportserver is BEHIND the firewall and NOT require the user to log in
directly to the web server' Or is it as simple as moving the Report Server
up onto the exposed IIS server?
Any guidance or sample code would be much appreciated.I am in a very similar situation. If you did find any solution or code
snippet to help you out of this, can you please post it here ? It will be a
great help.
DC
"bteclt" <bteclt@.discussions.microsoft.com> wrote in message
news:3C03F1FF-392E-41DB-856B-1B46969D0CB0@.microsoft.com...
> Am I missing something when setting up Custom Authentication? We are
testing
> with the Enterprise version but only in development. We'd LOVE to do it
with
> the Standard Version so we don't have to buy Enterprise just for web apps.
> Bascially, I don't want to require users to login to the report server
AFTER
> they've already logged in to our web application. I built the custom
> authentication sample and had it working fine but when I try and use
> logonUser to force credentials in, it still redirect to the login.aspx for
> the reportserver.
> Also, I don't want to use the SOAP API because our reports need to have a
> toolbar
> Is it possible to use Custom Forms Authentication with an internet app
where
> my reportserver is BEHIND the firewall and NOT require the user to log in
> directly to the web server' Or is it as simple as moving the Report
Server
> up onto the exposed IIS server?
> Any guidance or sample code would be much appreciated.
>|||DC,
I can tell you this...I've spent days now reading the various forums and
have not found any luck with this. It appears most users are happy with the
SOAP API and reports without toolbars OR are trying to simply secure access
to the Report Manager via a login on the Web. I assume there are people that
want on-demand reports that render in a browser using the Viewer Control or
the Toolbar (and without a secondary login to the report server) but they
don't seem to want to respond to the forums. I've also seen a lot of
frustration from folks simply trying to implement the custom security. I
would have assume Microsoft would have been very interested in making
reporting via the Internet an easy task to implement but it appears they are
happy letting Crystal Reports keep a strong grip on the marketplace. Don't
get me wrong, they/we should be concerned about securing our apps but they
should also not make it required for us to be web developers, network admins
and security specialists and DBA's all at once...just seems like it gets to
the point where frustration wins out and staying with current reporting
solutions (we use Crystal) or searching for others is the best way out. I'll
post back to this forum anything else I find out though! I'd appreciate it
if you could do the same...maybe one of us can crack this
"DC" wrote:
> I am in a very similar situation. If you did find any solution or code
> snippet to help you out of this, can you please post it here ? It will be a
> great help.
> DC
>
> "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> news:3C03F1FF-392E-41DB-856B-1B46969D0CB0@.microsoft.com...
> > Am I missing something when setting up Custom Authentication? We are
> testing
> > with the Enterprise version but only in development. We'd LOVE to do it
> with
> > the Standard Version so we don't have to buy Enterprise just for web apps.
> >
> > Bascially, I don't want to require users to login to the report server
> AFTER
> > they've already logged in to our web application. I built the custom
> > authentication sample and had it working fine but when I try and use
> > logonUser to force credentials in, it still redirect to the login.aspx for
> > the reportserver.
> >
> > Also, I don't want to use the SOAP API because our reports need to have a
> > toolbar
> >
> > Is it possible to use Custom Forms Authentication with an internet app
> where
> > my reportserver is BEHIND the firewall and NOT require the user to log in
> > directly to the web server' Or is it as simple as moving the Report
> Server
> > up onto the exposed IIS server?
> >
> > Any guidance or sample code would be much appreciated.
> >
> >
>
>|||I am sorry about your frustration. This queston has been asked zillion times
in different flavors.
Let's leave RS aside. Your question boils down to:
"If I have two web applications (one Internet-facing and the other behind a
firewall) can a web user access the private web app? And the answer is no.
URL addressability (if this is what you want) relies on direct access to the
Report Server and your Report Server has to be Internet-facing as well. In
addition, since Forms Authentication is cookie-based, all cookie-related
restrictions apply, e.g. cross-domain cookies are not allowed so both apps
have to be on the same domain, when testing don't use localhost, etc.
As a side note, one of things developers including myself appreciate most
about RS is its extensible model. It allows you to extend/replace data,
security, delivery and rendering functionality. Try doing this with
Crystal...
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"bteclt" <bteclt@.discussions.microsoft.com> wrote in message
news:D26EE429-EAAF-44C2-9AA4-01F2B6206F39@.microsoft.com...
> DC,
> I can tell you this...I've spent days now reading the various forums and
> have not found any luck with this. It appears most users are happy with
the
> SOAP API and reports without toolbars OR are trying to simply secure
access
> to the Report Manager via a login on the Web. I assume there are people
that
> want on-demand reports that render in a browser using the Viewer Control
or
> the Toolbar (and without a secondary login to the report server) but they
> don't seem to want to respond to the forums. I've also seen a lot of
> frustration from folks simply trying to implement the custom security. I
> would have assume Microsoft would have been very interested in making
> reporting via the Internet an easy task to implement but it appears they
are
> happy letting Crystal Reports keep a strong grip on the marketplace.
Don't
> get me wrong, they/we should be concerned about securing our apps but they
> should also not make it required for us to be web developers, network
admins
> and security specialists and DBA's all at once...just seems like it gets
to
> the point where frustration wins out and staying with current reporting
> solutions (we use Crystal) or searching for others is the best way out.
I'll
> post back to this forum anything else I find out though! I'd appreciate
it
> if you could do the same...maybe one of us can crack this
>
> "DC" wrote:
> > I am in a very similar situation. If you did find any solution or code
> > snippet to help you out of this, can you please post it here ? It will
be a
> > great help.
> >
> > DC
> >
> >
> > "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> > news:3C03F1FF-392E-41DB-856B-1B46969D0CB0@.microsoft.com...
> > > Am I missing something when setting up Custom Authentication? We are
> > testing
> > > with the Enterprise version but only in development. We'd LOVE to do
it
> > with
> > > the Standard Version so we don't have to buy Enterprise just for web
apps.
> > >
> > > Bascially, I don't want to require users to login to the report server
> > AFTER
> > > they've already logged in to our web application. I built the custom
> > > authentication sample and had it working fine but when I try and use
> > > logonUser to force credentials in, it still redirect to the login.aspx
for
> > > the reportserver.
> > >
> > > Also, I don't want to use the SOAP API because our reports need to
have a
> > > toolbar
> > >
> > > Is it possible to use Custom Forms Authentication with an internet app
> > where
> > > my reportserver is BEHIND the firewall and NOT require the user to log
in
> > > directly to the web server' Or is it as simple as moving the Report
> > Server
> > > up onto the exposed IIS server?
> > >
> > > Any guidance or sample code would be much appreciated.
> > >
> > >
> >
> >
> >|||Teo,
Ok, if I follow your post here and my configuration is as follows:
a) SRS running on Default Web site in Production IIS envirnonment with
custom security dll set up as prescribed in the Microsoft Forms
Authentication Sample
b) Production web site (in this case on the exact same server as SRS) that
uses a Forms based authentication (ie. we have users table in MSSQL that is
checked with a login stored procedure based on click event from submit button
on web login page)
c) Production MSSQL DB is behind firewall and is connected through the web app
d) hyperlinks on the menu to individual SQL Reports
I want to run the SQL Reports in an on-demand format from the clicks on the
hyperlinks (in other words, click link, report opens with the toolbar on top
or preferably in the VIEWER control). Remember, I DON'T want to use the SOAP
API becuase I need the toolbars.
What's the best method to :
1) Instantiate the credentials into the report from the web app (I can hard
code these in the app based on the roles etc I set up in the user store from
the custom authentication sample)
2) Open the report without requiring a login to the report server (ie. login
automatically based on the credentials passed in step one). Specifically, I
HAVE TO have the toolbar on top or in a perfect world I'd like to use the
viewer
Any samples or links to examples would be GREAT!!! As an aside, we primarily
use vb.net in our code behinds so that is preferred but any solutions (C# or
VB) would save us in a big way. (And FYI - I have your book and have read
the section about doing this but it talks mostly about having users login to
the UIlogon.aspx and that's what I am trying to avoid...can this be done?)
Thanks in Advance!
BTE
"Teo Lachev [MVP]" wrote:
> I am sorry about your frustration. This queston has been asked zillion times
> in different flavors.
> Let's leave RS aside. Your question boils down to:
> "If I have two web applications (one Internet-facing and the other behind a
> firewall) can a web user access the private web app? And the answer is no.
> URL addressability (if this is what you want) relies on direct access to the
> Report Server and your Report Server has to be Internet-facing as well. In
> addition, since Forms Authentication is cookie-based, all cookie-related
> restrictions apply, e.g. cross-domain cookies are not allowed so both apps
> have to be on the same domain, when testing don't use localhost, etc.
> As a side note, one of things developers including myself appreciate most
> about RS is its extensible model. It allows you to extend/replace data,
> security, delivery and rendering functionality. Try doing this with
> Crystal...
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> news:D26EE429-EAAF-44C2-9AA4-01F2B6206F39@.microsoft.com...
> > DC,
> > I can tell you this...I've spent days now reading the various forums and
> > have not found any luck with this. It appears most users are happy with
> the
> > SOAP API and reports without toolbars OR are trying to simply secure
> access
> > to the Report Manager via a login on the Web. I assume there are people
> that
> > want on-demand reports that render in a browser using the Viewer Control
> or
> > the Toolbar (and without a secondary login to the report server) but they
> > don't seem to want to respond to the forums. I've also seen a lot of
> > frustration from folks simply trying to implement the custom security. I
> > would have assume Microsoft would have been very interested in making
> > reporting via the Internet an easy task to implement but it appears they
> are
> > happy letting Crystal Reports keep a strong grip on the marketplace.
> Don't
> > get me wrong, they/we should be concerned about securing our apps but they
> > should also not make it required for us to be web developers, network
> admins
> > and security specialists and DBA's all at once...just seems like it gets
> to
> > the point where frustration wins out and staying with current reporting
> > solutions (we use Crystal) or searching for others is the best way out.
> I'll
> > post back to this forum anything else I find out though! I'd appreciate
> it
> > if you could do the same...maybe one of us can crack this
> >
> >
> >
> > "DC" wrote:
> >
> > > I am in a very similar situation. If you did find any solution or code
> > > snippet to help you out of this, can you please post it here ? It will
> be a
> > > great help.
> > >
> > > DC
> > >
> > >
> > > "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> > > news:3C03F1FF-392E-41DB-856B-1B46969D0CB0@.microsoft.com...
> > > > Am I missing something when setting up Custom Authentication? We are
> > > testing
> > > > with the Enterprise version but only in development. We'd LOVE to do
> it
> > > with
> > > > the Standard Version so we don't have to buy Enterprise just for web
> apps.
> > > >
> > > > Bascially, I don't want to require users to login to the report server
> > > AFTER
> > > > they've already logged in to our web application. I built the custom
> > > > authentication sample and had it working fine but when I try and use
> > > > logonUser to force credentials in, it still redirect to the login.aspx
> for
> > > > the reportserver.
> > > >
> > > > Also, I don't want to use the SOAP API because our reports need to
> have a
> > > > toolbar
> > > >
> > > > Is it possible to use Custom Forms Authentication with an internet app
> > > where
> > > > my reportserver is BEHIND the firewall and NOT require the user to log
> in
> > > > directly to the web server' Or is it as simple as moving the Report
> > > Server
> > > > up onto the exposed IIS server?
> > > >
> > > > Any guidance or sample code would be much appreciated.
> > > >
> > > >
> > >
> > >
> > >
>
>|||Please find my comments inline.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"bteclt" <bteclt@.discussions.microsoft.com> wrote in message
news:92AF49BE-22E1-4C01-B177-F802D3D5193C@.microsoft.com...
> Teo,
> Ok, if I follow your post here and my configuration is as follows:
> a) SRS running on Default Web site in Production IIS envirnonment with
> custom security dll set up as prescribed in the Microsoft Forms
> Authentication Sample
> b) Production web site (in this case on the exact same server as SRS) that
> uses a Forms based authentication (ie. we have users table in MSSQL that
is
> checked with a login stored procedure based on click event from submit
button
> on web login page)
> c) Production MSSQL DB is behind firewall and is connected through the web
app
> d) hyperlinks on the menu to individual SQL Reports
> I want to run the SQL Reports in an on-demand format from the clicks on
the
> hyperlinks (in other words, click link, report opens with the toolbar on
top
> or preferably in the VIEWER control). Remember, I DON'T want to use the
SOAP
> API becuase I need the toolbars.
> What's the best method to :
> 1) Instantiate the credentials into the report from the web app (I can
hard
> code these in the app based on the roles etc I set up in the user store
from
> the custom authentication sample)
Teo: There is only one way. You can the RS LogonUser SOAP API and pass the
user credientials. LogonUser in turns calls
IAuthenticationExtension.LogonUser in your custom security extension.
> 2) Open the report without requiring a login to the report server (ie.
login
> automatically based on the credentials passed in step one). Specifically,
I
> HAVE TO have the toolbar on top or in a perfect world I'd like to use the
> viewer
>
Teo: Same as above. Once LogonUser is called and
IAuthenticationExtension.LogonUser returns true (user is authenticated), the
Report Server will proceed by issuing an authentication ticket in the form
of a cookie (just like ASP.NET Forms Authentication does). From there, as
long as the cookie is passed back, the Report Server will treat the user is
authenticated and won't prompt the user to log in again.
> Any samples or links to examples would be GREAT!!! As an aside, we
primarily
> use vb.net in our code behinds so that is preferred but any solutions (C#
or
> VB) would save us in a big way. (And FYI - I have your book and have read
> the section about doing this but it talks mostly about having users login
to
> the UIlogon.aspx and that's what I am trying to avoid...can this be done?)
>
Teo: Thanks for purchasing my book. I tend to disagree with you though.
Chapter 15 (15.4.1) explains how RS custom security can be integrated with a
web application similar to your scenario. It leverages the enchanced version
of the Report Viewer I wrote but the concept is the same. Remember,
UILogon.aspx is for the Report Manager, Logon.aspx is what the Report Server
uses to prompt the user, Login.aspx is the custom login page inside my
application.
I wrote a two-part article about Forms Authentication which goes into more
details than my book does including role-membership, troubleshooting, etc.
It will be published by SQL Server Magazine in the February and March 2005
issues I think. I hope my article will help demistifying RS custom security.
> Thanks in Advance!
> BTE
> "Teo Lachev [MVP]" wrote:
> > I am sorry about your frustration. This queston has been asked zillion
times
> > in different flavors.
> >
> > Let's leave RS aside. Your question boils down to:
> >
> > "If I have two web applications (one Internet-facing and the other
behind a
> > firewall) can a web user access the private web app? And the answer is
no.
> > URL addressability (if this is what you want) relies on direct access to
the
> > Report Server and your Report Server has to be Internet-facing as well.
In
> > addition, since Forms Authentication is cookie-based, all cookie-related
> > restrictions apply, e.g. cross-domain cookies are not allowed so both
apps
> > have to be on the same domain, when testing don't use localhost, etc.
> >
> > As a side note, one of things developers including myself appreciate
most
> > about RS is its extensible model. It allows you to extend/replace data,
> > security, delivery and rendering functionality. Try doing this with
> > Crystal...
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> > "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> > news:D26EE429-EAAF-44C2-9AA4-01F2B6206F39@.microsoft.com...
> > > DC,
> > > I can tell you this...I've spent days now reading the various forums
and
> > > have not found any luck with this. It appears most users are happy
with
> > the
> > > SOAP API and reports without toolbars OR are trying to simply secure
> > access
> > > to the Report Manager via a login on the Web. I assume there are
people
> > that
> > > want on-demand reports that render in a browser using the Viewer
Control
> > or
> > > the Toolbar (and without a secondary login to the report server) but
they
> > > don't seem to want to respond to the forums. I've also seen a lot of
> > > frustration from folks simply trying to implement the custom security.
I
> > > would have assume Microsoft would have been very interested in making
> > > reporting via the Internet an easy task to implement but it appears
they
> > are
> > > happy letting Crystal Reports keep a strong grip on the marketplace.
> > Don't
> > > get me wrong, they/we should be concerned about securing our apps but
they
> > > should also not make it required for us to be web developers, network
> > admins
> > > and security specialists and DBA's all at once...just seems like it
gets
> > to
> > > the point where frustration wins out and staying with current
reporting
> > > solutions (we use Crystal) or searching for others is the best way
out.
> > I'll
> > > post back to this forum anything else I find out though! I'd
appreciate
> > it
> > > if you could do the same...maybe one of us can crack this
> > >
> > >
> > >
> > > "DC" wrote:
> > >
> > > > I am in a very similar situation. If you did find any solution or
code
> > > > snippet to help you out of this, can you please post it here ? It
will
> > be a
> > > > great help.
> > > >
> > > > DC
> > > >
> > > >
> > > > "bteclt" <bteclt@.discussions.microsoft.com> wrote in message
> > > > news:3C03F1FF-392E-41DB-856B-1B46969D0CB0@.microsoft.com...
> > > > > Am I missing something when setting up Custom Authentication? We
are
> > > > testing
> > > > > with the Enterprise version but only in development. We'd LOVE to
do
> > it
> > > > with
> > > > > the Standard Version so we don't have to buy Enterprise just for
web
> > apps.
> > > > >
> > > > > Bascially, I don't want to require users to login to the report
server
> > > > AFTER
> > > > > they've already logged in to our web application. I built the
custom
> > > > > authentication sample and had it working fine but when I try and
use
> > > > > logonUser to force credentials in, it still redirect to the
login.aspx
> > for
> > > > > the reportserver.
> > > > >
> > > > > Also, I don't want to use the SOAP API because our reports need to
> > have a
> > > > > toolbar
> > > > >
> > > > > Is it possible to use Custom Forms Authentication with an internet
app
> > > > where
> > > > > my reportserver is BEHIND the firewall and NOT require the user to
log
> > in
> > > > > directly to the web server' Or is it as simple as moving the
Report
> > > > Server
> > > > > up onto the exposed IIS server?
> > > > >
> > > > > Any guidance or sample code would be much appreciated.
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Help! 120day Eval to Full version

Ok, several months ago we had an independant contractor install some
financial software on a server I provided. I gave the guy a fully licenced
version of SQL Server and let him do his work.
Unfortunately, it appears he didn't use my copy of SQL, he downloaded and
used the 120 day evaluation version of SQL which has now expired.
Does anyone know if I can simply uninstall the 120 day eval version of SQL,
install the Full version and the copy over the raw data and log files? I am
unable to do a normal backup and restore since the Eval services won't
start.
Please help!
http://support.microsoft.com/default...b;en-us;281574
Take a filesystem backup that includes the database files before you start.
David Portas
SQL Server MVP

Help! 120day Eval to Full version

Ok, several months ago we had an independant contractor install some
financial software on a server I provided. I gave the guy a fully licenced
version of SQL Server and let him do his work.
Unfortunately, it appears he didn't use my copy of SQL, he downloaded and
used the 120 day evaluation version of SQL which has now expired.
Does anyone know if I can simply uninstall the 120 day eval version of SQL,
install the Full version and the copy over the raw data and log files? I am
unable to do a normal backup and restore since the Eval services won't
start.
Please help!http://support.microsoft.com/default.aspx?scid=kb;en-us;281574
Take a filesystem backup that includes the database files before you start.
--
David Portas
SQL Server MVP
--

Help! 120day Eval to Full version

Ok, several months ago we had an independant contractor install some
financial software on a server I provided. I gave the guy a fully licenced
version of SQL Server and let him do his work.
Unfortunately, it appears he didn't use my copy of SQL, he downloaded and
used the 120 day evaluation version of SQL which has now expired.
Does anyone know if I can simply uninstall the 120 day eval version of SQL,
install the Full version and the copy over the raw data and log files? I am
unable to do a normal backup and restore since the Eval services won't
start.
Please help!http://support.microsoft.com/defaul...kb;en-us;281574
Take a filesystem backup that includes the database files before you start.
David Portas
SQL Server MVP
--

Help! - Subscriptions won't run; here is the LOG file

2007-05-18 11:07:07 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID
2007-05-18 11:07:07 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
unicode retail build) : Process ID 3036
2007-05-18 11:07:07 - ? [101] SQL Server <my computer name> version 8.00.760
(0 connection limit)
2007-05-18 11:07:07 - ? [102] SQL Server ODBC driver version 3.85.1025
2007-05-18 11:07:07 - ? [103] NetLib being used by driver is DBMSSHRN.DLL;
Local host server is
2007-05-18 11:07:07 - ? [310] 1 processor(s) and 768 MB RAM detected
2007-05-18 11:07:07 - ? [339] Local computer is <my computer name> running
Windows NT 5.2 (3790)
2007-05-18 11:07:07 - ! [364] The Messenger service has not been started -
NetSend notifications will not be sent
2007-05-18 11:07:07 - ? [129] SQLSERVERAGENT starting under Windows NT
service control
2007-05-18 11:07:07 - + [260] Unable to start mail session (reason: No mail
profile defined)
2007-05-18 11:07:07 - + [396] An idle CPU condition has not been defined -
OnIdle job schedules will have no effect
2007-05-18 11:08:03 - + [000] Schedule 2 has already been cached by job
0xD9C1E426A1AAD5498B92EDBEA79A8654
2007-05-18 11:10:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 2
2007-05-18 11:10:01 - + [163] 1 operations applied (0 remaining)
2007-05-18 11:12:09 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 3
2007-05-18 11:12:09 - + [000] Schedule 3 has already been cached by job
0x4CC373CEC320804D9AF67C7704B6F747
2007-05-18 11:13:23 - + [000] Schedule 4 has already been cached by job
0x6CC98A2943018F488AF45B20E63E1DC7
2007-05-18 11:15:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 4
2007-05-18 11:15:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 11:22:46 - + [000] Schedule 5 has already been cached by job
0xAE9A0B33E1E4374B9B60F807A7772999
2007-05-18 11:24:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 5
2007-05-18 11:24:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 11:32:02 - + [000] Schedule 6 has already been cached by job
0x05979EE4A61D87489C664CE2D68B0D24
2007-05-18 11:33:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 6
2007-05-18 11:33:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 11:35:23 - + [000] Schedule 7 has already been cached by job
0xBAE7D146168A5B4586DBB7333EE1D0C5
2007-05-18 11:36:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 7
2007-05-18 11:36:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 11:39:55 - + [000] Schedule 8 has already been cached by job
0x877BA9F8E7147E4EA91EB6F2E1E701C0
2007-05-18 11:41:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 8
2007-05-18 11:41:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 15:40:07 - + [000] Schedule 9 has already been cached by job
0xA5BBF8F9EA07834EA0B475B553911869
2007-05-18 15:41:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 9
2007-05-18 15:41:01 - + [163] 1 operations applied (0 remaining)
2007-05-18 15:42:47 - + [000] Schedule 10 has already been cached by job
0x13322C18AB3BC5409D40385C02129F54
2007-05-18 15:45:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 10
2007-05-18 15:45:01 - + [163] 1 operations applied (0 remaining)
2007-05-18 15:48:17 - + [000] Schedule 11 has already been cached by job
0x830F8A65D9A9BC4A914123CF6CB5E8F9
2007-05-18 15:50:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 11
2007-05-18 15:50:00 - + [163] 1 operations applied (0 remaining)
2007-05-18 16:02:05 - + [000] Schedule 12 has already been cached by job
0x6E49B2772349B84CB65BD39CC3C47810
2007-05-18 16:05:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 12
2007-05-18 16:05:01 - + [163] 1 operations applied (0 remaining)
2007-05-21 09:16:02 - + [000] Schedule 13 has already been cached by job
0xEFBDC763EB628A4AA037D27A483ADE7C
2007-05-21 09:21:16 - + [000] Schedule 14 has already been cached by job
0xB79CC4672770A94492543246E78D049F
2007-05-21 09:22:40 - + [000] Schedule 15 has already been cached by job
0xA812252789CF72418FA14FEC66C90089
2007-05-21 09:31:11 - + [000] Schedule 16 has already been cached by job
0xCDDBFEFA899ACE4DBADC96FFC6932279
2007-05-21 09:33:05 - + [000] Schedule 17 has already been cached by job
0x4010169385C38E478077F9AE67D7E298I was able to correct this error message 2007-05-18 11:07:07 - ! [364] The
Messenger service has not been started -
NetSend notifications will not be sent
I started this service but it still did now process.
"OriginalStealth" wrote:
> 2007-05-18 11:07:07 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
> unicode retail build) : Process ID
> 2007-05-18 11:07:07 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86
> unicode retail build) : Process ID 3036
> 2007-05-18 11:07:07 - ? [101] SQL Server <my computer name> version 8.00.760
> (0 connection limit)
> 2007-05-18 11:07:07 - ? [102] SQL Server ODBC driver version 3.85.1025
> 2007-05-18 11:07:07 - ? [103] NetLib being used by driver is DBMSSHRN.DLL;
> Local host server is
> 2007-05-18 11:07:07 - ? [310] 1 processor(s) and 768 MB RAM detected
> 2007-05-18 11:07:07 - ? [339] Local computer is <my computer name> running
> Windows NT 5.2 (3790)
> 2007-05-18 11:07:07 - ! [364] The Messenger service has not been started -
> NetSend notifications will not be sent
> 2007-05-18 11:07:07 - ? [129] SQLSERVERAGENT starting under Windows NT
> service control
> 2007-05-18 11:07:07 - + [260] Unable to start mail session (reason: No mail
> profile defined)
> 2007-05-18 11:07:07 - + [396] An idle CPU condition has not been defined -
> OnIdle job schedules will have no effect
> 2007-05-18 11:08:03 - + [000] Schedule 2 has already been cached by job
> 0xD9C1E426A1AAD5498B92EDBEA79A8654
> 2007-05-18 11:10:01 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 2
> 2007-05-18 11:10:01 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 11:12:09 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 3
> 2007-05-18 11:12:09 - + [000] Schedule 3 has already been cached by job
> 0x4CC373CEC320804D9AF67C7704B6F747
> 2007-05-18 11:13:23 - + [000] Schedule 4 has already been cached by job
> 0x6CC98A2943018F488AF45B20E63E1DC7
> 2007-05-18 11:15:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 4
> 2007-05-18 11:15:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 11:22:46 - + [000] Schedule 5 has already been cached by job
> 0xAE9A0B33E1E4374B9B60F807A7772999
> 2007-05-18 11:24:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 5
> 2007-05-18 11:24:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 11:32:02 - + [000] Schedule 6 has already been cached by job
> 0x05979EE4A61D87489C664CE2D68B0D24
> 2007-05-18 11:33:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 6
> 2007-05-18 11:33:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 11:35:23 - + [000] Schedule 7 has already been cached by job
> 0xBAE7D146168A5B4586DBB7333EE1D0C5
> 2007-05-18 11:36:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 7
> 2007-05-18 11:36:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 11:39:55 - + [000] Schedule 8 has already been cached by job
> 0x877BA9F8E7147E4EA91EB6F2E1E701C0
> 2007-05-18 11:41:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 8
> 2007-05-18 11:41:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 15:40:07 - + [000] Schedule 9 has already been cached by job
> 0xA5BBF8F9EA07834EA0B475B553911869
> 2007-05-18 15:41:01 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 9
> 2007-05-18 15:41:01 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 15:42:47 - + [000] Schedule 10 has already been cached by job
> 0x13322C18AB3BC5409D40385C02129F54
> 2007-05-18 15:45:01 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 10
> 2007-05-18 15:45:01 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 15:48:17 - + [000] Schedule 11 has already been cached by job
> 0x830F8A65D9A9BC4A914123CF6CB5E8F9
> 2007-05-18 15:50:00 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 11
> 2007-05-18 15:50:00 - + [163] 1 operations applied (0 remaining)
> 2007-05-18 16:02:05 - + [000] Schedule 12 has already been cached by job
> 0x6E49B2772349B84CB65BD39CC3C47810
> 2007-05-18 16:05:01 - + [162] Internal request (from SetJobNextRunDate
> [reason: schedule will not run again]) to deactivate schedule 12
> 2007-05-18 16:05:01 - + [163] 1 operations applied (0 remaining)
> 2007-05-21 09:16:02 - + [000] Schedule 13 has already been cached by job
> 0xEFBDC763EB628A4AA037D27A483ADE7C
> 2007-05-21 09:21:16 - + [000] Schedule 14 has already been cached by job
> 0xB79CC4672770A94492543246E78D049F
> 2007-05-21 09:22:40 - + [000] Schedule 15 has already been cached by job
> 0xA812252789CF72418FA14FEC66C90089
> 2007-05-21 09:31:11 - + [000] Schedule 16 has already been cached by job
> 0xCDDBFEFA899ACE4DBADC96FFC6932279
> 2007-05-21 09:33:05 - + [000] Schedule 17 has already been cached by job
> 0x4010169385C38E478077F9AE67D7E298