Forms authentication question

Hi,
The forms authentication works fine. However, after the prescribed timeout
period specified in the report server web.conifg report server autmatically
logs you off even when you are constantly using the report server.
To reproduce:
1. Set the forms auth timeout to a small number say 5 min
2. log on to report manager and access the reports every minute
3. After 5 minutes from logging in the report server rejects the cookie
although you have been actively using it.
Any suggestions?HI.
Sorry, is there any example code about the use of
Forms Auth. and reporting services?
Thanks in advance
S.Bertini
"j_a5" <j_a5@.hotmail.com> wrote in message
news:ORB0pOKpEHA.3848@.tk2msftngp13.phx.gbl...
> Hi,
> The forms authentication works fine. However, after the prescribed timeout
> period specified in the report server web.conifg report server
autmatically
> logs you off even when you are constantly using the report server.
> To reproduce:
> 1. Set the forms auth timeout to a small number say 5 min
> 2. log on to report manager and access the reports every minute
> 3. After 5 minutes from logging in the report server rejects the cookie
> although you have been actively using it.
> Any suggestions?
>|||See the following article that shows how to enable forms authentication
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
"Sergio Bertini" <sergio.bertini@.RIMUOVIMI.alcatel.it> wrote in message
news:uTDFvTKpEHA.3460@.TK2MSFTNGP15.phx.gbl...
> HI.
> Sorry, is there any example code about the use of
> Forms Auth. and reporting services?
> Thanks in advance
> S.Bertini
> "j_a5" <j_a5@.hotmail.com> wrote in message
> news:ORB0pOKpEHA.3848@.tk2msftngp13.phx.gbl...
> > Hi,
> > The forms authentication works fine. However, after the prescribed
timeout
> > period specified in the report server web.conifg report server
> autmatically
> > logs you off even when you are constantly using the report server.
> > To reproduce:
> > 1. Set the forms auth timeout to a small number say 5 min
> > 2. log on to report manager and access the reports every minute
> > 3. After 5 minutes from logging in the report server rejects the cookie
> > although you have been actively using it.
> > Any suggestions?
> >
> >
>

formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
2
> decimals after the period - i.e. 144.55? When I create the column in EM wi
th
> the smallmoney datatype, the precision field is grayed out. Isn't there so
me
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
2
> decimals after the period - i.e. 144.55? When I create the column in EM wi
th
> the smallmoney datatype, the precision field is grayed out. Isn't there so
me
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--sql

formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
Dan D.
Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John
|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

formatting smallmoney to 2 decimals

Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
decimals after the period - i.e. 144.55? When I create the column in EM with
the smallmoney datatype, the precision field is grayed out. Isn't there some
way to put a format code like "####.##" somewhere?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
SQL Server will stored smallmoney with 4 decimal places regardless,
formatting output should be done on the client.
John|||Dan
DECIMAL(5,2) or NUMERIC datatypes
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01B59869-B53E-4442-97AB-94B376C26390@.microsoft.com...
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only
> 2
> decimals after the period - i.e. 144.55? When I create the column in EM
> with
> the smallmoney datatype, the precision field is grayed out. Isn't there
> some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.|||On 7 May, 14:21, Dan D. <D...@.discussions.microsoft.com> wrote:
> Using SS2000 SP4. Is there anyway to default the smallmoney column to only 2
> decimals after the period - i.e. 144.55? When I create the column in EM with
> the smallmoney datatype, the precision field is grayed out. Isn't there some
> way to put a format code like "####.##" somewhere?
> Thanks,
> --
> Dan D.
Use DECIMAL/NUMERIC. Avoid MONEY or SMALLMONEY for currency values,
there are two many problems associated with the money types.
Do remember that SQL Server has no real control over how numeric
values are displayed. In all cases it is your client software that
determines display formatting, not SQL Server.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Formatting question

I want to show a parameter date minus 1 year, how can I do this?
="PERIOD MINUS 1 YEAR: " & Parameters!startdate.Value & " to " &
Parameters!stopdate.ValueTry:
="PERIOD MINUS 1 YEAR: " &
System.DateTime.Parse(Parameters!startdate.Value).AddYears(-1).ToShortDateString()
& " to " &
System.DateTime.Parse(Parameters!stopdate.Value).AddYears(-1).ToShortDateString()
or something simular
"Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
news:33AB832F-0620-4A7C-B2FC-5D38A36C7429@.microsoft.com...
>I want to show a parameter date minus 1 year, how can I do this?
> ="PERIOD MINUS 1 YEAR: " & Parameters!startdate.Value & " to " &
> Parameters!stopdate.Value|||That is the shizzle my fizzle!!
(or however that should sound, thanks!)
Chris
"Oleg Yevteyev" wrote:
> Try:
> ="PERIOD MINUS 1 YEAR: " &
> System.DateTime.Parse(Parameters!startdate.Value).AddYears(-1).ToShortDateString()
> & " to " &
> System.DateTime.Parse(Parameters!stopdate.Value).AddYears(-1).ToShortDateString()
> or something simular
> "Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
> news:33AB832F-0620-4A7C-B2FC-5D38A36C7429@.microsoft.com...
> >I want to show a parameter date minus 1 year, how can I do this?
> >
> > ="PERIOD MINUS 1 YEAR: " & Parameters!startdate.Value & " to " &
> > Parameters!stopdate.Value
>
>sql

Formatting Database Server Need Procedure for Restoring Database

Hi Chris
When restoring a new database there is usually a period at the beginning
when no bars appear. The larger the database is the longer it takes.
Did you check that the disc was not fragmented before you restored the
database, also did you check there was ample space for the database?
The following should give you a good idea of what you will need to do
http://support.microsoft.com/kb/314546
You need to service pack SQL Server on the new host to the same level as the
existing machine.
John
"Chris Witthoft" wrote:

> Hello,
> I have a database server running Windows 2000 server sp4, sql server 2000
> sp3. I want to format this server and start fresh with an install of wind
ows
> 2003 server standard edition and reload sql server 2000. My sql server
> knowledge is very basic and I need to have a procedure for bringing the
> database back to its current state after the format.
> I have set up a test server. I loaded Win 2003 server, sql server 2000, a
nd
> sp3 for sql. I don't know if I have to restore my master,model, ect. back
ups
> or if I can just restore my production database?
> I copied a .bak file of my database to the test server and tried restoring
> it using enterprise manager. Of course the data and log file locations ar
e
> going to be on one disk instead of two like the production server but I ma
de
> the neccearry change under options. When I click ok on the restore it com
es
> up with the restore progress windows but its already been and hour and no
> progress. I do notice a created .mdf file in the restore path but no
> indication of it doing anything else.
> Your help is greatly apprecaited. Please contact me at
> chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
> Thanks,
> ChrisHello,
I have a database server running Windows 2000 server sp4, sql server 2000
sp3. I want to format this server and start fresh with an install of window
s
2003 server standard edition and reload sql server 2000. My sql server
knowledge is very basic and I need to have a procedure for bringing the
database back to its current state after the format.
I have set up a test server. I loaded Win 2003 server, sql server 2000, and
sp3 for sql. I don't know if I have to restore my master,model, ect. backup
s
or if I can just restore my production database?
I copied a .bak file of my database to the test server and tried restoring
it using enterprise manager. Of course the data and log file locations are
going to be on one disk instead of two like the production server but I made
the neccearry change under options. When I click ok on the restore it comes
up with the restore progress windows but its already been and hour and no
progress. I do notice a created .mdf file in the restore path but no
indication of it doing anything else.
Your help is greatly apprecaited. Please contact me at
chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
Thanks,
Chris|||Hi Chris
When restoring a new database there is usually a period at the beginning
when no bars appear. The larger the database is the longer it takes.
Did you check that the disc was not fragmented before you restored the
database, also did you check there was ample space for the database?
The following should give you a good idea of what you will need to do
http://support.microsoft.com/kb/314546
You need to service pack SQL Server on the new host to the same level as the
existing machine.
John
"Chris Witthoft" wrote:

> Hello,
> I have a database server running Windows 2000 server sp4, sql server 2000
> sp3. I want to format this server and start fresh with an install of wind
ows
> 2003 server standard edition and reload sql server 2000. My sql server
> knowledge is very basic and I need to have a procedure for bringing the
> database back to its current state after the format.
> I have set up a test server. I loaded Win 2003 server, sql server 2000, a
nd
> sp3 for sql. I don't know if I have to restore my master,model, ect. back
ups
> or if I can just restore my production database?
> I copied a .bak file of my database to the test server and tried restoring
> it using enterprise manager. Of course the data and log file locations ar
e
> going to be on one disk instead of two like the production server but I ma
de
> the neccearry change under options. When I click ok on the restore it com
es
> up with the restore progress windows but its already been and hour and no
> progress. I do notice a created .mdf file in the restore path but no
> indication of it doing anything else.
> Your help is greatly apprecaited. Please contact me at
> chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
> Thanks,
> Chris