Deploying updated report but still seeing old version

Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >

Deploy successful, but updated report not showing...

Using VS2005 to deploy an updated report on a machine running SQL 2005
Reporting Services.
VS states that the deployment was successful, but the old version of the
report is what's getting run.
Can't reset the Default Website on that machine as it's running the web
services behind our application.
What have I missed?
Kyle JedrusiakOn Dec 4, 11:47 am, "Kyle Jedrusiak"
<kjedrus...@.princetoninformation.com> wrote:
> Using VS2005 to deploy an updated report on a machine running SQL 2005
> Reporting Services.
> VS states that the deployment was successful, but the old version of the
> report is what's getting run.
> Can't reset the Default Website on that machine as it's running the web
> services behind our application.
> What have I missed?
> Kyle Jedrusiak
Try deleting the report and re-deploying it. It worked for me.

Deny login for SQL Server Authenticated accounts

Hi,
I want to prevent users from logging into a database temporarily (once a
weekly for a few hours), and once I've updated the tables in the database, I
need to allow all users access again.
I have looked at the system stored procedure sp_denylogin, but this only
works for NT Authenticated accounts. Is there an equivalent system stored
procedure for denying logins for accounts created with AQL Server
Authentication?
Your help will be greatly appreciated.In the script that updates this, place at the top:
ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE
At the end of the script, put:
ALTER DATABASE databasename SET MULTI_USER
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>|||Hi,
I recommend you to start the database in SINGLE USER mode or set the
database to RESTRICTED mode before changing rhe schema.
ALTER DATABASE <DBNAME> set SINGLE_USER
or
ALTER DATABASE <DBNAME> set RESTRICTED_USER
Once the schema change is over you set back to multi user mode.
ALTER DATABASE <DBNAME> set MULTI_USER
Thanks
Hari
SQL Server MVP
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
> I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>|||Hi Hari,
Tried running this in the SQL Query Analyser, and appears to take forever.
It has now been running for over 30 minutes and still has a status of
"executing query batch"
Is this normal?
Eric
"Hari Prasad" wrote:
> Hi,
> I recommend you to start the database in SINGLE USER mode or set the
> database to RESTRICTED mode before changing rhe schema.
>
> ALTER DATABASE <DBNAME> set SINGLE_USER
> or
> ALTER DATABASE <DBNAME> set RESTRICTED_USER
>
> Once the schema change is over you set back to multi user mode.
> ALTER DATABASE <DBNAME> set MULTI_USER
>
> --
> Thanks
> Hari
> SQL Server MVP
> "Eric" <Eric@.discussions.microsoft.com> wrote in message
> news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> > Hi,
> >
> > I want to prevent users from logging into a database temporarily (once a
> > weekly for a few hours), and once I've updated the tables in the database,
> > I
> > need to allow all users access again.
> >
> > I have looked at the system stored procedure sp_denylogin, but this only
> > works for NT Authenticated accounts. Is there an equivalent system stored
> > procedure for denying logins for accounts created with AQL Server
> > Authentication?
> >
> > Your help will be greatly appreciated.
> >
> >
>
>|||It can be if someone is using the database. You can force
the connections to be killed with the termination clause in
the alter database:
ALTER DATABASE YourDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-Sue
On Mon, 25 Oct 2004 17:49:03 -0700, "Eric"
<Eric@.discussions.microsoft.com> wrote:
>Hi Hari,
>Tried running this in the SQL Query Analyser, and appears to take forever.
>It has now been running for over 30 minutes and still has a status of
>"executing query batch"
>Is this normal?
>Eric
>
>"Hari Prasad" wrote:
>> Hi,
>> I recommend you to start the database in SINGLE USER mode or set the
>> database to RESTRICTED mode before changing rhe schema.
>>
>> ALTER DATABASE <DBNAME> set SINGLE_USER
>> or
>> ALTER DATABASE <DBNAME> set RESTRICTED_USER
>>
>> Once the schema change is over you set back to multi user mode.
>> ALTER DATABASE <DBNAME> set MULTI_USER
>>
>> --
>> Thanks
>> Hari
>> SQL Server MVP
>> "Eric" <Eric@.discussions.microsoft.com> wrote in message
>> news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
>> > Hi,
>> >
>> > I want to prevent users from logging into a database temporarily (once a
>> > weekly for a few hours), and once I've updated the tables in the database,
>> > I
>> > need to allow all users access again.
>> >
>> > I have looked at the system stored procedure sp_denylogin, but this only
>> > works for NT Authenticated accounts. Is there an equivalent system stored
>> > procedure for denying logins for accounts created with AQL Server
>> > Authentication?
>> >
>> > Your help will be greatly appreciated.
>> >
>> >
>>

Deny login for SQL Server Authenticated accounts

Hi,
I want to prevent users from logging into a database temporarily (once a
weekly for a few hours), and once I've updated the tables in the database, I
need to allow all users access again.
I have looked at the system stored procedure sp_denylogin, but this only
works for NT Authenticated accounts. Is there an equivalent system stored
procedure for denying logins for accounts created with AQL Server
Authentication?
Your help will be greatly appreciated.In the script that updates this, place at the top:
ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE
At the end of the script, put:
ALTER DATABASE databasename SET MULTI_USER
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>|||Hi,
I recommend you to start the database in SINGLE USER mode or set the
database to RESTRICTED mode before changing rhe schema.
ALTER DATABASE <DBNAME> set SINGLE_USER
or
ALTER DATABASE <DBNAME> set RESTRICTED_USER
Once the schema change is over you set back to multi user mode.
ALTER DATABASE <DBNAME> set MULTI_USER
Thanks
Hari
SQL Server MVP
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
> I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>|||Hi Hari,
Tried running this in the SQL Query Analyser, and appears to take forever.
It has now been running for over 30 minutes and still has a status of
"executing query batch"
Is this normal?
Eric
"Hari Prasad" wrote:

> Hi,
> I recommend you to start the database in SINGLE USER mode or set the
> database to RESTRICTED mode before changing rhe schema.
>
> ALTER DATABASE <DBNAME> set SINGLE_USER
> or
> ALTER DATABASE <DBNAME> set RESTRICTED_USER
>
> Once the schema change is over you set back to multi user mode.
> ALTER DATABASE <DBNAME> set MULTI_USER
>
> --
> Thanks
> Hari
> SQL Server MVP
> "Eric" <Eric@.discussions.microsoft.com> wrote in message
> news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
>
>|||It can be if someone is using the database. You can force
the connections to be killed with the termination clause in
the alter database:
ALTER DATABASE YourDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-Sue
On Mon, 25 Oct 2004 17:49:03 -0700, "Eric"
<Eric@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Hari,
>Tried running this in the SQL Query Analyser, and appears to take forever.
>It has now been running for over 30 minutes and still has a status of
>"executing query batch"
>Is this normal?
>Eric
>
>"Hari Prasad" wrote:
>

Deny login for SQL Server Authenticated accounts

Hi,
I want to prevent users from logging into a database temporarily (once a
weekly for a few hours), and once I've updated the tables in the database, I
need to allow all users access again.
I have looked at the system stored procedure sp_denylogin, but this only
works for NT Authenticated accounts. Is there an equivalent system stored
procedure for denying logins for accounts created with AQL Server
Authentication?
Your help will be greatly appreciated.
In the script that updates this, place at the top:
ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE
At the end of the script, put:
ALTER DATABASE databasename SET MULTI_USER
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>
|||Hi,
I recommend you to start the database in SINGLE USER mode or set the
database to RESTRICTED mode before changing rhe schema.
ALTER DATABASE <DBNAME> set SINGLE_USER
or
ALTER DATABASE <DBNAME> set RESTRICTED_USER
Once the schema change is over you set back to multi user mode.
ALTER DATABASE <DBNAME> set MULTI_USER
Thanks
Hari
SQL Server MVP
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
> Hi,
> I want to prevent users from logging into a database temporarily (once a
> weekly for a few hours), and once I've updated the tables in the database,
> I
> need to allow all users access again.
> I have looked at the system stored procedure sp_denylogin, but this only
> works for NT Authenticated accounts. Is there an equivalent system stored
> procedure for denying logins for accounts created with AQL Server
> Authentication?
> Your help will be greatly appreciated.
>
|||Hi Hari,
Tried running this in the SQL Query Analyser, and appears to take forever.
It has now been running for over 30 minutes and still has a status of
"executing query batch"
Is this normal?
Eric
"Hari Prasad" wrote:

> Hi,
> I recommend you to start the database in SINGLE USER mode or set the
> database to RESTRICTED mode before changing rhe schema.
>
> ALTER DATABASE <DBNAME> set SINGLE_USER
> or
> ALTER DATABASE <DBNAME> set RESTRICTED_USER
>
> Once the schema change is over you set back to multi user mode.
> ALTER DATABASE <DBNAME> set MULTI_USER
>
> --
> Thanks
> Hari
> SQL Server MVP
> "Eric" <Eric@.discussions.microsoft.com> wrote in message
> news:EE89773B-5F28-4760-B1AF-8C0347A69DF9@.microsoft.com...
>
>
|||It can be if someone is using the database. You can force
the connections to be killed with the termination clause in
the alter database:
ALTER DATABASE YourDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-Sue
On Mon, 25 Oct 2004 17:49:03 -0700, "Eric"
<Eric@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Hari,
>Tried running this in the SQL Query Analyser, and appears to take forever.
>It has now been running for over 30 minutes and still has a status of
>"executing query batch"
>Is this normal?
>Eric
>
>"Hari Prasad" wrote: